Customer Order Statistics

Detailed statistics can be created to analyze the following:

Order Entry

·        This statistic is used to represent how the customer order line value is changed over time, as the order line is processed throughout the system. When you are running the statistics for the very first time, all the customer order/Charge lines are selected and shown under order entry statistics, irrespective of the order line status. In subsequent runs, system compares the previously generated statistics and create new statistics lines for the differences in order line prices, quantities, discounts and amounts. If order line is in Invoiced/Closed status & all relevant invoices are (posted Auth) status, then customer order line values are compared with the respective invoice line values to see if there is a difference in values. When Multiple invoices are available for a particular customer order line, it calculated the summation of all the invoice values (Except sales price) and compare it with the previous order entry statistics values. For sales price, system calculates the weighted average price of the multiple invoices and compare it with the customer order line price.

·        For a given statistics line, if no differences are found compared to the already generated statistics, then system will not generate any new statistics lines.

·        Below you can see some examples of how order entry statistics work

·        Only relevant attribute columns are shown in the below tables.

 

EX 1: Add Customer order line & Charge line. Then run the 1st statistics.

  1. Customer order line No 1 :  qty à5pcs (price per pcs 5USD)

  2. Charge line No 2 : price à 8.50 USD

Statistics creation

Order/Charge line no

“Net Amount” in order/Charge line / USD

“Price qty” in order entry/ pcs

“Price” in order entry / USD

“Net Amount” in order entry /USD

Source

First statistics creation

1

25.00

5

5

25.00

Customer order line

2

8.50

1

8.50

8.50

Customer order Charge line

 

Run the 2nd order entry statistics, after changed the order values as below,

  1. Customer order line No 1 :  qty à3pcs

  2. Charge line No 2 : price à10.00 USD

Statistics creation

Order/Charge line no

“Net Amount” in order line / USD

“Price qty” in order entry/ pcs

“Price” in order entry / USD

“Net Amount” in order entry /USD

Source

Second statistics creation

1

15.00

-2

0

-10.00

Customer order line

2

10.00

0

1.50

1.50

Customer order Charge line

 

EX 2 : Add Customer order line & create debit/Credit invoices with differences

  1. New Customer order sales qty: 5 pcs price per pcs 10 USD)Change debit invoice qty: 5 pcs à 8

  2. Create credit invoice for 2 pcs

Statistics creation

Customer order/invoice line no

 “Net Amount” in order/invoice line /  USD

“Price qty” in order entry/ pcs

“Price” in order entry / USD

“Net Amount” in order entry / USD

Source

First statistics creation

 

1

50.00

5

10.00

50.00

Customer order line

1

80.00

3

0.00

30.00

Debit invoice line

1

60.00

-2

0.00

-20.00

Credit invoice line

Backlog of Orders

It is possible to create detail statistics for backlog of orders so you can analyze the development of the backlog of orders. All order lines which, at the moment of statistic creation, are in Released, Reserved, Picked, Partially Delivered, Delivered or Blocked statuses will be selected. Parts which have been invoiced are not included.

Invoiced Sales

The information regarding sales that have been invoiced is available in these statistics. All invoiced lines with invoiced date equal to or greater than the execution date will be added to invoiced sales statistics. Detail statistics are created for the period until system date -1. If time zones are used, detail statistics are created for the period until system date -2.

Delivery Reliability

Information about delivery reliability for each day is saved in the detail statistics for delivery reliability. All customer order lines where the delivery date is equal to or beyond the latest execution date will be selected in the detail statistics. Net, gross, and discount amount will be calculated from shipped quantity. Detail statistics are created for the period until system date -1. If time zones are used, detail statistics are created for the period until system date -2.

Delivery Quality

Quantity returned, returned to stock, scrapped, and scrapping cause is important information in order to measure delivery quality. All customer order lines where the return date is equal or beyond the execution date will be selected in this detail statistics. Detail statistics are created for the period until system date -1. If time zones are used, detail statistics are created for the period until system date -2.

Aggregated Statistics

When the detail statistics are created, it is possible to aggregate data up to a desired level for invoiced sales and delivery quality. It is possible to choose dimensions to aggregate, i.e., customers or customer groups, as well as what to aggregate, i.e., sales quantity and invoiced quantity. You are able to choose time period (daily, weekly, monthly, or free number of days) to aggregate the detail statistics. One example of the kind of questions the aggregation functionality could provide is: How much do we invoice (net amount, gross amount, tax amount) monthly per customer and customer group? The definition for aggregation is made in a separate interface-Data Aggregation. When aggregating the invoiced sales the system uses the date that the invoice was created as basis. Any invoices created after the latest aggregation will therefore be included in the next aggregation period and cannot be included in a previous period even if the invoice date is changed.