Credit and collections management Power BI content

This article describes what is included in the Credit and collections management Microsoft Power BI content. It explains how to access the Power BI reports, and provides information about the data model and entities that were used to build the content.

Overview

The Credit and collections management Power BI content was created for credit and collections managers, and collections clerks. It provides key credit and collections metrics, such as days sales outstanding, balance overdue, credit exposure, and customers that are over their credit limit. It uses transactional data, and provides aggregate views of credit and collections across all companies. It also provides a breakdown per company, customer group, and customer.

This Power BI content consists of 10 report pages:

• Two overview pages (one page for a credit overview and one page for a collections overview)
• Eight details pages that provide details of credit and collections metrics that are sliced and diced across various dimensions

All the amounts are shown in the system currency. You can set the system currency on the Systems parameters page.

By default, the credit and collections data for the current company is shown. To see the data across all companies, assign the CustCollectionsBICrossCompany duty to the role.

Note

In Dynamics 365 finance version 10.0.38, a new feature was added to improve the performance of the Power BI reports on the Credit and collections workspace. In Feature management, enable Credit and collections analytics performance improvements. In prior versions, the reports could time out and not display. This feature improves the data joins, filtering, currency calculation and computed columns processing. To allow for all of these improvements, the Days sales outstanding calculation (DSO) was removed from the Collections overview report page. The DSO can be found on the Credit statistics factbox.

Setup needed to view Power BI content

The following setup needs to be completed for data to display in Customer credit and collections Power BI visuals.

1. Go to System administration > Setup > System Parameters to set System currency and System Exchange Rate.
2. Go to General Ledger > Calendars > Fiscal calendars to validate fiscal calendar dates assigned to the active time period.
3. Go to General Ledger > Setup > Ledger and set Accounting Currency and Exchange Rate Type.
4. Define exchange rates between transaction currencies and accounting currency, accounting currency, and system currency. To do this, go to General Ledger > Currencies > Currency exchange rates.
5. Go to System administration > Setup > Entity Store to refresh the CustCollectionsBIMeasurementsV2 aggregate measurement. If the new feature noted above is enabled, refresh the CustCollectionsBIMeasurementsV3.

Note

Aging period definitions must be set up in Accounts receiveable parameters > Collections > Collections defaults to enable aging data in the Power BI content.

Accessing the Power BI content

The Credit and collections management Power BI content is shown in the Customer credit and collections workspace.

Reports that are included in the Power BI content

The CustCollectionsBICrossCompany Power BI content includes a report that consists of a set of metrics. These metrics are visualized as charts, tiles, and tables. The following table provides an overview of the visualizations in the CustCollectionsBICrossCompany Power BI content.

Report page	Visualization
Collections overview	Customers past due Customers over credit limit DSO 30 days - This was removed in Dynamics 365 finance version 10.0.38. Open cases Average days to close case Open activities Average days to close activities Open interest notes Open collections letters Customer hold Sales hold Aged balances Collections status amounts Collections code amounts Write-off by reason Balance due by region Expected payments
Credit overview	Customers past due Credit limit Vs balance due Customers over credit limit grid Customers over credit limit per company Credit used Vs total credit limit Credit limit Vs Credit used by region Customers per credit rating
Credit limit	Credit limit Credit limit details Credit limit per customer Credit limit per customer group Credit limit per credit rating per company Credit limit vs credit used by region
Customers over credit limit	Customers over credit limit Customers over credit limit detail Customers over credit limit per company Customer over credit limit per customer group Customers over credit limit by region
Customers past due	Customers past due Customer past due details Customer past due per company Customer past due per customer group Customer past due by region
Aged balances	Aged balances Aged balances details Aged balances per company Aged balances per customer group
Expected payments	Expected payments Expected payments details Expected payments per company Expected payments per customer group Expected payments by region
Write-offs	Write-offs by region Write-offs details Write-offs by main account Write-offs per company Write-offs per customer group Write-offs by region
Collections status	Disputed Promise to pay broken Promise to pay Collections status details Collections status amounts Open cases Open activities
Collections letters	Collection code amounts Collection code amount details Collection letter amount per company Collection letter amount per customer group Collection letter amount by region

The charts and tiles on all these reports can be filtered and pinned to the dashboard. For more information about how to filter and pin in Power BI, see Create and Configure a Dashboard. You can also use the export underlying data functionality to export underlying data that is summarized on a visualization.