Bank Manager: 'File format is invalid. String was not recognized as a valid DateTime’ import error

Summary

Learn how to fix the Bank Manager error below in Sage 200 Evolution.

Description

The following error message may display,

Image

when attempting to import a Bank Manager import file after selecting the ABSA Internet Banking, and perhaps other Statement Provider options.

Image

Resolution

The following steps explain how to resolve the abovementioned query:

1. Close Evolution on the local workstation where the above error message is observed.

2. Go to the local PC’s Control Panel | Region (Regional Settings) | Additional Settings.

3. Change the short date format to yyyy/mm/dd

4. When done, click the Apply button below.

 Image

5. Re-open the Evolution company and you should now be able to import the bank statement.

6. If, however the same, or other error messages are observed, close the company, restart the PC, re-open the company and try again to import.

 

Solution Properties

Solution ID
200312123812414
Last Modified Date
Wed Mar 23 14:23:32 UTC 2022
Views
0