Required/Conditionally
Required FieldsThe Inventory Maintenance (INVN) table is used to add and maintain stock items in inventory. In addition to Stock Item and Warehouse Number, it is used to specify other essential stock item information such as Description, Suggested Vendor, Units of Issue, Purchase/Costing Methods, Pricing Methods, Surcharges and/or Unit Price, Shelf Life, and the Stock Group. The Track Quantity By Location flag indicates whether the stock item tracks inventory quantity at the location level (checked) or at the stock item level (not checked). The default value for this flag is inferred for new stock items based on the setting of the Track Quantity By Location flag on the Warehouse (WHSE) page. Part information (such as UPC, UNSPSC, Barcode, various part numbers, usage, references, and special handling instructions) can be recorded on the INVN table. This set of pages also facilitates the specification of other inventory management parameters like Parent Items, Active/Inactive Items, Maximum/Minimum Issue Quantities, Quantity Per Issue, ABC Class, and also allows for overriding the seller Object code, Revenue Source code, Departmental Object code, Departmental Revenue Source code, and BS account that are inferred from the warehouse table. It also provides an option to apply fixed price markups to the Unit Price at the warehouse/stock item level by selecting values in the Markup 1 through Markup 5 fields. The allowable fixed price markups are defined on the Inventory Markups (INVMKUP) table to allow for standardization of such charges across the site. Only the active records from the Inventory by Location (ILOC) table are displayed on the Location tab of this table.
Required/Conditionally
Required Fields
Special
Notes on the Auto Generate Part Number flags