Delivery Analysis Dashboard

The Delivery Analysis dashboard enables supervisors to identify whether the company delivers goods to customers on time. This dashboard shows sales orders with on-time delivery and delayed delivery, in addition to the average number of delay days. This dashboard also lists sales orders for which the delivery exceeds the user-defined delay days.

The Delivery Analysis dashboard contains the sections in the following table.

Chart	Type and Display	Behavior	KPI
Monthly Sales Orders	Bar chart showing the number of monthly sales orders with on-time delivery and delayed delivery, respectively, in the past 6 months.	You can place your mouse cursor over a bar to view the exact number of sales orders.	Number of sales orders for which the delivery is on time or delayed. On Time Sales Orders: sales orders with actual delivery date before or equal to the scheduled delivery date Delayed Sales Orders: sales orders with actual delivery date after the scheduled delivery date
Average Delay Days for Delayed Orders	Line chart showing the trend of average delay days (for delayed orders only) in the past 6 months.	You can place your mouse cursor over a dot to view the average number of delay days in that month.	The average Delay Days for each month is calculated as: Sum of actual delay days / total number of delayed sales orders The month for which a sales order is calculated is based on its posting date.
Sales Orders Delayed More Than <user-defined number> Days	A table listing sales orders for which the delivery is delayed for more than <user-defined numbers> days. By default, sales orders delayed by more than 2 days are shown. The table is sorted by Delay Days in descending order.	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 `DPD` 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 Scheduled Delivery Date: delivery due date Actual Delay Days: number of days passed from the delivery due date to the actual delivery date Amount: amount of the sales order, given in the currency displayed above the table

Chart

Type and Display

Behavior

KPI

Monthly Sales Orders

Bar chart showing the number of monthly sales orders with on-time delivery and delayed delivery, respectively, in the past 6 months.

You can place your mouse cursor over a bar to view the exact number of sales orders.

Number of sales orders for which the delivery is on time or delayed.

On Time Sales Orders: sales orders with actual delivery date before or equal to the scheduled delivery date
Delayed Sales Orders: sales orders with actual delivery date after the scheduled delivery date

Average Delay Days for Delayed Orders

Line chart showing the trend of average delay days (for delayed orders only) in the past 6 months.

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

The average Delay Days for each month is calculated as:

Sum of actual delay days / total number of delayed sales orders

The month for which a sales order is calculated is based on its posting date.

Sales Orders Delayed More Than <user-defined number> Days

A table listing sales orders for which the delivery is delayed for more than <user-defined numbers> days. By default, sales orders delayed by more than 2 days are shown. The table is sorted by Delay Days in descending order.

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 DPD 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
Scheduled Delivery Date: delivery due date
Actual Delay Days: number of days passed from the delivery due date to the actual delivery date
Amount: amount of the sales order, given in the currency displayed above the table