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!