IA Commodity

The following fields are required on the Inventory Location Change (ILC) transaction. These fields are specific to the ILC transaction.

• Quantity

• New Inventory Location

• New Location Structure

• New Location Priority

The following fields are conditionally required if a record is inserted on the tab:

• Stock Item

• Adjustment Code

• Inventory Location - If the Track Quantity By Location flag is not checked on the Inventory Maintenance (INVN) page for the selected stock item/warehouse combination, then Advantage will infer the Inventory Location with the highest priority on the Inventory by Location (ILOC) page. This value cannot be changed. If the Track Quantity By Location flag is checked on the INVN page for the selected stock item/warehouse combination, then you must manually select the Inventory Location that should include an adjustment. A Commodity line must be added for each Inventory Location that needs a stock item adjustment. The total On Hand quantity for the stock item is updated on INVNQ, and the On Hand Quantity for each inventory location with a stock item adjustment is updated on ILOC and in the Location grids on INVN and INVNQ.

• Both the Change in Quantity and Change in Unit Cost can only be entered at the same time the first time you are initializing inventory counts. Once there has been an On Hand Quantity, the system will only allow one or the other to be adjusted in a single transaction.