Previous  Next          Contents  Index  Glossary  Library

Movement Statistics Report

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, detail, and country-specific formats.

Column Information Notes:

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.

When you choose a country-specific report layout, the report prints the appropriate alpha or numeric code instead of the ISO country code.

Report Submission

Use the All Reports or Submit Requests window and enter Movement Statistics Report in the Name field to submit the report.

Report Parameters

Report Option

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.
Nullify Official/ Summary Print selected information in summary format. This option reverses the action of a previous Official/Summary report. The information in the database is reset to its pre-freeze status and you can make further changes to the information.

Format Type

Choose one of the country-specific layout formats, or generic if your country is not listed.

Legal Entity

Enter the legal entity for which to report movement statistics. You can choose any legal entity that has the same set of books as the current organization.

Movement Type

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.

Report Reference

Enter a reference number for the report. If you choose the Official/Summary report option, this reference number is assigned to all movement statistics entries being reported.

Period Name

Enter a calendar period in which to run the report. The calendar used is the calendar assigned to the legal entity in the Movement Statistics Parameters window.

See Also

Submitting a Request


         Previous  Next          Contents  Index  Glossary  Library