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