Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

Question Status

Verified
sbuczek asked a question on 15 Mar 2017 1:33 PM

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?

Reply
Suggested Answer
Dmitry Katson responded on 31 Mar 2017 6:04 AM

Use 1225 Data Exch. Field Mapping table.

msdn.microsoft.com/.../dn495319(v=nav.90).aspx

Reply
Verified Answer
Susy_Uber responded on 19 Jun 2017 12:53 AM

Hi sbuczek,

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

Regards,

Susy

Reply
Verified Answer
Susy_Uber responded on 19 Jun 2017 12:53 AM

Hi sbuczek,

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

Regards,

Susy

Reply
Suggested Answer
Dmitry Katson responded on 31 Mar 2017 6:04 AM

Use 1225 Data Exch. Field Mapping table.

msdn.microsoft.com/.../dn495319(v=nav.90).aspx

Reply