Dynamics Community Forum Thread Details

Filtering Ledger transaction list Report Based on Ledger Dimensions

Hi,

There is report in Dynamics AX 2012 which I have to customize based on the user requirements.

Below is the navigation path of that report

General ledger -> Reports -> Transactions -> Ledger transaction list

I have to customize this report and need to add the parameters of ledger dimensions for business unit,department, location etc.

The parameters should like this:

. 8765.report.jpg

These text boxes i.e business unit, line of business, line of revenue, location, department will take the display value as an input,

My question is how can i filter these report based on these ledger dimensions?

There is ledger dimension field on the generaljournalaccountentry table but still I am not able to map the display values of business unit and other dimensions on that table.

can you anyone help to filter this based on these display values of ledger dimensions.

Thanks in advance.

Hi Zahid,

Based on the financial dimensions selected on report parameter form, you need to retrieve ledger dimension recId based on those values. As GeneralJournalAccounEntry table contains the field LedgerDimension which is the combination of Main account + financial dimensions. So I think that in order to filter GJAE based on ledgerDimension values, you also need take Main account as input on your report parameter form in addition to just financial dimension, so that you can retrieve LedgerDimension recid based on that and then you can filter GJAE records based on the generated ledgerdimension recid. In your DP class, you can use the following method to retrieve ledgerDimension RecId based on the combination of values you selected on the report:

\Classes\DimensionStorage\getDynamicAccount.

Please have a look and let me know if you have further queries.

Thanks,

Baber.

Quick Links