Commodity Detail

The Commodity Detail tab on the RC and RCM transactions captures detailed stock item information at the time the stock item is received. The Commodity Detail tab is only allowed on a RC transaction if the Transaction Sub Type is RC, the Warehouse field is populated on the referenced Purchase Order Commodity line, and the Detail Information Required flag is checked on the Inventory Maintenance (INVN) page for the selected stock item/warehouse combination. On successful submission to Final of the RC transaction, the system will insert a new record on the Inventory Maintenance Detail table with the values entered on the corresponding Commodity Detail line. If the RC transaction that inserted the record on the Inventory Maintenance Detail table is discarded, then the system will reduce the on hand quantity by the cancelled received quantity or an error will be issued if the cancellation will reduce the on hand quantity to a value less than zero.

Required/Conditionally Required FieldsRequired/Conditionally Required Fields

A Commodity Detail line is required if the Detail Information Required flag is selected on INVN for the stock item and warehouse selected on the Commodity line. If the Detail Information Required flag is not selected on the Commodity line, then a Commodity Detail line cannot exist.

The following fields are required on this section:

  • Inventory Location

  • Received Quantity - The sum of the Received Quantity fields on the Commodity Detail lines must equal the Received Quantity on the referenced Commodity line. The value in the Received Quantity field on Commodity Details updates the On Hand Quantity on INVND. The update to the On Hand Quantity cannot result in a negative value.

  • Item Status

The following fields are conditionally required, if the Lot Expiration Tracking flag is selected on the INVN table for the Warehouse and Stock Item:

  • Lot/Batch Number

  • Lot/Batch Expiration Date

  • Notification Days Prior to Lot Expiration

If the Shelf Life field is populated, then the following fields are required:

  • Shelf Life Unit

  • Notification Days Prior to Shelf Expiration

If the Warranty Type field is populated, then the following fields are required:

  • Warranty Agreement Number

  • Warranty Description

  • Warranty Start

  • Warranty Expiration

  • Warranty Cycle Type

  • Warranty Cycle