The inventory tables maintain information regarding issuing and purchasing sides of the inventory transactions, transaction history, inventory usage history, as well as facilitates the establishment and maintenance of stock items in inventory. There are five tables used to establish and maintain inventory items. The five inventory tables are the Inventory Maintenance (INVN) table, Inventory Detail (INVND), Item Group (ITMG) table, Inventory Inquiry (INVNQ) page, and Inventory Usage (INVNU) table. (Note: In order to establish an inventory item, first there must be a valid warehouse on the warehouse table and second, valid inventory commodities must exist on the commodity table typically marked as inventory). The Inventory Maintenance (INVN) and the Inventory Inquiry (INVNQ) pages utilize the same table in the database.
The Inventory Maintenance table is used to associate an inventory item with a specific warehouse that is storing that item. This table contains the entire user maintained fields for the inventory page. The Inventory Detail (INVND) page allows you to record and track detailed information for each stock item. A warehouse manager can also bundle items that will be issued as a set on the Item Group table. For example, a requestor would request a toolbox (parent item) and would be issued a toolbox as well as a screwdriver and hammer (child items). The Inventory Inquiry page is a display only table that displays both the system maintained fields and the user maintained fields from Inventory Maintenance. The Inventory Markups (INVMKUP) page defines the fixed price markups that can be selected on the INVN page to be used in calculating the Unit Price based on the selected Pricing Method. Finally, the Inventory Usage table is used to change monthly usage and forecast quantities.
This topic includes the following: