Filtering GL Transactions in SSRS and AX 2012
Recently I needed to create a report against GL transactions filtered on specific accounts, sites and cost centers.
At first glance I thought I’d need to start by going through the dreaded DimensionAttributeValueCombination table to the MainAccount table, in order to setup my query.
However, there is a MUCH easier way.
The GeneralJournalAccountEntry table has a field LedgerAccount that stores the same information.
Sample Data: Account – Site – Cost Center
1. Setup your query to access the GL tables:
2. Create a parameter in your contract class for the item you want to filter on:
3. Modify your query within your DP class, ProcessReport method:
This should get you well on your way to quickly filtering those GL transactions!