Previous  Next          Contents  Index  Glossary  Library

Collecting and Reporting Movement Statistics

Oracle Inventory provides the functionality for gathering, reviewing and reporting statistical information associated with material movements. These features satisfy the Intrastat reporting requirements of the European Union's single market. You can track the movement of goods regardless of the countries involved.

This functionality also provides a generic method to record additional information involving the movement of goods.

Oracle Inventory provides the features you need to collect and report your movement statistics. You should be able to:

Major Features

Capture Information within Material Movement Transactions

You can access a semi-modal Movement Statistics window directly from the Special menu in the following transaction windows:

This window permits users to enter required and selected optional movement information from within the originating transaction window rather than having to use the main Movement Statistics window.

Manually Enter Movement Information

You can also manually enter movement information associated with material transactions by accessing the Movement Statistics window from the menu. See: Entering Movement Statistics.

Statistics Setup and Reporting by Legal Entity

You can capture and report movement statistics information by legal entity. The movement statistics reporting parameters are also set by legal entity. This allows you to specify parameters such as calendar, currency exchange rate type, tax office, and contact information.

Country Specific Lists of Values

Oracle Inventory provides country specific lists of values prefixed by the appropriate ISO country code. This allows the system to handle different value sets for each country with which you transact material movements.

Track Additional/Outside Costs

You can separately enter and track repair, processing, or other outside costs associated with material movements.

Link Movements to Financial Transactions

You can automatically or manually link movement statistics to the appropriate financial documents (Sales Orders, Purchase Orders, Internal Requisitions, RMA's, and Invoices).

Track Multiple Values

You can track multiple values such as inventory cost, sales order or purchase order price, invoice price, and a statistical value price for each material movement.

Automatic Weight Calculation

Oracle Inventory calculates the weight of a material movement by converting the transaction quantity and unit of measure to the appropriate weight and weight unit of measure for the item.

Country Specific Report Options

The Movement Statistics Report provides country specific report format options for several members of the European Union. These formats support Intrastat country specific reporting requirements.

Freeze Information

You can freeze movement statistics for a specified period once the official Intrastat report is run. The freeze can be reversed by nullifying the official report to allow additional information changes. After the freeze, corrections can be made with an adjustment entry.


If you are not already familiar with the following terms, consult the Glossary to learn more about them.



Legal Entity

The legal entity and movement statistics parameters are required to produce official Movement Statistics reports. Movement statistics are also gathered and reported by legal entity. The appropriate legal entities are set up by defining an organization and associating a Legal Company classification to it. See: Creating an Organization.


You can define statistical reporting periods by defining a statistical calendar. The statistical report uses the specified calendar and period to determine which movement rows to report. You record the name of this calendar in the Movement Statistics Parameters window. See: Defining Calendars.

Weight Unit of Measure

Establish unit of measure conversion factors to convert the movement unit of measure for an item to the appropriate weight unit of measure. This produces an accurate weight figure for the Movement Statistics Report. This unit of measure is used to lookup the appropriate conversion factor from the movement unit of measure. You can also directly enter the weight for the movement in the Movement Statistics window. See: Defining Unit of Measure Conversions.

Currency Conversion

Foreign currency transactions are converted to the legal entity's currency by using a specific rate type. The statistical movement report uses the rate type to get the official exchange rate to convert foreign currency amounts. You record the appropriate rate type for this conversion in the Movement Statistics Parameters window. See: Defining Conversion Rate Types.

Linking Movement Statistics to Invoices

Movement statistics entered through the Oracle Order Entry Confirm Shipments window are linked automatically to the corresponding accounts receivable invoice. To link movements entered in the Receipts window to Accounts Payable invoices, use the Invoices window. You can also manually link movement information to the appropriate invoice. See: Overview of Delivery-based Ship Confirm..

Reporting and Reviewing Movement Statistics

Oracle Inventory provides both summary and detail reports for movement statistics. You can use these reports to validate information and identify missing or incomplete entries. You can then make corrections before freezing the information. See: Movement Statistics Report.

Freezing Movement Statistics

The Movement Statistics Report provides a run time parameter which allows you to freeze movement information for official Intrastat reporting. This option updates the database with any information calculated at report run time to provide a complete history of information reported. This option also allows you to assign a reference number for the information processed by the particular run of the report. If a mistake is determined after the information has been frozen, you can either reverse the freeze (nullifying the official report) or enter a movement adjustment entry to record the appropriate change. If an adjustment entry is created, it is reported on the next period's adjustment report.

         Previous  Next          Contents  Index  Glossary  Library