Filtering GL Transactions in SSRS and AX 2012

By Nicole Gentz | January 16, 2015

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
Sample Data

1. Setup your query to access the GL tables:
Set up Query Access

2. Create a parameter in your contract class for the item you want to filter on:
create a parameter modify your query modify your query

3. Modify your query within your DP class, ProcessReport method:

modify your query

modify your query

This should get you well on your way to quickly filtering those GL transactions!

Nicole Gentz
Our Verified Expert
Nicole Gentz

Nicole Gentz is a seasoned software developer with more than 20 years of experience spanning multiple ERP systems. With certifications in Microsoft Dynamics AX 2012 R3 CU8 Development and Dynamics 365 for Operations Development Introduction, Nicole has built scalable solutions that support high-performing teams and systems.
Her recent work includes guiding architecture for custom ERP modules, mentoring junior developers, and leading teams through upgrade transitions with resilient code design. Nicole combines deep technical expertise with collaborative leadership to drive systems forward.

Read More from Nicole Gentz

Related Posts


Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.

Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!