You’re offline. This is a read only version of the page.
815
Hi,
AX 2012 R3 CU9.
We have exported a MT940 file from Barclays.Net - UK and tried to import using bank import routine. MT940 port is enabled.
This file has a tag 28 instead of 28C which is causing issue.
It has multiple 28 tag lines which is causing AX to create new bank import for each transaction.
If I update the file and change 28 to 28C and also remove all line for 28 tag and keep only first one then file gets imported but this is not a solution as this can't be done for the file every time it is imported.
Has anyone dealt with this scenario?
Thanks,
*This post is locked for comments
I have the same question (0)Below solution is applied:
New AX routine is developed that will read the Barclays downloaded MT940 file and create a new txt file with below changes. User will use newly generated file to import the statement in to AX and change the statement date accordingly and click on Validate to confirm which will populate any missing fields.
1- Add C after tag :28 for the first actual transaction only in the file (Actual transaction contains Debit or Credit amount).
2- Ignore all balance only transactions when reading the downloaded file (Barclays file contains balance only transactions as well so new AX routine will ignore these transactions when reading the downloaded file).
3- Do not add 62F and 64 tag lines for actual transactions in the file (Actual transaction contains Debit or Credit amount).
4- Add 62F and 64 tags which are closing balance entries for last actual transaction only which will give the closing balance on the statement. If you add 62F and 64 lines for all actual transactions then AX will pick up the first actual transaction closing balance as final closing balance which will be wrong.
Barclays downloaded file is a mess.
Share
Report
All responses (
Answers (
