Import Bank Statement Error

(1) Share

Report

Posted on by Micheleish

105

Hello,

I am attempting to import a csv file into my bank reconcilation and getting this error message, how can I import a field that is blank (description field)? The Column No. is 11 for the text I need to import.

This is my data exchange column definition setup: (the date field was giving errors too so I just changed it to text, however I don't know if that will work either because I haven't been able to import it yet because of error on column 11.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Valentin Castravet 31,452 Super User 2025 Season 2 on at

Like (0)

Report

In your data exchange definition, go the line definitions and select Field Mapping

And then find your description column and check the Optional column to yes

Valentin Castravet

Zander ERP Services

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (1)

Report

you could also pad the blank with zeros since BC is asking for 75 characters. you need the padding to fill up the spaces.

As Valentin says BC won't ask for that field if made optional. you could try different methods to fit your needs.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,649 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the following can give you some hints as well.

Dynamics 365 Business Central: Add more custom processing when importing Bank Statement (Bank Export/Import Setup)

https://yzhums.com/44582/

Thanks.

ZHU

Was this reply helpful? Yes No
M0HAN SINGH 366 on at

Like (0)

Report

Hi, Please see screenshot, Blank Zero checkbox in Data Exchange Definition will help you to solve this. After enable this you can import the csv without any error even if that columns does'nt have data.

Was this reply helpful? Yes No