IA Commodity Detail

The Commodity Detail tab on the Inventory Adjustment (IA) transaction allows you to adjust/add detailed stock item information. The Commodity Detail tab is only allowed on an IA transaction if the Sub Type is IA or IIA 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 IA transaction, the system inserts a new record (if the Line Action is New) or the system updates an existing record (if the Line Action is Modify) on the Inventory Detail (INVND) table with the values entered on the corresponding Commodity Detail line.

If the Line Action is Modify, the Item ID field is populated on the General Information tab, and the Load Inventory Maintenance Details action is selected, then the values for many fields on this tab are inferred from the corresponding Inventory Detail (INVND) record.

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 tab:

Line Action
Inventory Location
Quantity (only for the Inventory Location Change (ILC) transaction)
Change in Quantity - This field captures the change (increase/decrease) in quantity of the stock item. The sum of the Change in Quantity fields on the Commodity Detail lines must equal the Change in Quantity on the referenced Commodity line. The value in the Change in Quantity field on Commodity Detail section increases or decreases the value in the On Hand Quantity field on INVND. The update to On Hand Quantity cannot result in a negative value. If the Line Action is New, then the On Hand Quantity equals the value in the Change in Quantity field. $0.00 is the default value for this field, which indicates no change in On Hand Quantity for the selected stock item/warehouse combination.
Change in Unit Cost - This field captures the change (increase/decrease) in the unit cost of the stock item. The value in the Change in Unit Cost field on Commodity Detail section increases or decreases the value in the Unit Cost field on INVND. The update to Unit Cost cannot result in a negative value. If the Line Action is New, then the Unit Cost on INVND equals the value in the Change in Unit Cost field.

The following field is required if the Line Action is Modify:

Item ID

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 Date
Warranty Expiration Date
Warranty Cycle Type
Warranty Cycle