Forum Discussion
Solved
Vendor Aging Report
Hi All, I am a relatively new user in Power BI and am needing assistance with the following requirement. I need to make a vendor aging report in power bi and i have to get data through data entitie...
I have to create a vendor aging report in power bi just like the one in d365, and I am trying to get the data using OData but i don't know from which data entity or tables I can get the values like account number, vendor name, group and their balances as of different months, this I want to know, from which table I will get these fields and values.
There are a number of datasets you can get from different marketplaces, here is a sample source https://docs.microsoft.com/en-us/power-bi/sample-datasets.
Sorry, maybe you are not getting my question, I need the name of the data entity or table where I can the vendor aging report fields and values.
- I think am tracking now your data source is D365 right? If that's correct your tables will be customer Details table
https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/customer-aging-report-custagingreportfor customer aging report the customer details table will be used and what about the vendor aging report? which table will be used for it for the balances as of field?