[NAV 2016] Importing Bank Account Statement using Data Exchange Definitions

Aravindh_Navision

Hi Friends,

I need to import Bank Account Statement (CSV) in Bank Account Reconciliation table using Data Exchange Definitions. I have done the required configurations in Data Exchange Definition page. In Bank Statement, it has an Amount column with all +ve values. In another column, a character 'C' or 'D' is there against the Amount. I need to display the Amount value (5500.00) against 'D' as -ve value (as -5500.00).

How can I achieve this? Can anyone help me to solve this?

Thanks in Advance.

Milek212mm

Hi! Try this: in column definition ,put "C" as negative sign identifier for that column with C or D,and then in Field mapping map that column and column with amount with the same target field (amount in NAV).

Milek212mm

Hi! Try this: in column definition ,put "C" as negative sign identifier for that column with C or D,and then in Field mapping map that column and column with amount with the same target field (amount in NAV).

Aravindh_Navision

Dear Milek212mm, Thank you very much. It works awesome :-)