Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I am working on a Bank Statement Import Data Exchange Definition. The bank detail transaction file from the bank contains a debit and credit column instead of a single column for the amount. How can I configure the Data Exchange Definition to import the debit and credit amounts into the Statement Amount field?
Use 1225 Data Exch. Field Mapping table.
The following solution will only work if the debit column is blank when credit column is populated and vice versa.
In field mapping:
- set debit column to statement amount and tick optional
- set credit column to statement amount and tick optional