Oracle Inventory provides the functionality for collecting statistics associated with the movement of material across the border of two countries. You can collect statistics to satisfy the European Union's reporting requirements for INTRASTAT, the declaration for imports and exports between countries belonging to the European Union, and EXTRASTAT, the declaration for imports and exports between a country belonging to the European Union and a country external to the European Union. This functionality is also a feature of Oracle Purchasing.
Movement statistics features allow you to:
Automatically generate movement statistics records based on ship-from and ship-to information, without user intervention.
Report your company's legal entity information, including name, address, and tax registration information.
Capture, maintain, calculate, and report information associated with the movement of material between statistics gathering countries. This includes the ability to record and report corrections.
Run the Movement Statistics Exception Report to validate that all movement statistics records in a period are accurate and ready for reporting.
Capture the invoice value from accounts receivables and accounts payables for material movement. If the invoice information is not available, the system captures the statistical value from the movement transaction.
Freeze statistical information after review and report the information to a government agency.
Create an audit trail between statistical information and the associated material transactions.
Generate EDI messages out of movement statistics records.
You can automatically generate movement statistics records by running the Movement Statistics Processor, a concurrent program that analyzes all the transactions that occur in the system, based on legal entity. You can then validate the records and, for INTRASTAT and EXTRASTAT, create official reporting documents. See: Automatically Generating Movement Statistics Records.
The Movement Statistics Processor analyzes the following transaction types:
Purchase Receipt
RTV
Sales order
RMA
Supplier drop shipment
Multi-org intercompany drop shipment
Inventory interorganization movements
Internal requisition
Internal sales order
Attention: The system does not analyze Oracle Inventory miscellaneous receipts and issues because these transactions are considered inventory updates, not material movements.
To enable the system to automatically generate movement statistics records you define parameters in the Economic Zones and Movement Statistics Parameters windows. See: Setting Up Movement Statistics.
Note: ISO and European Union country codes are supported. See: Territories Window .
You can capture and report movement statistics by legal entity. You can specify parameters such as calendar, currency conversion type, weight unit of measure, tax office name, and tax office information.
You can use the Movement Statistics Exception Report to validate that all movement statistics records in a period are accurate and ready for reporting. You can identify missing or incomplete entries and make corrections before freezing the information. See: Movement Statistics Exception Report.
You can generate both summary and detail reports for movement statistics, including hard copies for government agencies and your own files. See: Movement Statistics Report.
The Movement Statistics Report provides a run time parameter which allows you to freeze movement information for official INTRASTAT and EXTRASTAT 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. Only records that have been frozen can be used to generate EDI messages.
After you freeze movement statistics records for official INTRASTAT and EXTRASTAT reporting, you can run the Movement Statistics Reset Status program to reset their status to open. This option allows you to add missing information to records that are frozen. See: Movement Statistics Reset Status Report.
Movement statistics functionality provides the ability to integrate with Legacy systems in order to capture material movements from other logistics applications.
You can generate EDI messages from movement statistics records. These messages are EDIFACT compliant.
Movement statistics records are automatically linked to various financial documents based on the transaction type. For example, purchase order receipts are linked to payables invoices, RTVs and RMAs with credit memos, and sales order shipments with receivables invoices.
You can capture the invoice value from accounts receivables and accounts payables for material movement. If the invoice information is not available, the system captures the statistical value from the movement transaction.
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.
You can manually enter movement information associated with material transactions that are not captured by Oracle Inventory and Purchasing, such as fixed assets. See: Viewing and Maintaining Movement Statistics.