Finance | Project Operations, Human Resources, ...

Error during importing MT940 file for Saudi Region (Version AX2009)

(0) Share

Report

Posted on by naveen singh

780

Hi All,

I am getting error while importing bank statement MT940 file. Anyone can please help me on this.

Error - Invalid document schema. The following error was returned: The 'schemas.microsoft.com/.../BankStmt:CashBalanceAmount' element is invalid - The value '31.382' is invalid according to its datatype 'schemas.microsoft.com/.../BankStmt:AxdExtType_BankStmtISODecimal' - The FractionDigits constraint failed.
View the exception log for more details.

Thanks

Naveen

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi Naveen,

Has any customization been done to BankStmtISODecimal EDT to restrict the number of decimals? Basically, this error means that the value is not complying with the datatype.

Was this reply helpful? Yes No
naveen singh 780 on at

Like (0)

Report
Copy link

Link copied!

No Gunjan,

We have not done any customization on this EDT.

Was this reply helpful? Yes No
vinitgoyal2005 6,332 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you try making the values 31.382 to 31.38 and import?

Was this reply helpful? Yes No
naveen singh 780 on at

Like (0)

Report
Copy link

Link copied!

Thanks Vinit.

up to two decimal is working, but for saudi region we have to do rounding as the values coming in three decimal. Could you please guide me where we have to change this.

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Naveen,

Try changing it in the EDT. Go to BankStmtISODecimal and Change the property "No. of decimals" to 3.

Do a DB synch after that.

Was this reply helpful? Yes No
Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report
Copy link

Link copied!

Hi Naveen,

You can change the No of Decimal Property to 3 of EDT BankStmtISODecimal but please test the financial transcations after that. If I remember correctly, all the ledger transcations in AX needs to be 2 decimal places. There are risks of penny differences and voucher imbalance issues etc. So this change may impact the system significantly. Please take due diligence.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Vinit is correct. Please test through all the financial transactions. I assumed you would have already tested as they are on AX 2009.

Was this reply helpful? Yes No