Detailed statistics can be created to analyze the following:
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.
Customer order line No 1 : qty -> 5pcs (price per pcs 5USD)
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,
Customer
order line No 1 : qty ->
3pcs
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
New Customer order sales qty: 5 pcs price per pcs 10 USD)Change debit invoice qty: 5 pcs -> 8 pcs
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 |
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.
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.
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.
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.
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.
Aggregated Statistics - Delivery Quality
Aggregated Statistics - Invoiced Sales
Create Customer Order Detail Statistics
Customer Order - Data Aggregation
Customer Order Statistics Aggregation
Detail Statistics - Backlog of Orders
Detail Statistics - Delivery Quality
Detail Statistics - Delivery Reliability
Detail Statistics - Invoiced Sales
Detail Statistics - Order Entry