Does anyone know how to map credit debit amount fields for bank statement import in Business Central?
There is only statement amount field to map in data exchange definition.
Does anyone know how to map credit debit amount fields for bank statement import in Business Central?
There is only statement amount field to map in data exchange definition.
It is typical for banks to give you two columns when we really need just one for the amount. I would reach out to your bank to see if there is another option for one column. If not, you will need to combine the values into one column before you import.
Just try to adjust your excel file, instead of two column for debit and credit, maintain one column for +,-
Amount |
1,000.00 |
- 500.00 |
- 250.00 |
200.00 |
10.00 |
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156