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