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

Error Message when attempting to import CSV bank transactions

(2) Share

Report

Posted on by JF-09050206-0

Hi there,

I am trying to import the statement lines in the Payment reconciliation journal in Business Central using the Data Exchange Definition , but it returns with no values. Any idea as to what I am missing here?

Thanks in advance for your help.

Judy

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

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

Like (2)

Report

Hi, It seems to be a problem with the Data Exchange Definition settings. I hope the settings in the following post 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

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions

https://learn.microsoft.com/en-us/dynamics365/business-central/ubb/masterdata/dataexchangedefinitions

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,384 Most Valuable Professional on at

Like (0)

Report

Hi, good day
I hope this can help you, and give you some hints.https://valentincastravet.com/create-a-bank-statement-import-format/

Best

Was this reply helpful? Yes No
JF-09050206-0 8 on at

Like (0)

Report

Thank you for your responses. However, I run into this issue for a Payment Reconciliation journal. I have made progress and have managed to bring in the date and amount but from where does it pick the Account Type to be Customer or Vendor?

Thanks in advance.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,838 Super User 2025 Season 2 on at

Like (1)

Report

https://learn.microsoft.com/en-us/dynamics365/business-central/receivables-how-reconcile-payments-auto-application

https://learn.microsoft.com/en-us/dynamics365/business-central/receivables-how-set-up-payment-application-rules

Was this reply helpful? Yes No