Small and medium business | Business Central, N...

Issue importing bank statement

(0) Share

Report

Posted on by Rajendra sahu

130

Hello everyone - Getting some error while importing bank statement.

Please see attached screen shot.

please suggest Thank you!

2438.Capture.PNG

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

JAngle 157 on at

Like (0)

Report
Copy link

Link copied!

The data exchange definition date format may need reviewing judging by the message. The row you have defined for that part of the import will probably need the format dd-MM-yyyy (case sensitive). If the issue persists you could change it to a text type field instead.

Was this reply helpful? Yes No
Suggested answer

Laeticia Cunha Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Rajendra,

This error message could be related with the format of the date in the file that is is not accordingly with the one define in the Bank Statement Import.

To validated the format the the system is prepared to received, could you please check the following steps:

1. Search for Data Exchange Definition and open the corresponding one, that is associated in your Bank Account:

2. Go to the Column Definitions Tab and in the column 4,please validate if you have the correct Data Format and Data Formatting Culture

Hope this information will help you to move forward.

Kind regards,

Laeticia Cunha

Please see our Dynamics 365 Business Central Support Team Blog for helpful information:

https://dynamics.microsoft.com/en-us/business-central/capabilities/

Don't forget to help the community by verifying the answer or at least like the suggestion if it did help in any way. It will let others know that the topic has verified answer and was a beneficial to you.

Was this reply helpful? Yes No
RoshanRafeek 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Rajendra,

Use m/d/yyyy for date formatting in the data exchange definition.

Was this reply helpful? Yes No