Skip to main content


Showing posts from November, 2014

Change tracking [AX 2013 R3]

I came across this last week Great blog post talking about change tracking in AX 2012 R3. I decided to give it a go and see how to leverage it for an integration project I am working on. When you run the first job, you enable database tracking. In here you can define a retention period and if it should clean up automatically. The next piece is to enable change tracking on the table. Related tables get triggers to update the parent to tell it there was a change. A change tracking version is maintained in AX. Every time you reset a new version is inserted. If you run a basic select statement to see what is in change control. Below is the result. SELECT * FROM CHANGETABLE(CHANGES dbo.VendTable, 0) ct JOIN dbo.VendTable c ON c.AccountNum = ct.AccountNum; When you run the last job – returns a result set. This is actually a sql query that is run. SELECT * FROM CHANGETABLE(CHANGES dbo.VendTable, 0) ct JOIN db

How to find out why a cube based report isn’t working [AX 2012]

Lets say the Vendor top 10 report is throwing an error and you find out that it is based of the OLAP. You are sure you have deployed your cube and it is working. Open up the report in visual studio and go to the datasets. You will see the data source is DynamicsAXOLAP and there is a query. Copy the query. Go to SQL management studio and create a new query (mdx query – by connecting to your cube database). Paste the query and change any parameters – in this case I changed the company and the date (hard coded it in the query). Then Execute the query – you should see a result at the bottom. You will see some of the reports are depended on multiple cubes. Even though you were not using the General ledger cube the report uses it to retrieve the dates.

Deep dive - bank reconciliation matching rules [AX 2012 R3]

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. 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