Dynamics NAVAX

I am going to go into some basics of Bank reconciliation matching rules and dive into both functional/technical detail. In my previous post I did a summary and provided some useful links. http://dynamicsnavax.blogspot.com.au/2014/10/advanced-bank-reconciliation-ax-2012-r3.html There are two main parts to setting up bank reconciliation matching rules. Step 1: Find statement lines – this allows you to filter down on the statement lines you want to match for. Step 2: Find bank documents allows you to both filter and match against the bank documents (bank/cheques transactions). Notice how there is Basic criteria which allows you to set up quick/basic rules for matching. In the background it actually inserts a record in the bank rules. You could set some of those flags manually by adding them to the grid. If we go to the backend and look browse the table BankReconciliationMatchRuleLine, you will see that setting a basic criteria has inserted a system generated record type. Th...

This is only my opinion but I feel Advanced bank reconciliation has caused a lot of confusion. This is because Microsoft has made it very technical (very cool but a bit painful first time). Also, I feel some of the documentation is lacking in detail. Below is my quick summary for anyone who wants to start with this topic. To import a statement file: Official Microsoft Links http://blogs.msdn.com/b/axsupport/archive/2014/05/20/advanced-bank-reconciliation-setup-in-ax-2012-r2.aspx Supported formats are very limited. But the big one is the BAI2 is very common but not all banks use it. Good non Microsoft Links Same as the Microsoft one but with screenshots. http://andym62.blogspot.com.au/2014/06/ax2012-r2-import-bai2-bank-statement_30.html For developers who want to support different file formats. I would recommend using transformation class, rather than xslt. Follow this step by step in detail. You will want to extend on it to include additional fields etc but a very good start....