LEDGERBALANCESDIMTRANS

Dynamics 365 for Finance and Operations/AX Technical Forum
1

Dear All, can some one help me with the following please. How do we extract the data from AX 2012 which is similar to the AX 2009’s LEDGERBALANCESDIMTRANS table data extract. Thanks

2

DimensionFocusBalance in AX 2012, which holds the balances for various dimension combinations. Look into table relations for more insight.

3

Thanks for your response Kranthi. I have had a look into that, but I have few questions on that. I am familiar with the financial dimension sets in AX 2012, have had a look at the close look at all the DimensionAttribute and relevant tables. My questions are below, please answer me.

  1. Does this only hold the ledger balance dim transactions, any chance of duplicate or redundant entries?
  2. FocusLedgerDimension is same as LedgerDimension, I mean establish relation to DIMENSIONATTRIBUTEVALUECOMBINATION?

I need all the list of the balance transaction like Organisation/Company, Account (MainAccount), CREDITMST & DEBITMST (Think these are CREDITACCOUNTINGAMOUNTCUR, DEBITACCOUNTINGAMOUNTCUR), Department (Dimension), Cost Centre (Dimension 2) etc

Can you please help me on this?

Thank you.

4

Hi Kranthi, which field of AX 2012 refers to the PERIODCODE in AX 2009 table (LedgerBalancesDimTrans), please let me kow your thoughts. Cheers

5

FiscalCalendarPeriodType in DimensionFocusBalance

6

The uniqueness is per accounting date and dimension combination,per posting layer. You have an unique index defined on these fields BalanceQueryIdx

\Data Dictionary\Tables\DimensionFocusBalance\Relations\LedgerDimension\DimensionFocusBalance.FocusLedgerDimension == DimensionAttributeValueCombination.RecId

7

Thanks very much for the information Kranthi. I think FocusLedgerDimension is having the to DimensionAttributeValueCombination. In Ax 2009 the Dimension, Dimension2_, Dimension3_ having the values. If we have the different values of combination in AX 2012, then not too sure how exactly the the DimensionFocusBalance table give us the right data extract, please share your thoughts. Cheers

8

Hi experts,

we are upgrading from ax 2009 to Ax 2012 R3.

Earlier, The implementer of AX 2009 have used LedgerBalanceDimTrans table to get the balances by applying the main account and dimensions like department and costcenter in respective dimension2 and dimension 3. How to apply the same in AX 2012 for DimensionFocusBalance table. I pretty much confused at the moment. I hope you can help me with the issue ASAP.

Thanks and Regards,

Aravind

9

Hi experts,

we are upgrading from ax 2009 to Ax 2012 R3.

Earlier, The implementer of AX 2009 have used LedgerBalanceDimTrans table to get the balances by applying the main account and dimensions like department and costcenter in respective dimension2 and dimension 3. How to apply the same in AX 2012 for DimensionFocusBalance table. I pretty much confused at the moment. I hope you can help me with the issue ASAP.

Thanks and Regards,

Aravind