Inventory Control

The Inventory Control module does the following:

  • Gives you an easy way to maintain inventory related files.
  • Accommodates multiple warehouse locations and lets you transfer stock between them.
  • Lets you buy and sell an item in multiple units of measure.
  • Stores vendor info (including pricing and lead time) on multiple suppliers per item.
  • Manages physical stock counts.
  • Handles substitute items and supersedes.
  • Provides an excellent automatic reorder system to determine which items to purchase and how many to buy.
  • Includes many useful inquiries and inventory management reports.

Stored information on each item includes: item code, short and long descriptions, weight, product class and sub-product class, tax code, two cross-reference fields, and special sales and purchase notes. Each item has a primary vendor and may have alternate vendors. Items may have multiple buying and selling units of measure, and can be serialized or lot-controlled.

You may stock items in multiple branches or locations. The system stores specific item information by location including: average cost, quantity on-hand, committed, and on-order, safety stock, minimum, maximum, and reorder quantities, warehouse bin location and the sales, cost of sales, and inventory G/L accounts.

Inter-warehouse transfers create sales orders at the sending location and purchase orders at the receiving location. This allows you to perform and track them easily.

A complete physical inventory routine lets you print stocktaking worksheets, quickly enter counted quantities, and analyze the variance between computer and counted quantities before posting.

You can reorder stock through the Order Requirements system, which can calculate minimum and maximum values from sales history. You can then automatically create purchase orders and inter-branch transfers based on these calculations.

The Stock Status Report highlights items that are negative, below minimum, or overstocked. Other management reports include the Inventory Valuation Report, Inventory Unit Movement Report, the Landed Cost Report, and the Price Margin Report, as well as price lists and six sales reports. The Transaction History Report lists inventory cost and movement transactions.

Screen inquiries display item information in six helpful formats. Item Inquiry shows quantities for all locations along with pricing, sales, and purchasing notes. Movement and Cost Inquiries show transaction history. Item Sales History shows dollar sales, profit, and quantity by month for this year plus two years prior. Item Analysis helps you learn the automatic reorder system, and the Serial # Trace follows a serialized item throughout the system.

item display2