Inventory Inquiry (3 of 3) (INV3)

Inventory Inquiry (3 of 3) (INV3) is used to maintain non-system generated information about stock items. Item account codes, price method options, and inventory control management parameters are set and/or modified using this screen. The Price Method and Fixed Surcharge fields can be updated from the Warehouse (WHS2) table.


Warehouse	Key field. Enter the warehouse where this stock item is stored. See Warehouse Management Index (WHSE) and Agency Index (AGCY) for valid values.
Stock Item	Key field. Enter the code identifying the stock item.
Description	Optional. Enter up to thirty characters of text describing stock item.
Vendor	Optional. Enter the suggested vendor for warehouse purchases of this stock item. See Vendor Index (VEND) for valid values.
Long Description	The commodity description of the stock item is displayed as it appears on the Commodity Table (COMT).
Primary Bin	Required. Enter the location of the stock item in the warehouse.
Bin 1	Optional. Enter an alternative location for the stock item or additional comments referring to the primary bin.
Bin 2	Optional. Enter an alternative location for the stock item or additional comments referring to the primary bin.
Issue Unit	Required. Enter the unit of measure used for inventory and issue. See Unit of Measure (UNIT) for valid values.
Purchase Unit	Required. Enter the unit of measure used for purchasing the stock item. See Unit of Measure (UNIT) for valid values.
Multiplier	Required. Enter the multiplying factor by which one unit of measure is greater than the other.
Smaller Unit	Required. Select the smaller unit of measure, Issue [I] or Purchasing [P] .
Item is Parent Item	Default is cleared [ N ]. Select [ Y ] to indicate that the stock item is a parent item.
ABC Class	Required. Enter the classification of the stock item for inventory management. See ABC Classification Parameter (ABCP) for valid values.
Active Stock Item	Default is selected [ Y ]. Select [ Y ] to indicate that the stock item is active.
Stock Group	Optional. Enter the item group to which this stock item is defined. It is used in the physical inventory freeze process to specify groups of stock items to freeze.
Mark for Future Deletion	Default is cleared [ N ]. Select [ Y ] if future deletion is desired.
Master Agreement	Optional. Enter the 11 digit alphanumeric master agreement number.
Object	Display only. The object code for stock items purchased for warehouse inventory is inferred from Warehouse Management (WHS2).
Revenue Source	Display only. The revenue source for stock items issued is inferred from Warehouse Management (WHS2).
BS Account	Display only. The balance sheet account for stock items on hand is inferred from Warehouse Management (WHS2).
Percent Surcharge	Defaults to 0 . Required if Price Method is Percentage Surcharge [P] or Percentage Price with No Surcharge [C] . Enter the percentage multiplied by unit cost to determine issue price.
Price Method	Default is Standard Price with No Surcharge [S]. Valid values are: Standard Price with No Surcharge [S] Percent Surcharge [P] Percent Price with No Surcharge [C] Fixed Surcharge [F] Same Price as in Parent Warehouse [W] Note: When the Revenue Warehouse Flag on the Warehouse (WHS2) table is not selected, it will set Fixed Surcharge as the price method.
Costing Method	Default is Average Cost.
Maximum Surcharge	Defaults to 0 . Optional if Price Method is Percentage Surcharge [P] or Percentage Price with No Surcharge [C] ; otherwise, leave this field blank. This field defines the dollar limit of percent surcharge, applied per unit, up to 3 decimal places.
Maximum Issue	Defaults to 0 . Enter the largest order quantity of the stock item issued. If you leave the entry at 0 , then a quantity of 0 items will be issued. The field accepts a maximum value of 9,999,999,999.
Fixed Surcharge	Defaults to 0.000 . Required when the Price Method is Fixed Surcharge [F] . Enter the fixed amount added to each unit cost when issued, up to three decimal places. Note: When the Revenue Warehouse Flag on the Warehouse (WHS2) table is not selected, it will set zero as the Fixed Surcharge.
Minimum Issue	Defaults to 0 . Enter the smallest order quantity of the stock item issued.
Standard Price	Defaults to 0.000 . Required when the Price Method is Standard Price No Surcharge [S] . Enter the item price upon issue of this stock item, up to three decimal places.
Quantity Per Issue	Defaults to 0.000 . Enter the number of units being issued, up to three decimal places.