Options

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

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.

Best Answer

Answers

  • Options
    Aravindh_NavisionAravindh_Navision Member Posts: 258
    Dear Milek212mm, Thank you very much. It works awesome :-)
Sign In or Register to comment.