You’re offline. This is a read only version of the page.
5
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
Hello,
If you do not get further suggestions from the community, feel free to raise a support call with Microsoft support. We may need to ask you for a repro in standard.
Thanks.
Share
Report
All responses (
Answers (
