I'm looking for insights on an issue where a custom (derived) ABR / Camt.053 ER format mapping works correctly when run directly from the ER configurations workspace, but the custom mapping is completely ignored during actual bank statement import.
Environment version is D365 F&SCM 10.0.47. Reconcile option is enabled in the bank account.
We recently migrated from MT940 to CAMT.053 format. Our bank provides the CAMT.053 XML with two identifiers:
We need Statement ID = "99" (from ElctrncSeqNb), NOT the long technical bank ID from <Stmt><Id>.
1. Created a derived configuration from Microsoft's "ABR Camt.053 format". ( I tried with Camt.053 format as well)
2. In the derived format, changed the StatementIdentification binding from:
format.Document.BkToCstmrStmt.Stmt.Id.Data.String
to:
NUMBERFORMAT(format.Document.BkToCstmrStmt.Stmt.ElctrncSeqNb.Data.Dcml, "#")
3. Completed the version and set it as "Default for model mapping"
4. Assigned the custom format in Bank Statement Format setup
When it is tested from ER Run directly from Configurations workspace, it gives the right statement id, but not when statements are imported from Bank statememt form.
Has anyone customized the Statement ID mapping in ABR Camt.053?
Any insights, experiences, or pointers to relevant documentation would be greatly appreciated.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
10
Share
Report
All responses (
Answers (
