Plaza 365
Plaza 365

No results found for your search

RegisterLog in

2

Bank Reconciliation File with two Columns! Debit and Credit!

Visit article

#automatedreconciliation

#bankreconciliation

#dataexchangedefinition

#wellsfargo

Dynamics 365 Business Central

Category

Oct 2, 2023

Published date

Text

Article Type

AI Summary

  • The article discusses the use of Data Exchange Definitions in Microsoft Dynamics 365 Business Central to import bank statements for bank reconciliation.
  • The author highlights the challenge of importing Wells Fargo bank statement files due to the presence of two columns for amounts, one for debit amounts and the other for credit amounts.
  • To address this issue, the author suggests replacing all 0.00 values in the export file with blanks using the Notepad's replace function.
  • The article explains the need to modify the Column Definitions in the Data Exchange Definition to recognize the two columns for amounts and assign a length to each column.
  • The Field Mapping also needs to be updated to accept amounts from either of the amount columns into the one field in Business Central.
  • The author recommends selecting the optional field and setting the multiplier to negative one (-1.00) to change the sign of the amount coming in from the bank file.
  • Additionally, the article advises selecting "overwrite value" for Column 14 to ensure that if it contains the amount, it will overwrite the empty value in Column 13.
  • The article concludes by stating that by following the steps provided, users can successfully import Wells Fargo transaction activity and efficiently reconcile their bank account to Microsoft Dynamics 365 Business Central.

Registered users can view the full text for FREE!

Sign In Now!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.