
Hello,
i am applying Bank Account Reconciliation with import statement functionality on NAV 2018:
So, using a Data Exchange Definition, i tested with a CSV file; it worked successfully:
The question is:
A real file from bank will have my deposits as Credit, however the opposite sign will be in Bank account ledger entry.
how the bank reconciliation Match Automatically will work? (it will not match amounts)
Regards,
David
You need to add another Column Number for the Credit in the field mapping of posting definitions.
E.g
Column No.........Column Caption.......Field ID
1 Date 5
2 Desc 6
3 Account 24
4 Debit 7 (Mutlipler of -1)
5 Credit 7