Orders Report - Summary by Items
Orders Report - Summary by Items
 |
If you use the
Only Where Ordered and Delivered Qty Differ
option , you can define, which orders will be reported.
- If you select orders the option, the program will report orders
that have not yet been totally dispatched (non-dispatched
or partially dispatched orders).
- If you do not select the option, the program will report all
dispatched orders (with other defined criteria). The report will
include orders where the entire ordered quantity has already been
dispatched to the customer, and the difference will be equal to
0.
The difference for the delivery will not change, regardless if
the option is selected, what will change is the number of records the
program will include in the procedure.
Compare to the report: Orders report
- summary by items - difference only.
|
| |
The prices of Items in summary reports (Summary
by items report) are calculated as quotient of
value and quantity. |
| (Report criteria) |
In the header of the report are defined
report criteria (report is limited limited by: document type, different
kind of dates, order status, etc.). You can limit the report to some
data if you select checkbox in the Administration panel | Settings |
Program parameters | General. |
| Item |
In this column is the ID of the item
from the line of the sales order. |
| Name |
In this column is the name of the item from the line
of the sales order. |
| Price |
In this column is the average sale price for the current
item, less discounts which are also available in the order line and
excluding VAT (Compare to the Orders report
- detailed report type).
This is a product of the total value of ordered quantities and the ordered
quantity. |
Ordered
| Quantity |
In this column is the sum of ordered
quantities for the current item. |
| Value |
In this column is the sum of values of quantities for
the current item. |
Dispatched
| Quantity |
In this column is the sum of dispatched quantities for
the current item. |
| Value |
In this column is a product
of values from the Price
field and Quantity (Price*
Realized Quantity). It is the value, excluding VAT. This is not the
actual sale price of goods, but (due to comparison of ordered and dispatched
values) the value of already dispatched quantities, evaluated with the
price from the order.
|
Difference
| Quantity |
In this column is the remaining quantity (ordered quantity
less dispatched quantity). |
| Value |
In this column is the remaining value
(ordered value less dispatched value).
It is the value of non-dispatched items, less approved discount in
the order and before VAT, evaluated with the price from the order.
|