This document explains how to set up inventory preferences and records, and how to enter and post transactions and work with stock counts. It also contains information about reporting, year-end closing, and inventory reconciliation and adjustments. How to Control Inventory. One of the most challenging aspects of running a business is learning how to effectively manage your inventory so you have what your customers need and want without having too much excess, which can be a waste of System of inventory control in which no continuous record of changes (receipts and issues of inventory items) is kept. At the end of an accounting period, the ending-inventory is determined by an actual (physical) count of every item and its cost is computed by using a suitable method such as FIFO, LIFO, weighted averages, etc. Inventory Control Management excel spreadsheet to help with ordering retail products. Free Inventory Management Software in Excel - Inventory Spreadsheet Template - Duration: 22:36. Get the Most Important Inventory Management Tool You Could Have. From real-time inventory tracking to accurate customer demand forecasts, DEAR Inventory is flexible enough to let you mix and match techniques and tools so you can use whatever works best to grow your business quickly and effectively. 4 Inventory Control User Manual 1 General Information Recovery Processing As you use the Inventory Control application, there is a certain day-to-day risk of losing data due to sudden power surges or outages, and other system problems. Recovery Processing is used to manually Stock control and inventory Stock control methods. There are several methods for controlling stock, all designed to provide an efficient system for deciding what, when and how much to order. You may opt for one method or a mixture of two or more if you have various types of stock. The Inventory Control module is tied very closely to the Sales Order Processing, Bill of Materials, Shop Floor Control, and Pu