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 |
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156