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:
- Report company specific information, including name, address and registration information
- Capture, maintain, calculate and report information associated with the movement of goods between statistics gathering countries. This includes the ability to record and report corrections.
- Record whether transactions with a specific customer involved repair, processing, or other outside costs
- Record and report transaction values based on a set of specific currency exchange rates
- Enter and/or calculate a statistical value separate from the invoice value of a transaction
- Freeze statistical information after review
- Create an audit trail between statistical information and the associated material transactions
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:
- INVENTORY: Inter-Organization Transfers, RMA Receipts, and RMA Returns
- RECEIVING: Receipts, Returns, and Corrections
- ACCOUNTS PAYABLE: Invoices
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.
Terms
If you are not already familiar with the following terms, consult the Glossary to learn more about them.
Setup
- Define a commodity code category set and assign commodity codes to items
Before capturing and/or reporting movement statistics using commodity codes, you must establish a category set to store commodity codes for inventory items. Once the category set has been defined, you assign the proper commodity code to items. See: Defining Category Sets.
- Define legal entity and movement statistics parameters
Use the Movement Statistics Parameters window (See: Defining Movement Statistics Parameters) to record information associated with any legal entity for which you are gathering and reporting movement statistics.
Parameters
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.
Calendar
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.