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

All responses (5)

Answers (0)

Suggested answer

Khushbu Rajvi. 16,318 Super User 2025 Season 1 on at

Like (1)

Report

Error Message when attempting to import CSV bank transactions

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
JF-09050206-0 8 on at

Like (0)

Report

Error Message when attempting to import CSV bank transactions

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.
Gerardo Rentería Ga... 18,643 Most Valuable Professional on at

Like (0)

Report

Error Message when attempting to import CSV bank transactions

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

Best
Suggested answer

Jainam M. Kothari 7,921 on at

Like (1)

Report

Error Message when attempting to import CSV bank transactions

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
YUN ZHU 82,673 Super User 2025 Season 1 on at

Like (2)

Report

Error Message when attempting to import CSV bank transactions

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