General Journal Account Entry Table - LedgerDimension value link

Like (0) Share

Report

Posted on 24 Aug 2022 14:08:38 by CU14081545-0

Hi,

I am working on a financial report in Power BI using a Data Lake export from D365F&O. In the General Journal Account Entry table, I have two fields "LedgerAccount" and "LedgerDimension". From looking at the data via a different source other than the data lake, I need the "LedgerDimension" field. However in the data I get a sort of RecId number rather than the list of the dimensions separated by a hyphen which I would expect, and I get this on the "LedgerAccount" field. Is there another table that I need to link to that RecId number I have in my LedgerDimension field to get the correct data.

Hope you can help.

Many Thanks

All responses (3)

Answers (1)

BillurSamdancioglu 17,153 Most Valuable Professional on 30 Aug 2022 at 11:54:05

Like (2)

Report

RE: General Journal Account Entry Table - LedgerDimension value link

I am very happy if I can help:)
CU14081545-0 2 on 30 Aug 2022 at 10:37:26

Like (1)

Report

RE: General Journal Account Entry Table - LedgerDimension value link

Many Thanks for the help much appreciated.
Verified answer

BillurSamdancioglu 17,153 Most Valuable Professional on 24 Aug 2022 at 14:10:17

Like (1)

Report

RE: General Journal Account Entry Table - LedgerDimension value link

Hi,

You may use

Dimensionattribute and dimensionatributevaluecombination