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
Vinit is correct. Please test through all the financial transactions. I assumed you would have already tested as they are on AX 2009.
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.
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.
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.
Hi,
Can you try making the values 31.382 to 31.38 and import?
No Gunjan,
We have not done any customization on this EDT.
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.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (