Hello,
I am trying to upload banking statements in CSV-form NAV2017 from ING (Bank).
The CSV gives info about the Transactions in two different columns. The first column describes if it is a credit (C) or a debit (D), and the other the amount of the transaction.
In NAV I only have the column "Stated Amount". Can I create a conditional transformation that checks the column C/D and changes the value from "Amount" accordingly?
How do I resolve this?