Источник:
http://sinedax.blogspot.com/2018/11/...0022-bank.html
==============
Hi All,
In Microsoft Dynamics 365 for Finance and Operations, against the Advanced bank reconciliation Module, we can import electronic bank statements and automatically
reconcile them.
The article below will explain the set up processes for
reconciliation.
Advanced bank reconciliation setup process
Days ago I spent some time in order to handle a
new XML Tag.
The link below explain the basic setup. The Bank Statement import varies, depending on the format of your electronic bank statement. F&O supports
three bank statement formats out of the box: ISO20022, MT940, and BAI2.
Set up the advanced bank reconciliation import process
So, for instance if you have to handle a
new Column/Tag into the
Bank Statement Lines table (BankStmtISOReportEntry), you have to:
- Add the new field to the BankStmtISOReportEntry table
- Add the same field to the BankStatementLineStaging table and BankStatementLineEntity Data Entity
- Edit the SampleBankCompositeEntity.xml file and Add the new Tag according the new Field added to the Step 1
- Edit the BankReconiliation-to-Composite.xslt trasformation file and add the new Tag. In my case I searched for another "similar" tag for the same Entity and I replicate all found entries and change the name
- Edit the ISO20022XML-to-Reconciliation.xslt trasformation file, found the entry and Add the new Tag Section. Also in that case I have copied another "similar" section and change the name
- Lastly, in F&O recreate the Entity in the Data Management Processing Group
- Test the file Import
Take a look also to the link below in order to, for instance, Debug an XSLT file.
Bank statement file import troubleshooting
That's it!
Источник:
http://sinedax.blogspot.com/2018/11/...0022-bank.html