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,935 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,208 Moderator on at

Like (1)

Report
Copy link

Link copied!

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 97,970 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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