Inventory Reports
This series of reports looks at the store inventory for your selected accounting company.
This series of reports looks at the store inventory for your selected accounting company. They are found in the AMS menu under Money, The Store, Inventory Reports. Below is a listing with descriptions of those various reports. For more information about running reports, refer to the Report Wizard section.
The first report compares the available stock to the low limit reorder point. Available stock is the quantity on hand less any items that have been committed but not yet processed through to a sale. If the stock is below the low limit the item is listed along with the order quantity to bring it up to the high limit, the value of that order and the preferred/secondary suppliers.
The Inventory Status report lists all stock for the selected accounting company and displays their on hand, committed and returned quantities.
- Inventory Sales- details on inventory sales for a given date range
- Inventory Sales Summary- summary of inventory sales for a given date range
- Stock Reorder Alert Report- gives a worksheet with quantity amounts for Inventory items based on inventory Group & Type. These fields are required
- Quantity Status of all Inventory Items- gives quantity amounts for all Inventory items
- The Cost Value of Inventory by SKU- calculates the cost value of the on hand plus returned stock by SKU
- The Cost Value of Inventory by GL Account- calculates the cost value of the on hand plus returned stock by the Inventory GL Account
- Physical Inventory Worksheet by SKU- aid for counting the actual stock on hand. It is available ordered by SKU
- Physical Inventory Worksheet by Location- aid in counting the actual stock on hand. It is available ordered by Location/Bin/Shelf