Payment Collection Analysis Dashboard

Note Note

This function is available only if:

You are using SAP Business One, version for SAP HANA.
Or, you are using SAP Business One version for MS SQL, and have installed SAP Business One analytics powered by SAP HANA.

End of the note.

The Payment Collection Analysis dashboard helps financial analysts or managers to monitor the payment collection of a company’s sales orders. This dashboard shows paid and unpaid sales orders on a monthly basis, and the average number of days passed from the sales order posting date to the payment date. This dashboard also lists sales orders that are paid more than a user-defined number of days after the posting date.

The Payment Collection Analysis dashboard contains the sections in the following table.

Chart	Type and Display	Behavior	KPI
Sales Orders Payment Status	Bar chart showing the summed document total of monthly sales orders that are paid and unpaid, respectively, in the past 6 months.	You can place your mouse cursor over a bar to view the amount of paid or unpaid sales orders.	Summed document total of paid and unpaid sales orders. Amount Paid: summed document total of sales orders for which the payment has been collected Amount Unpaid: summed document total of sales orders that were not paid or not fully paid
Average Order-to-Payment Days	Line chart showing the trend of average order-to-payment days in the past 6 months.	You can place your mouse cursor over a dot to view the average number of order-to-payment days in that month.	The Average Order-to-Payment Days for each month is calculated as: Sum of order-to-payment days / total number of sales orders Order-to-Payment Days: number of days passed from the sales order posting date to the closing date of all invoices The month to which a sales order is calculated is based on its posting date.
Sales Orders Paid More Than <user-defined number> Days After Posting Date	A table listing sales orders for which the payments were collected more than <user-defined number> days after the posting date. By default, sales orders paid more than 0 days after posting date are shown. The table is sorted by sales order document number in ascending order by default.	You can change the number of days as follows: From the SAP Business One, version for SAP HANA Main Menu, choose Administration Setup General Dashboard Parameters . In the Dashboard Parameters – Setup window, press `CTRL` + `F` to switch to Find mode. In the Code field, enter `PCA` and choose Find. In the Value column, change the value of Allowed Delay Days. To view details of a sales order, click the sales order number in the table. Use the page buttons in the lower-right corner to navigate through the pages.	Sales Order: document number of the sales order BP Name: BP name of the customer Sales Order Posting Date: posting date of the sales order Order-to-Payment Days: number of days passed from the sales order posting date to the closing date of all invoices Amount: amount of the sales order, given in the currency displayed above the table

Chart

Type and Display

Behavior

KPI

Sales Orders Payment Status

Bar chart showing the summed document total of monthly sales orders that are paid and unpaid, respectively, in the past 6 months.

You can place your mouse cursor over a bar to view the amount of paid or unpaid sales orders.

Summed document total of paid and unpaid sales orders.

Amount Paid: summed document total of sales orders for which the payment has been collected
Amount Unpaid: summed document total of sales orders that were not paid or not fully paid

Average Order-to-Payment Days

Line chart showing the trend of average order-to-payment days in the past 6 months.

You can place your mouse cursor over a dot to view the average number of order-to-payment days in that month.

The Average Order-to-Payment Days for each month is calculated as:

Sum of order-to-payment days / total number of sales orders

Order-to-Payment Days: number of days passed from the sales order posting date to the closing date of all invoices
The month to which a sales order is calculated is based on its posting date.

Sales Orders Paid More Than <user-defined number> Days After Posting Date

A table listing sales orders for which the payments were collected more than <user-defined number> days after the posting date. By default, sales orders paid more than 0 days after posting date are shown.

The table is sorted by sales order document number in ascending order by default.

You can change the number of days as follows:

From the SAP Business One, version for SAP HANA Main Menu, choose Administration Setup General Dashboard Parameters .
In the Dashboard Parameters – Setup window, press CTRL + F to switch to Find mode.
In the Code field, enter PCA and choose Find.
In the Value column, change the value of Allowed Delay Days.

To view details of a sales order, click the sales order number in the table.

Use the page buttons in the lower-right corner to navigate through the pages.

Sales Order: document number of the sales order
BP Name: BP name of the customer
Sales Order Posting Date: posting date of the sales order
Order-to-Payment Days: number of days passed from the sales order posting date to the closing date of all invoices
Amount: amount of the sales order, given in the currency displayed above the table