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?
*This post is locked for comments
Then you can write a new xml port that supports your need and switch to that object number in your setup.
That will override the standard xml port used.
docs.microsoft.com/.../across-how-to-set-up-data-exchange-definitions
I am, yes. I've been writing a few extra pages etc, so happy to do some customization for this.
Thanks.
Then it is probably the easiest way to write a small customization that fix that issue in the import.
Are you on a version that supports AL?
Hi Inge,
I am using the following setup for Bank Statement imports. I have several feeds working okay, but they all have one column for the debits/credits.
However the statement that is causing a problem has two columns (one debit and the other credit) both with absolute values.
Normally that is fine, because you can set the multiplier on the debit to -1* and map the two fields to "Statement Amount" (and set the two as optional).
But that only works if the empty credit/debit fields are blank. In this case they are not and have zeros. This is causing the problem as the debit always overwrites the credit column.
Hope that makes sense, but any help is appreciated.
Thanks
Joe
What method are you using for importing the bank statement and what format does it have?
Hi Laban,
Did you get any joy with this? I'm having the same issue.
Kind Regards
Joe
Hello,
Is there a navision solution when the debit column is not blank (i.e. has zeros) when the credit column is populated?
Possibly converting zero's in debit column to blank?
Editing the bank excel is sub-optimal.
Regards,
Laban.
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
Use 1225 Data Exch. Field Mapping table.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (