Dynamics Community Forum Thread Details

Personalised dimension in the general ledger entries table

Hello

I have recently imported the general ledger entries table into Power BI from the NAV server. I see that the "Source No" column is populated with customer/vendor numbers only if the document was a sales invoice or a purchase invoice. Codes from general journals are not included. I understand this is normal functionality but it leaves me with a problem. We have a personalized dimension called "customer code" which we assign to each journal line when running the journal batch and this obviously doesn't populate the Source No. column.

I notice there is a column called "dimension set id" and wondered if this might be a good way to pick up our customer codes by relating it to the general ledger table. Only thing is, after having a look at the tables on the server, i can't find a table called "dimension set id"

This has never been an issue before as all our analysis has previously been by export to excel from NAV. NAV shows our "Customer Code" as a column.

Using NAV 2017 10.0

Thanks

Quick Links