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

DATA EXCHANGE DEFINITION FOR RBC CANADA

(5) Share

Report

Posted on by MD-01071455-0

153

Hi community,

I'm trying to setup Data exchange definitions for RBC Canada Bank, but when I'm trying to import bank statement (csv) its showing following error.

The file that you are trying to import, new RBC CAD (1155)_Sep 01 2025_Nov 30 2025.csv, is different from the specified Bank Statement Import, RBC CAD.

The value in line 1, column 1 has incorrect format or type.
Expected format: Date, according to the Data Format and Data Formatting Culture of the Data Exch. Column Def.
Actual value: "Posted Date".

As you can see I did following setup.

1- DATA EXCHANGE DEFINITION

2- FIELD MAPPING

3- CSV EXCEL FILE

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

Dynamics 365 Business Central migration

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

Like (1)

Report

try to change the Type from "Bank Statement Import" to "Generic import".
I think the Bank Statement Import requires an XML file to be selected.

And in Data Exchange Definition indicate "Header Lines" = 1 - so that the column headers are ignored and it is not trying to import "Posting Date" value as date, but starts processing only from 2nd row.

And not sure if the Reading/Writing XML port should be indicated, as You are not using the XML files - You should indicate just the Reading/Writing Codeunit that is processing this import.

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 4,106 on at

Like (1)

Report

Namaste @MD-01071455-0

As per the Data Definition , Header lines is zero

Solution

Add Header Lines as '1' and import file

Or

Remove Headers and import

Warm Regards

Pallavi Phade

www.linkedin.com/in/pallaviphade131116

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, hope the following can give you some hints.

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

https://yzhums.com/44582/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

Like (0)

Report

You can recheck this post:
Solved: Error Message when attempting to import CSV bank transactions

I was able to create a simple CSV file import to Payment Reconciliation journal.
Of course the mappings need to be adjusted...

This setup on Field mapping works. The Description might be better to link to Transaction Text not description, but this You can test out.

Was this reply helpful? Yes No