ION Report - Inventory Levels

Jump to: navigation, search
Inventory Levels
This report lists the number of products at the selected warehouses based on a cutoff date and time period. Only Delivered orders are scanned. In July 2009, changes were made so that all inventory reports now include empties, even if an empty is assigned to a product category and that category is flagged to be omitted from ION sales reports. In December 2014, Remaining Allocations column was added to report. Remaining Allocations - # of items allocated but not yet delivered to customers.

In order for employees to access this screen, the "May Access Inventory Levels Report" checkbox on the Plugins Panel must be checked.

For a complete list of all available ION Reports, see Overview: ION Reports.

How-To Create an Inventory Level Report

  1. Select Inventory Levels off the Reports panel.
  2. Select the warehouses off the Warehouses panel. If only a single warehouse is chosen, then only inventory in that warehouse and its associated trucks will be counted.
  3. Select a Cutoff date and the number of months off the Date Selection panel.
  4. In the Conversions panel, select the type of pack or unit.
  5. In the Fields to Display panel, select the columns wanted in the report.
  6. Using the drop down arrow, bring up the Product Include or Exclude screen to select the products for the report.
  7. A checkbox at the bottom of the report allows you to display a graph showing the rising and falling levels during the range of time specified as you move between the different products.

Columns Explained

  • ItemKey - This column contains the product numbers.
  • ItemName - This column contains the product names.
  • Beginning - The beginning level is as of the beginning number of x number of months prior to the cutoff date as specified in the date selection panel.
  • Days With Changes - This lists the number of days that the inventory level was changed during the selected time frame.
  • Ending - The ending level is the inventory level as of the cutoff date specified in the date selection panel on the left hand side.
  • The graph is a line graph which simply marks the total amount of inventory of the selected product over the specified time. Holding the mouse pointer over on the line will list the date and the number of product associated with that date.