10 Consumption Reporting For Outbound Inventory

This chapter contains the following topics:

10.1 Understanding Consumption Reporting for Outbound Inventory

Reporting consumption is an integral part of the JD Edwards EnterpriseOne Outbound Inventory Management system. When your customer reports consumption of consigned inventory or VMI with consignment, you take decisions to generate billing and replenishment orders, and update the quantity levels at your customer's location.

Because the supplier is responsible to maintain inventory at the customer's location, they take all replenishment decisions as suggested by the customer or demand. Based on the replenishment method you set up, you can replenish outbound inventory based on a one-to-one or reorder point.

When you report consumption, the system:

  • Updates inventory levels at the customer's location

  • Generates quantity suggestions for you to take informed decisions on replenishment

  • Subtracts the consumed quantity from on-hand quantity available at customer's location

  • Generates billing orders for the consumed quantity

You can report consumption by specifying item and location, or by specifying the item, location and lot. The system also enables you to override the default price for billing and default quantity for replenishments that the system displays in the application. When you override the default quantity or price, you can send the overrides for approval to an agreement manager.

You use the Report Outbound Inventory Consumption application (P42I03) to report outbound inventory consumption. You use the same application to override the default suggested quantity for replenishment and default price for billing.

10.2 Reporting Consumption for Outbound Inventory

This section provides an overview of the Report Outbound Inventory Consumption application and discusses how to:

  • Set processing options for the Report Outbound Inventory Consumption application (P42I03).

  • Report outbound inventory consumption.

10.2.1 Understanding the Report Outbound Inventory Consumption Application (P42I03)

When you report outbound inventory consumption, the system updates the following information in the Outbound Order Consumption Report File table (F42I03):

  • Unique consumption ID

  • Quantity consumed

  • Relieve inventory flag

  • Consumption batch number

  • Related replenishment and billing order numbers

  • Price and quantity override information

When you report outbound inventory consumption, the system updates the following information in the Outbound Inventory Agreement Acknowledge table (F42I02):

  • Consumed quantity

  • Consumption status

  • Consumption date

The system retrieves acknowledged outbound inventory data from the Outbound Inventory Agreement Acknowledge table (F42I02) to populate the grid in the Report Outbound Inventory Consumption application (P42I03). You can summarize the quantity and item information by item and location, or by item, location and lot information.

After the system retrieves acknowledged outbound inventory records from the F42I02 table, you can either report full consumption of the quantity or partial consumption from the acknowledged quantity. You can also report consumption by specifying either the quantity that was consumed or the quantity that is available for consumption.

The system also displays the age of inventory of the acknowledged quantity for you to take an informed decision about reporting consumption of items. For example, you may want to report consumption of items that have a higher age of inventory and are to expire soon. The system calculates the age of inventory as the difference between the current system date and the date when you received the quantity.

The system also allows you to report consumption in dual unit of measure for dual pick items. You can check the availability in both the primary unit of measure and the secondary unit of measure. You can also report the consumption using both the primary and secondary unit of measures.

10.2.2 Setting Processing Options for the Report Outbound Inventory Consumption Application (P42I03)

Processing options enable you to specify default values, define the processes to generate replenishment and billing orders, and define versions of programs that are accessed by the Report Outbound Inventory Consumption program (P42I03).

10.2.2.1 Default

Use these processing options to specify the default values to be used by the Report Outbound Inventory program.

Outbound Branch/Plant

Use this processing option to specify the default outbound branch/plant that appears in the Report Outbound Inventory Consumption application.

Sold To

Use this processing option to specify the default Sold To value that appears in the Report Outbound Inventory Consumption application.

Ship To

Use this processing option to specify the default Ship To value that appears in the Report Outbound Inventory Consumption application.

Document Type

Use this processing option to specify the document type for relieving inventory during consumption reporting.

10.2.2.2 Process

Use these processing options to specify if the system generates replenishment and billing orders from the Report Outbound Inventory Consumption application.

Relieve Inventory

Use this processing option to specify whether the system relieves inventory during consumption reporting. Values are:

Blank: Do not relieve inventory

1: Relieve inventory

You use this processing option to relieve inventory from customer's location for quantity that has been transferred using internally owned shipment order lines.

If you move inventory to customer's location using a customer owned VMI sales/billing line, the system relieves inventory during consumption reporting irrespective of the value you enter in this processing option.

Replenishment Order

Use this processing option to specify whether the system generates a replenishment order during consumption reporting. Values are:

Blank: Do not generate replenishment order

1: Generate replenishment order

When you set the processing option to 1, the system calls the Generate Outbound Replenishment Order program (R42I30) to create replenishment orders.

Billing Order

Use this processing option to specify whether the system generates billing order during consumption reporting. Values are:

Blank: Do not generate billing order

1: Generate billing order

When you set the processing option to 1, the system calls the Generate Outbound Billing Order program (R42I20) for internally owned shipment order detail lines. For customer owned VMI order detail lines, the billing is completed when inventory is shipped to the customer's location.

10.2.2.3 Versions

Use these processing options to specify the versions of programs that are called from the Report Outbound Inventory Consumption program.

1. Generate Outbound Billing Order (R42I20)

Use this processing option to identify the version of the Generate Outbound Billing Order report (R42I20) for subsystem processing after reporting consumption.

Note: Ensure that you specify the version that is set up for subsystem processing.

2. Generate Outbound Replenishment Order (R42I30)

Use this processing option to identify the version of the Generate Outbound Billing Order report (R42I20) for subsystem processing after reporting consumption.

Note: Ensure that you specify the version that is set up for subsystem processing.

10.2.3 Reporting Consumption for Outbound Inventory

Access the Report Outbound Inventory Consumption program.

Form Name Form ID Navigation
Report Outbound Inventory Consumption W42I03A Outbound Inventory Order Processing (G42I10), Report Outbound Consumption

On the Report Outbound Inventory Consumption application, complete the following fields:

Item Number

Enter a number that identifies the item for which you want to report consumption.

Outbound Branch/Plant

Enter the outbound branch/plant for which you want to filter records to report outbound inventory consumption.

Sold To

Enter the address book number that represents the Sold To value of the customer.

Ship To

Enter the address book number of the location to which you want to ship inventory.

Location

Enter the value that represents the outbound inventory location.

Customer PO

Enter a number that represents the customer's purchase order.

Lot/Serial

Enter a number that identifies the lot or serial number of the outbound inventory for which you want to report consumption.

Summarize By

Select an option to specify whether the system summarizes the records in the grid by item and location or by item, location and lot.

Select the Item/Location option to summarize records by item and location. Select the Item/Location/Lot option to summarize records by item, location and lot.

After completing the Summarize By field, click the Search button. The system populates the grid with records depending on your search criteria.

On the Report Outbound Inventory Consumption application, complete the following fields in the grid:

Full Consumption

Select this option to report full consumption of the outbound inventory from the order detail line.

Primary Quantity Consumed

Enter the quantity that was consumed from the order detail line. This quantity is expressed in the primary unit of measure.

Primary Quantity Remaining

Enter the quantity that is available for consumption at the customer's location from the order detail line. This quantity is expressed in the primary unit of measure.

Secondary Quantity Consumed

Enter the quantity that was consumed from the order detail line. This quantity is expressed in the secondary unit of measure.

Secondary Quantity Remaining

Enter the quantity that is available for consumption at the customer's location from the order detail line. This quantity is expressed in the secondary unit of measure.

Consumption Date

Enter the date when the inventory at the outbound location is consumed by the customer.

Consumption Reported Date

Enter the date when the outbound inventory consumption is reported.

Age of Inventory

Review the age of inventory of the quantity in the order detail line. You can use this information to take informed consumption reporting decisions.

After completing the fields in the grid, click the Report Consumption button. The system then creates a unique batch number for the consumption you report. The system uses the next number (42I/NN) to create the unique batch number.

10.3 Overriding Price and Quantity

This section provides an overview of the following and discusses how to:

  • Override price for billing orders

  • Override suggested quantity for replenishment

  • Approve overridden replenishment quantity and price

10.3.1 Understanding Overriding Price and Quantity

When you report outbound inventory consumption, the Report Outbound Inventory Consumption application enables you to generate replenishment and billing orders. You can override the suggested quantity for replenishment as well as the price for the billing orders. You use the Override Price and Replenishment Quantity application to override default price and quantity suggestions.

10.3.2 Overriding Price and Quantity

Access the Report Outbound Inventory Consumption application. Search for the desired outbound inventory orders using the filter criteria. To access the Override Price and Replenishment Quantity application, select the order detail line for which you want to override the price and replenishment quantity suggestion, and click the Override Price/Quantity button.

On the Override Price and Replenishment Quantity application, complete the following fields:

Unit Price

Enter the amount with which you want to override the agreement unit price.

Replenishment Quantity

Enter the quantity with which you want to override the suggested replenishment quantity.

Click the OK button.

Depending on the Price Override Approval Flag and Replenishment Qty Override Approval option you set up in the Outbound Inventory Agreement Details application, the system might send the overrides to an agreement manager for approval.

10.4 Approving Replenishment Quantity and Price Overrides

This section provides an overview of approving replenishment quantity and price overrides, lists prerequisites, and discusses how to:

  • Set processing options for the Work With Outbound Inventory Quantity and Price Override Approvals program (P42I08)

  • Approve replenishment quantity and price overrides

10.4.1 Understanding Approving Replenishment Quantity and Price

You can override both replenishment quantity and price for a consumption detail line. When you override the suggested replenishment quantity or price, the system sends the overrides to the agreement manager for approval. The agreement manager then uses the Work With Replenishment Quantity and Price Override Approval application to approve the overrides.

10.4.2 Setting Processing Options for the Work With Replenishment Quantity and Price Overrides program (P42I08)

You use processing options to set the default values in the Work With Replenishment Quantity and Price Override Approval application.

10.4.2.1 Default

Outbound Branch Plant

Use this processing option to specify the default outbound branch/plant in the Outbound Inventory Quantity and Price Override Approval application.

Item Number

Use this processing option to specify the default item number in the Outbound Inventory Quantity and Price Override Approval application.

Sold To

Use this processing option to specify the default Sold To value in the Outbound Inventory Quantity and Price Override Approval application.

Ship To

Use this processing option to specify the default Ship To value in the Outbound Inventory Quantity and Price Override Approval application.

10.4.3 Approving Replenishment Quantity and Price

Access the Work With Outbound Inventory Quantity and Price Override Approvals form.

Form Name Form ID Navigation
Work With Outbound Inventory Quantity and Price Override Approvals W42I08A Outbound Inventory Order Processing (G42I10), Quantity Price Approval

Note:

You must sign in to JD Edwards EnterpriseOne as an agreement manager to use the Work With Outbound Inventory Quantity and Price Override Approvals application.

On the Work With Outbound Inventory Quantity and Price Override Approvals form, complete the following fields:

Outbound Branch/Plant

Enter the outbound branch/plant for which you want to filter records.

Item Number

Enter a number that identifies the item for which you want to filter records.

Sold To

Enter the address book number that represents the Sold To value of the customer.

Ship To

Enter the address book number of the location to which you want to ship inventory.

Pending Approval for

Select the Price Override option to filter records where price has been overridden.

Select the Quantity Override option to filter records where replenishment quantity has been overridden.

Select the Both option to filter records where both replenishment quantity and price has been overridden

After completing the search criteria, click the Search button to filter grid records. After the system retrieves the required grid records, review or complete the following fields on the grid:

Overridden Unit Price

Review the overridden unit price of the item. You can change the overridden value before approval.

Overridden Quantity

Review the overridden replenishment quantity. You can change the overridden value before approval.

Suggested Quantity

The system calculates a suggested quantity before you generate replenishment orders, by using the following formula:

Suggested Quantity = Target inventory - Quantity ready for consumption - (Open sales order + Quantity in-transit)

After you have reviewed the overridden replenishment quantity and overridden unit price, select Approve from the Row menu. The system creates replenishment and billing orders using the overridden values.

10.5 Reversing Consumption (Release 9.1 Update)

This section provides an overview of reversing consumption of outbound inventory and describes how to reverse consumption using the Report Consumption program.

10.5.1 Understanding Reversing Consumption

If you want to revert consumption records that you entered incorrectly, use the reverse consumption process. Also, you can use the reverse consumption process to correct the quantity balance when conducting an audit for outbound inventory consumption.

Note:

You can use the reverse consumption process for full quantity reversal only.

You can use the reverse consumption process on orders that have been billed and replenished. In such case, the system adjusts the quantities, but does not reverse the billing and replenishment orders. When you reverse a consumption record, the system updates the following information:

Table Information Updated
Outbound Inventory Agreement Acknowledge (F42I02)
  • Quantity Consumed = Quantity Consumed - Reversed Quantity
  • Secondary Quantity Consumed = Secondary Quantity Consumed - Secondary Reversed Quantity

  • Consumption Date = Blank

  • Consumed Line Status = 0

Outbound Order Consumption Report File (F42I03) - Consumption Record
  • Consumption record is updated with consumption type.
  • New record is added with the same consumption batch number and consumption type.

Note. You can save a consumption record with the following consumption types:

  • 1: Consumed record is not reversed

  • 2: Consumed record is fully reversed

  • 3: Consumed record is partially reversed (for future use)

  • 4: Reversed record

Outbound Order Consumption Report File (F42I03) - Reversal Record When you reverse consumption for a given consumption record, the system creates a corresponding reversal record for the same consumption batch number. The system updates the following information:
  • A unique consumption ID

  • Quantity Consumed = Quantity Consumed in original consumption record

  • Secondary Quantity Consumed = Secondary Quantity Consumed in original consumption record

  • Consumption Date = System Date

  • Consumption Reported Date = System Date

  • Consumption Type = 4

Outbound Inventory Item Balance (F42I021)
  • Quantity On-hand = Quantity On-hand + Reversed Quantity
  • Secondary Quantity On-hand = Secondary Quantity On-hand + Reversed Quantity

  • Quantity Consumed = Quantity Consumed - Reversed Quantity

  • Secondary Quantity Consumed = Secondary Quantity Consumed - Reversed Quantity


Note:

You can reverse a consumption record only once.

10.5.2 Reversing Outbound Inventory Consumption

You reverse an outbound inventory consumption by using the Work With Consumption program (P42I031). The system displays all outbound inventory consumption records. You can filter consumption records by consumption batch numbers, item number, Sold To, and Ship To values.

  1. Access the Work With Consumption program.

    Form Name Form ID Navigation
    Work With Consumption W42I031A Outbound Inventory Order Processing menu (G42I10), Outbound Consumption.

    Figure 10-1 Work With Consumption form

    Surrounding text describes Figure 10-1 .
  2. On the Work With Consumption form, complete the Consumption Batch Number, Item Number, Sold To, and Ship To fields to filter records.

  3. Select the consumption record you want to reverse, and click the Select button.

    The system displays the Report Consumption form.

    Figure 10-2 Report Consumption form

    Surrounding text describes Figure 10-2 .
  4. On the Report Consumption form, select the records you want to revert.

  5. Select Reverse Consumption from the Row menu.