Inventory Control System Features:

Harvest includes a powerful Inventory Management System which provides the foundation to lower operation costs and improve company profits. Inventory is maintained by Warehouse and location as well as by Tank.

The system provides the tools to determine efficient stocking levels, identify production gains and losses, manage finished good and raw materials replenishment, maintain accurate costs, organize the warehouse, conduct more efficient physical inventory counts, identify slow moving and dead products, and plan the production process.

If you are a Contract Blender, Packager, or Bulk Terminalling Operator, Harvest has incorporated special features to help you better service your customer's clients. Inventory packages such as contract packaged drums are identified by both your lot number and your customer's lot number. Bulk Terminallers will appreciate our inventory by tank by customer which shows all transactions for a specific tank. Month end reports of customer's inventory are quickly generated and easily emailed to you contract customer.


More on Process Manufacturing Inventory below.



Inventory products are divided into type and group categories for quick product searches. A primary unit of storage is determined - either gallons or pounds. Cross conversions are available through the pounds per gallon calculation.

The system divides inventory quantities into these categories:

  • On Hand - Total quantity in stock.
  • Committed - Quantity committed for use in Sales, Batch or Packaging Orders.
  • Available - Quantity available for use. Product not committed to existing orders.
  • Back Ordered - Quantities that have open Purchase, Batch or Package Orders.
  • Required - Quantities where orders exist and inventory is not available to fill the orders.

Utilize the Minimum - Maximum inventory replenishment system. A replenishment report provides restocking information. When minimum quantity levels are met or products fall into a required status, the report flags those items for easy identification. For example, suppose that a sales order is received where some of the product required to fill the order is available and some of the product is not available. The system would mark the product that is available to committed to fill that sales order. The products on the sales order not available to fill the order would be marked as required to fill the order. When a package order is generated to make the product that is not available, the status of the product on the sales order would be updated to back ordered. If any of the raw materials required to make the package are not available, the status of the raw materials would change to required to fill the packaging order. When a batch order for the bulk product is issued, the status of raw materials not available to make the batch would be changed to required. If raw materials are available to make either a batch or package, the status of the available product would change to committed. As purchase orders are released for the required product, the product status changes to back ordered. As materials are received or production orders are closed the product status is updated to committed. The system handles these complex allocations quickly and efficiently. Product status can be quickly checked by reviewing the Associated Orders Screen.

Provide material usage and product sales reports to help in determining efficient stock levels. Some of our customers have used these tools to reduce inventory levels saving hundreds of thousands of dollars.

Assign lot numbers and tracks lot history for both both raw materials and finished goods. Inventory quantities are maintained by location and lot number. This provides the tools for managing and maintaining an organized warehouse and the shipment of products by the oldest lot numbers first. It also minimizes lost product in the warehouse.

Utilize a weighted average cost system to accurately reflect inventory costs. Store the last cost which is the last cost of manufacturing or purchasing materials.. Maintain a future cost for future price changes from vendors. This is useful in periods of fluctuating costs. The formula deck can be printed showing the future cost of formula when the price increases take effect. This helps the marketing department pass on price increases to protect margins in a timely manner.

Tag Count Physical Inventory Tag sheets are printed and inventories counted by location are entered into the system. Inventory reports showing counted quantities by location and what the computer shows for the location provide information to quickly determine where recounts should be performed.

The system provides many reports including:

  • Restocking and On hand Inventory Report.
  • Detail Report By month or range of months showing beginning balance, detail transactions and ending balance.
  • Summary Inventory Report which can be printed for any month at anytime.
  • Inventory by location reports.
  • Inventory by Lot number and transactions.
  • Usage Reports.
  • Dead and slow moving product reports.
  • And more.

Harvest provides the tools to effectively control and manage one of your company's biggest assets, it's inventory. It's a tool that will help improve the efficiency of your company and profits.

Inventory Master - Where raw materials and finished goods are entered into the system. A product code number can either be numeric or alpha-numeric. The Harvest System Inventory Master Screen shows the key elements of the inventory control system.

  • Order entry screens (sales, purchase, batch, package) have the same look and organization which facilitates learning.
  • Layout is logical and not complicated. Harvest customers quickly learn how to use the system even if they have never had any windows experience.



Inventory Master - Key Elements

  • Product Code Number - Product Code that identifies the product to the system.
  • Description - Name of the product.
  • Manufacturing Part Number - Optional number that can be the primary vendors stocking number.
  • Type - Inventory products are assigned to a type such as RM for raw materials, FG for finished goods. Useful for isolating specific products for reports.
  • Group - Inventory products are assigned to a group such as Cartons, Pallets, Export, Domestic, etc. Useful for isolating specific products for reports..
  • Unit of Measure - B for bulk, DM or DR for drum, PL for pail, T for tote, etc. G or # - either gallon, # or lb for pound, N for neither.
  • Avg Cost - Weighted average cost maintained by the system. Presents a true cost.
  • Last Cost - Last purchase or manufacture cost of the product.
  • List Price - Used as a 1st level retail price.
  • Future Cost - Used when price changes are passed on from vendors. Another part of the system actual tracks price changes by vendor with a price change date.
  • Pack Size - 1 for bulk, 55 for a 55 gallon drum, 5 for a 5 gallon pail, etc.
  • Lb or G per Unit - Manufacturing Unit such as 1 for bulk, 55 for drum, etc.
  • Sales Pack - 1 for bulk, 55 for drum, etc. Used for marketing reports to determine exact number of pounds or gallons sold from drums, pails, bulk, etc.
  • Sales Unit per package - always 1 and used in marketing reports.
  • Generic - If the product is a finished good then the generic code goes in this field.
  • Lbs per gallon - The number of pounds per gallon and used to convert gallons to pounds in the system.
  • Hazardous Code - Used to classify products by hazardous materials codes for reporting purposes.
  • RMS - Raw Material Specifications code.
  • Sales Code - Inventory Code - Cost of Sales Code - used to direct accounting entries into the general ledger without manual intervention.
  • Minimum Stock - Minimum order quantity.
  • Maximum Stock - Maximum order quantity.
  • Normally Stocked - Click box for generating reports for reordering.
  • Bill In Gallons - used when inventory based in pounds is sold as gallons with a gallon price.
  • Track Lots - Click box when marked turns on lot tracking for the product.
  • Sales Territory - Used in some systems for reporting of sales by product territory.
  • Stock - Number of Units in Stock.
  • Not Committed - Number of units available for sale.
  • Committed - Number of units for which orders exist whether blend, packaging or sales orders.
  • Required - Number of Units needed to fill orders whether purchase, blend, pack or sales orders.
  • Appropriated - Number of units appropriated to fill orders.
  • Not Appropriated - Number of units not appropriated to fill orders.

Inventory is tracked by lot and by location.
Maintaining inventory in this manner organizes the warehouse and makes it easier to find products. It is easy for users to track lots and locations. When product moves out or in, the system displays a screen showing all the products on the order with the existing lot numbers and locations. The quantity is already marked for the default location, so if tracking is not required, the user presses Enter.

Normal system flow:
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 package 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:

  • Transactions
  • Usage
  • Customer Purchases
  • Vendor History
  • DOT Screen
  • Lot Masters and Lot History

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.
  • Copy Product Warehouse - In some systems used to copy existing product codes to a new warehouse.
  • Copy Product Regular - Similar products can be quickly entered into the system by copying. The product to copy is entered with a new product number and product name.
  • Matrix / Customer Prices - Prices can be set on a customer by product basis with quantity matrix.
  • Matrix Pricing - Pricing breaks can be set by quantity purchased.
  • Physical Inventory Tag Report System - Each item in the warehouse and counted with a tag. Tags are sequentially numbered and stored in the computer. Inventory count balances between the computer and the tag counts are printed and recounts issued. Physical adjustments can be entered manually or the computer will automatically adjust the balances.

Inventory Reports:
On hand inventory report
Month end inventory summary report
Transaction history by month or other time period
Physical adjustment report
Inventory by location report
Raw Material Requirements report
Finished Goods Requirements

www.harvestsoftware.com
Harvest Software Systems, Inc.
Process Manufacturing Software
Contact us at info@harvestsoftware.com
Phone (281) 361-9359

© 2011 Harvest Software Systems, Inc. All Rights Reserved
Modified 11/22/11