Inventory Master - Key Elements

• Product Code Number - Product Code that identifies the product to the system.
• Description - Name of the product.
• Manufacturers Part Number - Optional number that can be the primary vendors stocking number. This can print on Purchase Orders.
• Type - Inventory products are assigned to a type. This is useful for isolating specific products for reports and for finding products quickly.
• Group - Inventory products are assigned to a group such as size grouping or materials grouping. Useful for isolating specific products for reports and for finding products quickly.
• Unit of Measure - The unit it will be stocked, purchased, and sold in. EA if sold singly, 100 if sold in boxes of 100, 300 if sold in boxes of 300.
• Avg Cost - Weighted average cost maintained by the system. Presents a true cost.
• Last Cost - Last purchase cost of the product.
• List Price - Used as a 1st level retail price.
• Mininum and Maximum Stock - used in reports and for automatic purchase order.
• Stock - Number of Units currently in Stock. This can be entered on initial product entry, but subsequently can only be changed through transactions.
• Not Committed - Supplied by the System: Number of units available for sale.
• Committed - Supplied by the System: Number of units for which orders exist whether blend, packaging or sales orders.
• Required - Supplied by the System: Number of Units needed to fill orders whether purchase, blend, pack or sales orders.
• Appropriated - Supplied by the System: Number of units appropriated to fill orders.
• Not Appropriated - Supplied by the System: Number of units not appropriated to fill orders.

Normal system flow is as follows.
Sales orders are taken during the day. If the quantity ordered is not in stock or if there is not enough product to fill the orders then the balance goes to required. That night or the next morning, inventory reports are generated to determine which goods need to be ordered to fill the existing reports. If finished goods are required then transfer orders are generated to fill orders which in turn flags raw materials to determine if sufficient stock remains to make the existing orders. Purchase orders can be entered either manually or automatically by the system.

Auxiliary View and Information Screens:

• View Transactions
• Vendor Prices
• Vendor History
• View Usage History
• View Customer Purchases
• View Customer Part numbers

Inventory Control Auxiliary Task Screens:

• Physical Adjustments Screen
• Cost Adjustments
• Verify Files - Used to verify all allocations.
• Print & Post Adjustments - Physical adjustments are posted to the general ledger via this program.
• Delete Products - Used to delete products from the inventory master.