Use the Movement Statistics window to view and maintain information associated with the movement of goods. You can automate the collection of this information through the Movement Statistics Parameters and Economic Zones setup windows.

You can also link movement statistics to financial transaction information, such as document numbers and invoices. See: Overview of Movement Statistics.

You can also manually enter movement information associated with material transactions that are not captured by Oracle Inventory and Purchasing, such as fixed assets.

Defaults in the Movement Statistics Window

The following defaults are used within the Movement Statistics window. The default value has the appropriate country prefix. If the new country-specific default is valid, it is displayed. If the constructed country-specific default is not valid, there is no default.

• Transaction Nature: Purchase order receipts line transaction reason code.

• Delivery Terms: Purchase order receipts header free-on-board

• Transport Mode: Purchase order receipts header freight carrier

Prerequisites

• Define movement statistics parameters see: Setting Up Movement Statistics

• Define economic zones see: Defining Economic Zones

   To view movement statistics:

1. Navigate to the Movement Statistics Summary window. The Find Movement Statistics window appears.

2. Enter search criteria to find an existing movement statistics record or close the Find Movement Statistics window to enter a new record. The Movement Statistics window appears.

   If you searched for an existing record, the following information is displayed at the top of the window:

   Movement ID: When you save the movement statistics information, the system assigns a unique movement number to identify it. This creates a movement statistics entry. You can use the number to view specific movement statistics entries.

   Status: The status of the entry, Open, Unprocessed, or Frozen. If the status is Frozen, you cannot change information associated with the entry.

   Report Reference: The number entered when this entry was officially reported and frozen.

   Report Period: The date this entry was officially reported and frozen.

3. Select the movement type.

   Arrival: Report arrival movement statistics.

   Arrival Adjustment: Report adjustments to prior period arrival movement statistics.

   Dispatch: Report dispatch movement statistics.

   Dispatch Adjustment: Report adjustments to prior period dispatch movement statistics.

4. Enter the amount that appears on the material movement transaction document.

5. Select the document source type.

6. Enter the name of the legal entity associated with this record.

7. Enter the currency.

   To enter source detail information:

1. Select the Source Details tabbed region. When you access this window from the Tools menu, default information in this region is supplied from your window of origin.

2. When the movement type is arrival and the source type is inventory, enter the organization from which the goods were sent in the From Organization field. If the movement type is dispatch, the current organization is displayed as the default.

3. When the movement type is dispatch and the source type is inventory, enter the organization to which the goods were sent in the To Organization field. If the movement type is arrival, the current organization is displayed as the default.

4. When the source type is sales order, enter the customer name, number, and location.

   When the source type is purchase order, enter the supplier name, number, and site.

5. Enter the source document number and line number for the selected source type. For example, if you entered a source type of purchase order, enter the corresponding purchase order number and line number.

6. Enter the shipment number and shipment line number associated with the movement.

7. Enter the pick slip number associated with the movement.

8. Enter the receipt number associated with the movement.

   To enter invoice details information:

1. Select the Invoice Details tabbed region. This region is not available for the source type Inventory.

2. When the source type is sales order, enter the customer bill-to name, customer number, and customer site.

3. Enter the invoice batch, invoice number, and invoice line number associated with the invoice information.

4. Enter the quantity of this movement invoice. The default is the transaction quantity if it has been entered. When the source type is sales order, the movement quantity is displayed.

5. Enter either the unit price or the extended value. Oracle Inventory calculates the other value.

   To enter movement details information:

1. Select the Movement Details tabbed region. When you access this window from the Tools menu, default information in this region is supplied from your window of origin.

2. For adjustment transactions only, enter the adjustments to movement number.

3. Enter the transaction date.

4. Enter the inventory item number or, if you have not entered an item number, the item description.

5. Enter the transaction UOM.

6. If a category set to hold commodity codes and a commodity code exists for the item, it is displayed. If no default exists, or if you want to override the default value, enter the appropriate commodity code. If you do not enter a commodity code, you can enter a commodity code description.

7. Enter the transaction quantity for this movement.

   To enter country detail information:

1. Select the Country Details tabbed region.

2. Enter the dispatch country in the Dispatch field. Oracle Inventory displays your country for dispatches. For arrivals, it displays either the supplier's or customer's country, depending on the transaction.

3. Enter the destination country in the Destination field. Oracle Inventory displays your country for arrivals. For dispatches, it displays either the supplier's or customer's country, depending on the transaction.

4. Enter the country of origin in the Origin field. Inventory displays either the dispatch or destination country based on the transaction.

5. Enter the transaction code.

6. Enter the delivery terms code.

7. Enter the transport mode.

8. Enter the port where the goods entered the country for arrivals or left the country for dispatches.

9. Enter the area where the goods entered the country for arrivals or left the country for dispatches.

10. Enter the statistical type for the movement. This can also be the import type, the regime, or a user-defined type.

11. Enter the unit weight or total weight for the item, and Oracle Inventory will calculate the other value. If you leave both weight fields blank, Inventory calculates the weight at report time using the item unit of measure conversions.

   To enter additional movement details:

1. Select the More Movement Details tabbed region.

2. Enter either an adjustment percentage or an adjustment amount. Oracle Inventory calculates a statistical value by applying the adjustment percentage or adjustment amount to the transaction value.

3. If you entered an adjustment percentage or amount, Oracle Inventory calculates the statistical total value for you. You can also enter the total value without entering an adjustment percentage or amount. If you do not enter any of the statistical value information, the report calculates the total value using a country specific routine.

4. Enter comments associated with the movement.

5. Enter an alternate quantity other than the transaction quantity to represent the amount of goods moved. If you enter an alternate quantity, you can record the alternate UOM code for the goods moved. For example, alcohol can be sold be sold by the case, but the alternate quantity can be the amount of pure alcohol in hectoliters.

6. Select the outside price code. You can enter Repair, Process, or Other.

7. Enter either the outside unit price or the outside extended value. Oracle Inventory calculates the other value.

8. Save your work.