General Journal Account Entry Table - LedgerDimension value link

(0) Share

Report

Posted on 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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (1)

Report

Hi,

You may use

Dimensionattribute and dimensionatributevaluecombination

Was this reply helpful? Yes No
CU14081545-0 2 on at

Like (1)

Report

Many Thanks for the help much appreciated.

Was this reply helpful? Yes No
BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (2)

Report

I am very happy if I can help:)

Was this reply helpful? Yes No