Supply chain | Supply Chain Management, Commerce

Data entities for accounts receivable and accounts payable

(0) Share

Report

Posted on by Community Member

Hi, I am working on powerBI reports for sales and receivables.

Which would be the most suitable data entities to use to create analytics for accounts receivable and accounts payable per customer?

Thanks in advance.

BR,

Simeon

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 301,141 Super User 2025 Season 2 on at

Like (0)

Report

Hi Simeon,

Reporting or analytics could be any topic. What type of analytics do you want to create? Is it about order statistics, total turnover, aging reports? Please be more specific.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Andre.

What we want to start with total receivables per customer, total payables per vendor. The data to be valid as of the end of a selected month.

Thanks,

Simeon

Was this reply helpful? Yes No
Suggested answer

AR-01121610-0 4,967 Moderator on at

Like (0)

Report

On All Customer an all Vendors form you can use General/Statistics/Financial resp. period statostics to get the information at

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Andreas,

The question is related with a PowerBI project. I need to find the most efficient way to collect information about the open receivables and payables and summarize them by counterpart. For preference by using standard data entities.

Was this reply helpful? Yes No
Suggested answer

AR-01121610-0 4,967 Moderator on at

Like (0)

Report

Hy Simeon,

there are OOB two Aggregated Data Entities (tabular data models) available:

VendorPaymentBIMeasureV2

docs.microsoft.com/.../vendor-payments-workspace

CustCollectionBIMeasurementsV2

Credit and collections management Power BI content - Finance | Dynamics 365 | Microsoft Docs

Both are accessable by corresponding Analytical Workspaces using data from AXDW (Datawarehouse DB), or you can modify the PowerBI files for your requirement, e.g. to combine both models. AXDW will be updated as you configure in System Administration/Setup/Entity Store.

Was this reply helpful? Yes No