Finance | Project Operations, Human Resources, ...

Get Vendor Details for a Journal Entry

(0) Share

Report

Posted on by VickyD

We have recently setup the Export to Data Lake option which helps us get data from underlying D365 tables into the Data Lake. This however, means that we now need to know exactly what tables have what data.

While I've managed to to find most of the data needed for Financial reporting, I'm struggling to find out what tables can provided the Vendor details (where applicable) for a given journal entry.

The GeneralJournalAccountEntry table has Voucher number and I can see the Vendor details in the UI through the Voucher Transactions inquiry using that voucher number but can't seem to find what table these Voucher Transaction details are stored in so I can get the Vendor details. Basically need the Vendor Account Number associated to the Voucher.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi VickyD, Vendor account field in voucher Transactions form is a Display methods thats why not included in the data entity. You can check method 'displayVendAccount' in GeneralJournalAccountEntry datasource in 'LedgerTransVoucher' form. I think you have to replicate same logic in data entity.

Was this reply helpful? Yes No
VickyD on at

Like (0)

Report
Copy link

Link copied!

Thanks Mohit. I don't have access to the codebase as such. When I look at the form information through the UI/browser, here's what I see, and it's not very helpful. I thought looking at a Vendor-wise summary of costs would be a very common reporting requirement and a lot of folks would have wanted this and figured this out already.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Moderator on at

Like (0)

Report
Copy link

Link copied!

In April/May timeframe, Microsoft will be opening to Public Preview their recently developed Business Process Analytics platform that will provide many pre-defined entities for Excel/Power BI reporting. You can learn more about BPA in this blog article. cloudblogs.microsoft.com/.../

This doesn't address your need immediately but should prove userful in the near future. The BPA section is about halfway thru the article.

Was this reply helpful? Yes No
VickyD on at

Like (0)

Report
Copy link

Link copied!

Thanks Frank. Good to know.

I'm also keeping an eye on Export Entity Store to Data Lake, as it should ideally avoid the need to join underlying tables.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Moderator on at

Like (0)

Report
Copy link

Link copied!

Export Entity Store to Data Lake can be deployed now. Data lake and Azure Synapse config needs to be completed in your environment as a prerequisite. Once that's done, you can activate the entity export based on your data requirements and use Excel/Power BI to consume the data.

Was this reply helpful? Yes No