SBX - Search With Button

SBX - Forum Post Title

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

Microsoft Dynamics NAV Forum

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

Question Status

Verified

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
Dmitry Katson responded on 31 Mar 2017 6:04 AM
My Badges
Suggested Answer

Use 1225 Data Exch. Field Mapping table.

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

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

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
Susy_Uber responded on 19 Jun 2017 12:53 AM
My Badges
Verified Answer

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
Dmitry Katson responded on 31 Mar 2017 6:04 AM
My Badges
Suggested Answer

Use 1225 Data Exch. Field Mapping table.

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

Reply

SBX - Two Col Forum

SBX - Migrated JS