Delivery 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.

Note Note

This dashboard considers only the sales orders that are fully copied to deliveries or A/R invoices, i.e., the sales orders are closed.

End of the note.

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.

You can find the definitions used in the dashboard as follows:

Actual delivery date: Delivery Date of the delivery or Posting Date of the A/R invoice
Scheduled delivery date: the latest date taken from the following fields:
- Delivery Date of the sales order
- Del. Date in the item rows of the sales order
Delay days: number of days between the scheduled delivery date and the actual delivery date

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: the latest date taken from the following fields: Delivery Date of the sales order Del. Date in the item rows of the sales order Actual Delay Days: number of days between the scheduled delivery date and 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: the latest date taken from the following fields:
- Delivery Date of the sales order
- Del. Date in the item rows of the sales order
Actual Delay Days: number of days between the scheduled delivery date and the actual delivery date
Amount: amount of the sales order, given in the currency displayed above the table