Movement Statistics Record Creation

This chapter covers the following topics:

• Movement Statistics Processor Overview
• Movement Statistics Submission Parameters
• Query Movement Statistic Records
• Display Movement Statistics Records
• Find Movement Statistics Window
• Movement Statistics Summary Window- Single Record
• Movement Statistics Summary Window
• Movement Statistics Details Window
• Manual Creation of Movement Statistic Records
• Consigned Receipts and Consigned Returns
• Intrastat Processing After Brexit
• Exclude Expense Items
• Exclude Service Items

Movement Statistics Processor Overview

Run the Movement Statistics Processor to automatically generate movement statistics records. The Movement Statistics Processor analyzes and processes movement transactions from which the movement statistics records are created.

Strategy for Running the Movement Statistics Processor

The schedule that you set up to run the Movement Statistics Processor is determined by the volume of movement transactions. For higher movement transaction volumes you should run the processor more often.

Movement Statistics Transactions

Oracle's movement statistics solution creates movement records for the following transactions:

• Purchase Receipts - shipment from a supplier, including planned purchase orders and blanket purchase agreements.

• Return to Vendor (RTV) - the return of goods from a specific receipt to the supplying vendor.

• Return Material Authorization (RMA) - return of goods against a sales order (may or may not include a credit memo).

• Triangulation - supplier drop shipments.

• Multiple-organization drop shipments - drop shipments that span legal entities.

• Inventory inter-organization movements - the movement of material from one organization to another.

• Inventory inter organization in transit cancellations – cancellation of in transit shipments from one organization to another.

• Internal Requisitions and Internal Sales Orders.

• Internal Returns - to return consignments from the destination organizations to the source organizations. For example, you can return damaged goods through an internal return. This includes cancellation of in-transit shipments.

• Standard Sales Orders - sales order shipment.

• Consigned receipts and returns - creates an arrival record for the consigned receipt and a dispatch record for the consigned return.

Movement Statistics Processor Submission Form

Movement Statistics Submission Parameters

Submit the Movement Statistics Processor to create movement records. The submission parameters are:

• Legal Entity (required) - select a Legal Entity from the list of values.

• Dates From (required) - select a starting date.

• Dates To (optional) - select an ending date.

• Document Source (optional) - the default is all transaction types for the select Legal Entity and dates. You may also select a specific transaction type (sales order, purchase order, return to vendor, etc.) to process.

Movement Statistics Processor Submission Process

1. Enter the parameters to run the Movement Statistics Processor.

2. Submit the processor concurrent program for execution.

3. Verify execution of the concurrent program.

4. View the movement statistics records the processor generates.

Query Movement Statistic Records

After you have run the Movement Statistics Processor, you use the Find Movement Statistics window to query and display your movement statistics records.

The Basic Tab on the Find Movement Statistics Form permits you to query based on the following criteria:

• Legal Entity - you may search by Legal Entity

• Economic Zone - you may search by Economic Zone

• Usage Type - you may search by Internal or External

• Statistical Type - you may search for movement records based INTRASTAT, EXTRASTAT

• Inventory Organization - you may search for movement records based on inventory organization you have defined

• Movement Number - if you know the movement number of a specific movement record, you may query using the movement number. You may also validate the movement number: if the Validate box is checked, the search engine will verify that the movement number exists before performing the search.

• Movement Status - you may search for movement records based on their record status (OPEN, VERIFIED, FROZEN, etc.)

• Movement Type - you may search for movement records based on type (Arrival, Dispatch, etc.).

Note that these fields are all optional. You may enter as many search criteria as you wish. If you do not enter any search criteria, all movement records will be displayed.

Find Movement Statistics Window -- Advanced Tab

The Advanced Tab on the Find Movement Statistics form enables you to query based on the following criteria (in conjunction with the criteria you may have entered on the Basic Tab):

• Source Type - you may search by transaction type (sales order, purchase order, etc.)

• Period Name - you may search by specific period

• Dates From - you may search by a date range

• Date To - you may search by a date range

• Document Number - you may search by sales order or purchase order number. You must know the specific sales or purchase order number. Note that you must select a Source Type if you plan to search by Document Number.

• Transaction Number - you may search by All, Receipt, Delivery, Requisition, or Transaction ID.

• Invoice Number - you may search by payable or receivable invoice number. You must know the specific invoice number. Note that you must select a Source Type if you plan to search by Invoice Number.

• Commodity Code - you may search by Commodity Code. You may select a commodity code from a list of values. Note that you must enter a Legal Entity, Economic Zone, Usage Type, and Statistical Type on the Basic Tab form if you plan to search by Commodity Code.

• Destination Country - you may search by Destination Country. You select a Destination Country from a list of values.

• Transaction Code - you may search by Transaction Nature. You select a Transaction Nature from a list of values.

• Report Reference - you may search by Report Reference. A Report Reference Number is generated by the Movement Statistics Official Summary Report. Only movement records that have been listed on the Official Summary Report will have a Report Reference Number.

• Dispatch Country - you may search by Dispatch Country. You select a Dispatch Country from a list of values.

• Delivery Terms - you may search by Delivery Terms. You select a Delivery Terms from a list of values.

• Transport Mode - you may search by Transport Mode. You select a Transport Mode from a list of values.

Note that these fields are all optional. You may enter as many search criteria as you wish. If you do not enter any search criteria, all movement records will be displayed.

Find Movement Statistics Records Process

1. Enter the parameters to find movement statistics records using the Basic window.

   Note: If you do not enter any parameters, the system displays all movement statistics records.

2. Enter the parameters to fine movement statistics records using the advanced window.

3. Find and display the records based on the parameters you entered.

4. To stop the query click Cancel and close the find movement Statistics window.

5. Click Clear to empty the parameters you entered.

Display Movement Statistics Records

The following forms are used to display and modify movement statistics records that result from your query:

• Find Movement Statistics - displays results (you may not modify records on this form)

• Movement Statistics Summary - Single Record - displays results (you may not modify records on this form)

• Movement Statistics Summary - displays results (you may not modify records on this form)

• Movement Statistics Details - the only form on which you may modify a movement record

Find Movement Statistics Window

Use the Find Movement Statistics window to enter your query search criteria and to view the results of your query. This window displays all the records retrieved based on the search criteria. Movement statistic records displayed here cannot be updated.

Find Movement Statistics Window - Results

To save a query for future use

1. Enter your query criteria, and click Find.

2. Click Save As (from the Find Movement Statistics form) to display the Save As window. Click Save to save the current query.

   Save As Window

   

3. Enter a New Folder Name – this will be the name of your saved query. The current query and parameters will be saved.

4. Click Save.

5. Run a saved query from the Movement Statistics Summary form.

To run a saved query

You can run a saved query from the Movement Statistics Summary form.

1. Select Personal Shortcuts from the Movement Statistics Summary form. All previously saved queries will be displayed.

2. Click the + key to expand the tree structure and display the movement ID of the records retrieved by the query in groups of ten. Click Next to retrieve the next ten records.

3. Click the saved query to execute the query and populate the Movement Statistics Summary form.

4. Click the - key to collapse the tree structure.

Movement Statistics Summary Window- Single Record

You can display an individual movement record summary from the Find Movement Statistics form after you have performed a query. Movement statistic records may not be updated on this form.

To display a record in this format, first query the record on the Find Movement Statistics form, then double click the record to display its details. To return to the complete listing of all records found based on the query, click Movement (highlighted in blue) located on the left hand column of the form.

Individual Summary Window

A navigational Tree Structure, located on the left side of the Movement Statistics Summary form, is available for your use. To expand or collapse the tree structure, click the plus or minus.

Movement Statistics Summary Window

The Movement Statistics Summary form displays all the records from a query in summary format. This form includes a Query Tree Structure to help you to save and organize frequently used queries. Movement statistic records may not be updated on this form.

The Detail button displays detailed information about a single Movement Statistics record you have selected.

Movement Statistics Summary Form

Movement Statistics Details Window

The Movement Statistics Details window displays one movement statistics record in detail format. The only way to access the Details window is via the Movement Statistics Summary window. To display a movement record on the Detail window, you must click Detail found on the Movement Statistics Summary window.

The Movement Statistics Details window is divided into a header section and six sections or tabs as follows:

• Movement Details

• Country Details

• Source Details

• Invoice Details

• Additional Details

• Miscellaneous

Fields in the header section may not be modified. Specific fields in each of the tabbed sections may be updated as required. This is the only form where you may update movement statistic records.

Much of the information displayed on the Movement Statistics Details form is also displayed on the Movement Statistics Standard Detail Report. If you do not want to make modifications to movement records and review the information only, you may want to print this report.

Movement Statistics Details Window - Movement Details Tab

The Movement Details tab displays and permits modification of movement transaction details, including item, quantity, price, and weight information. Refer to the Appendix for detailed information about each field displayed on the Movement Details tab.

Movement Statistics Details Window

Movement Statistics Details Window - Country Details Tab

The Country Details tab displays and permits modification of the countries involved in the transaction. Refer to the Appendix for detailed information about each field displayed on the Country Details tab.

Movement Statistics Details - Country Details Tab

Movement Statistic Window - Source Details Tab

The Source Details tab displays information appropriate to each transaction source. Refer to the Appendix for detailed information about the fields that are displayed on this tab. Note that you cannot modify any information on this tab.

• Source Type and Display

  1. Sales Orders

     • Sales Order Number

     • Sales Order Line

     • Delivery Name

     • Customer Name, Number, and Site

  2. Customer Return

     • RMA Number

     • RMA Line

     • Receipt Number

     • Customer Name, Number, and Site

  3. Purchase Orders

     • Purchase Order Number

     • Purchase Order Line

     • Release Number

     • Receipt Number

     • Supplier Name, Number, and Site

  4. Return to Vendor

     • Purchase Order Number

     • Purchase Order Line

     • Release Number

     • Receipt Number

     • Supplier Name, Number, and Site

  5. Internal Order

     • Requisition Number

     • Requisition Line

     • Sales Order Number

     • Sales Order Line

     • Delivery Name

     • From Organization

     • To Organization

  6. Internal Return

     • Requisition Number

     • Requisition Line

     • Sales Order Number

     • Sales Order Line

     • Delivery Name

     • From Organization

     • To Organization

  7. Inventory

     • Transaction ID

     • From Organization

     • To Organization

  8. Inventory in transit shipment cancellation

     • Transaction ID

     • From Organization

     • To Organization

Movement Statistics Details - Source Details Tab

Movement Statistics Details Window - Invoice Details Tab

The Invoice Details tab displays invoice information if the Source Type has been invoiced. You cannot modify information on this tab. Refer to the Appendix for detailed information about each field displayed on the Invoice Details tab.

Movement Statistics Details Window - Invoice Details Tab

Movement Statistics Details Window - Additional Details Tab

The Additional Details tab displays and permits modification of additional movement details, including making adjustments. Note that the adjustments will be listed on the Movement Statistics Reports. Refer to the Appendix for detailed information about each field displayed on the Additional Details tab.

Movement Statistics Details - Additional Details Tab

Movement Statistics Details Window - Miscellaneous Tab

The Miscellaneous tab displays and enables modification of miscellaneous movement information. Refer to the Appendix for detailed information about each field displayed on the Miscellaneous tab.

Movement Statistics Details Window - Miscellaneous Tab

Manual Creation of Movement Statistic Records

Oracle's movement statistics solution also gives you the capability to create movement records manually. You may create a manual movement record to adjust an existing transaction or to account for a new transaction.

You may create movement records for the following transactions manually:

• Inter Organization Transfer

• Delivery

• Receipt

• Miscellaneous

To create movement records manually, you must have one of the following forms open:

• Movement Statistics Summary form

• Movement Statistics Detail form.

From one of these forms, you open the Transaction Types window to start the manual record creation process.

Once you have successfully entered the manual record, you may query, modify, and report the record as you would a record created by the Movement Statistics Processor.

Movement Statistic Summary Window - Manual Record Entry

Manual Movement Statistics Record Creation Process

1. Open one of the following windows:

   • Movement Statistics Details

   • Movement Statistics Summary

2. Select File, New to display the Transaction Types window.

3. Enter the Legal Entity.

4. Select the transaction type of the manual record to create from the list of values.

5. If necessary, enter the inventory organization.

6. Select and enter the fourth field base on the Transaction Type.

7. Click OK to display the Movement Statistics Details window. Enter the required movement information.

   Note: You cannot save the manual record until you enter all required fields.

8. Select Validate to validate the record.

Consigned Receipts and Consigned Returns

To comply with European Union legislation, European customers typically must include movements of consigned goods in their Intrastat and Extrastat monthly declarations. To track movements of consigned goods, the Oracle movement statistics processor creates arrival records (for consigned receipts) and dispatch records (for consigned returns), and assigns a corresponding transaction code to help you identify the record for reporting purposes (see the appendix for an official EU list of transaction codes).

For consigned receipts, although the actual ownership of the goods is not transferred, the movement statistics processor must create a record for the consigned receipts against the month when the receipt occurred. Since the value of the goods must correspond to an amount which would have been invoiced if the goods were sold or purchased, the movement statistics processor must populate the Value field with an estimated purchase price. Returns to Supplier (RTV) from consigned inventory are evaluated in the same way as regular returns.

For example, suppose that in May, consigned goods are received and delivered into stock by a buyer (an Oracle customer) in one EU member state from a supplier in another EU member state. Since the goods still remain the property of the seller, the transfer of ownership does not occur when the goods are received. Although no sale has occurred, the buyer must declare the goods as an arrival in his Intrastat declaration (for May), and state an amount which would have been invoiced had these goods been sold or purchased. The arrival record must be identified by the appropriate transaction code which identifies both Intrastat and Extrastat Arrivals, and Dispatches. The code values are defined in the Nature of Transaction Code lookup value.

Arrival and dispatch records based on consigned transactions can be created both automatically or manually as described in the following steps:

To automatically create consigned arrivals

1. Enter a standard purchase order for consigned goods.

2. Receive the consigned shipment.

3. Run the Movement Statistics Processor concurrent program selecting Source Type = Purchase Order.

4. Query the records generated from the Find Movement Statistics Form by entering the following criteria:

   • Legal Entity

   • Economic Zone

   • Movement Type: Arrival, and/or

   • Source Type: Purchase Order and

   • Document Type: Purchase Order No or Receipt Order Number

     An arrival record with Transaction code = 12 is created for consigned receipts.

5. Continue movement statistics standard reporting procedure by running the Movement Statistics Exception Report concurrent program.

To automatically create consigned returns

1. Enter Return to Vendor transaction for the consigned goods.

2. Run the Movement Statistics Processor concurrent program (selecting Source Type = Return to Vendor).

3. Query the records generated from the Find Movement Statistics form by entering the following criteria:

   • Legal Entity

   • Economic Zone

   • Movement Type: Dispatch, and/or

   • Source Type: Purchase Order and

   • Document Type: Purchase Order No or Receipt Order Number

     A dispatch record with Transaction code = 21 is created for consigned returns.

4. Continue movement statistics standard reporting procedure by running the Movement Statistics Exception Report concurrent program.

To manually create consigned receipts

1. Enter a standard purchase order for consigned goods.

2. Receive the consigned shipment.

3. Open either the Movement Statistics Details form or the Movement Statistics Summary form.

4. Select File > New from the toolbar to display the Transaction Types window. Complete your entries:

   • Select the Legal Entity (mandatory).

   • Transaction Type:

   • Select the Receipt Number.

   • Select the Inventory Organization.

5. Click OK to display the Movement Statistics Details form. Update the movement information if necessary.

   Note: You will not be able to save the manual record until all required fields have been entered. The status of the record will be Open when you save it.

6. Select Tools > Validate to validate the manual record against the validation rule set and for system validation. After you validate the record, the status of the record will be Verified.

7. Continue the movement statistics standard reporting procedure by running the Movement Statistics Report concurrent program.

To manually create consigned returns

1. Enter a Return to Vendor transaction for the consigned goods.

2. Open either the Movement Statistics Details form or the Movement Statistics Summary form.

3. Select File > New from the toolbar to display the Transaction Types window. Complete your entries:

   • Select the Legal Entity (mandatory).

   • Transaction Type:

   • Select the Receipt Number.

   • Select the Inventory Organization.

4. Click OK to display the Movement Statistics Details form. Update the movement information if necessary.

   Note: You will not be able to save the manual record until all required fields have been entered. The status of the record will be Open when you save it.

5. Select Tools > Validate to validate the manual record against the validation rule set and for system validation. After you validate the record, the status of the record will be Verified.

6. Continue the movement statistics standard reporting procedure by running the Movement Statistics Report concurrent program.

Intrastat Processing After Brexit

Brexit is the popular name given to the withdrawal of the United Kingdom from the EU as of January 1, 2021. This changes how EU countries report Intrastat information.

Northern Ireland (NI) remains within the EU and the material movement from NI to the remaining EU countries is valid up to the year 2024. During this time material movement from and to NI must be reported. However, material movement from the other UK countries (England, Scotland, and Wales) to the remaining EU countries changes.

• For UK Intrastat reporting, arrivals from EU to the rest of the UK are reported in Intrastat until December 31, 2021. Dispatches are excluded from the UK Intrastat report beginning January 1, 2021.

• For EU Intrastat reporting, material movement from EU countries to the rest of the UK is excluded from the Intrastat report beginning January 1, 2021.

Intrastat reporting after Brexit involves the following:

• Implement these two profile options:

  • INV: MVT Brexit GB Arrivals End Date

  • INV: MVT Brexit Processing Start Date

• Identify NI entities like organizations, customers, suppliers, and so on, by postal code, using the lookup INV_MVT_NI_POSTAL_CODE_PREFIX.

• Identify the overriding country code for NI using the lookup INV_MVT_NI_OVERRIDE_CNTRY_CODE. This country code appears on the Intrastat arrival and dispatch transactions between NI and other EU countries when the Movement Statistics Processor is run for a legal entity that belongs to an EU country.

For more information about lookups and profile options, see the sections “Defining Lookups” and “Defining Profile Options” respectively in chapter 2, Setup.

Note: For Intrastat reporting, services are excluded. Only material movement is considered.

Exclude Expense Items

Expense items are ordered once, are not stocked, and are delivered either to the expense subinventory or to the shop floor. For legal entities that do not require movement statistics reports for expense items, set the profile option INV: MVT Exclude Expense Items to Yes. For more information about this profile option, see “Defining Profile Options” in chapter 2, Setup.

By default, the Movement Statistics Processor treats transactions with no item name information as expense item transactions. For transactions with item name information, use the API user hook IS_EXPENSE_ITEM_CUSTOM to code custom logic to determine whether the item is an expense item or not. For more information about this API user hook, see “Define an Expense Item” in chapter 2, Setup.

Exclude Service Items

Service items are used in contracts. Movement Statistics reporting for service items is required only in Italy. In the Item Master window, Contract Item Type field, service items are set to a value that is not null. To exclude service items from reporting, set the profile option INV: MVT Exclude Service Items to Yes and set the countries for legal entities that require movement statistics reporting for services in the lookup INV_MVT_SERVICES_IN_COUNTRIES. For more information about the profile option and the lookup, see chapter 2, Setup.