Advance bank reconciliation on AX 2012


In Microsoft Dynamics AX 2012 R2, you can import electronic bank statements and reconcile the imported bank statements with bank documents. If there are issues with the import process, this white paper provides some steps that can help you debug issues between .xslt files and the file being imported, and it also provides troubleshooting information.
Bank statements and companies

Microsoft Dynamics AX Application Integration Framework (AIF) is not company-specific and works across companies. Because of this, if the inbound port that is set up for the bank statement import is not restricted to a specific company (in the Restrict to company field on the Security FastTab), the bank statement is imported into the default company from your user profile.
For example, you are logged on to Company B, but your user profile’s default company is Company A. In this case, if you are using an inbound port that is not restricted to a specific company, the bank statement is imported into Company A. However, if the inbound port is restricted to Company B, the bank statement is imported into that company, regardless of the default company assigned to your user profile.

Therefore, you might want to set up a separate inbound port for each company that you must import bank statements into.
Setting up number sequences for bank statement import

To make sure that you have assigned number sequences for all companies that you are importing bank statements into, use the Cash and bank management parameters form. (Click Cash and bank management > Setup > Cash and bank management parameters, and then click the Number sequences tab.) Set up number sequences for the statement ID, download ID, and reconcile ID.
Set up advanced bank reconciliation import

Before you can import electronic bank statements and reconcile the imported bank statements with bank documents, you must set up the advanced bank reconciliation import.
1. Open the Bank accounts form. (Click Cash and bank management > Common > Bank accounts > Bank accounts.)
2. Select the bank account to reconcile.
3. On the Reconciliation FastTab, select the Advanced bank reconciliation check box.
4. Close the form.
5. Open the Inbound ports form. (Click System administration > Setup > Services and 5.Application Integration Framework > Inbound port.)
6. Click New.
7. In the Adapter field, select Files system adapter.
8. In the URI field, select a location to put the bank files in.

9. On the Service contract customizations FastTab, click Service operations

10. In the Select service operations form, select the following entries in the Remaining service 10.operations list, and move them to the Selected service operations list:
 BankStmtService.create
 BankStmtService.delete
 BankStmtService.find
 BankStmtService.getChangedKeys
 BankStmtService.getKeys
Note: These services are available only if the Advanced bank reconciliation check box is selected for a bank account in the Bank accounts form.

11. Open the Application Object Tree (AOT) (press Ctrl+D), and expand the Resources node.


to be continue..

About the author

Victor Irawan

Add comment

By Victor Irawan

Recent Posts

Recent Comments




Victor Irawan

Get in touch

Quickly communicate covalent niche markets for maintainable sources. Collaboratively harness resource sucking experiences whereas cost effective meta-services.