Use the Movement Statistics report to review and finalize the movement statistics entered for receipts, shipments, and other material transactions. You can report by specific legal entity, type of movement, and calendar period. You can also choose whether to freeze the information for official reporting. You can choose between summary and detail formats.
The parent identification number is equal to the movement identification number for rows without a parent.
The transaction value of the movement is calculated from the invoice, if one is associated with the movement. If there is no associated invoice, the value is calculated from the document (sales order/purchase order) price. If there is no invoice or document associated with the movement, the value is calculated either from the inventory cost or a value you entered.
The statistical value is calculated from the transaction value and the adjustment percentage or amount you entered with the movement transaction. If you did not enter an adjustment value, the statistical value is equal to the transaction value.
The weight is either the weight entered with the movement transaction or a calculation based on a conversion from the transaction unit of measure to the weight unit of measure.
The trader types are Customer, Supplier, or Organization.
If the item involved in the movement is an inventory item, the inventory cost for the item is printed.
Valid source types are Internal Order, Inventory, Purchase Order, RMA, Sales Order, and Miscellaneous.
The source number corresponds to the source type and therefore, if it exists, is a requisition number, purchase order number, RMA number, or sales order number.
If you entered outside cost information with the movement, the outside value is printed. The outside value corresponds to the outside value code in the next column of the report you associated with the movement, if any. The outside value could be for repair, processing, or other outside costs and can be entered as part of the movement statistics information.
The transaction value is calculated from the invoice, if one is associated with the movement. If there is no associated invoice, the value is calculated from the document (sales order/purchase order) price. If there is no invoice or document associated with the movement, the value is calculated either from the inventory cost or an entered figure.
The statistical value is calculated from transaction value and the adjustment percentage or amount you entered with the movement transaction. If you did not enter an adjustment value, the statistical value is equal to the transaction value.
The weight is either the weight entered with the movement transaction or calculated based on a conversion from the transaction unit of measure to the weight unit of measure.
If you entered outside cost information with the movement, the outside cost code, such as repair, processing, or other, is printed.
Use the Movement Statistics Reports or Submit Requests window and enter Movement Statistics Report in the Name field to submit the report.
Enter the legal entity for which to report movement statistics. You can choose any legal entity that has the same ledger as the current organization.
Select the code associated with the economic zone for which you want to list movement statistics exceptions.
Choose one of the following options:
| Internal | Movement of goods within countries of the economic zone. |
| External | Movement of goods from a country of one economic zone to a country outside the zone. |
Select the following option:
| Intrastat | The European Union common market. |
Choose one of the following options:
| Arrival | Report arrival movement statistics. |
| Arrival Adjustments | Report adjustments to prior period arrival movement statistics. |
| Dispatch | Report dispatch movement statistics. |
| Dispatch Adjustments | Report adjustments to prior period dispatch movement statistics. |
Enter a calendar period for which to run the report. The calendar used is the calendar assigned to the legal entity in the Movement Statistics Parameters window.
Choose one of the following options:
| Standard/ Summary | Print selected information in summary format. No database update occurs. |
| Standard/Detail | Print selected information in detail format. No database update occurs. |
| Official/ Summary | Print selected information in summary format. All information reported is updated in the database and flagged as frozen. |