OC Commodity Detail

The Commodity Detail tab on the Over-the-Counter (OC) transaction allows you to capture detailed stock information at the time the stock item is being issued. The Commodity Detail tab is only allowed on an OC transaction if 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 OC transaction, the system updates the referenced record on the Inventory Detail (INVND) table based on the selected Item ID with the values entered on the corresponding Commodity Detail line.

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:

Item ID – If this field is populated, then after selecting Save, the system infers values from the corresponding record on INVND to this tab.
Requested Quantity - This field captures the quantity of the stock item being issued. The sum of the Requested Quantity fields on the Commodity Detail lines must equal the Requested Quantity on the referenced Commodity line. For New OC transactions, the value in the Requested Quantity field on Commodity Detail tab decreases the amount in the On Hand Quantity field on INVND, when the transaction goes to Final. The update to On Hand Quantity cannot result in a negative value; therefore, the value in this field cannot be greater than the value in the On Hand Quantity field. The value in this field cannot be negative. For Modification OC transactions, the On Hand Quantity on INVND is updated with the difference between the latest previous version and the version entered on this modification transaction, when it goes to Final.