Current Inventory Snapshot Report

The Current Inventory Snapshot report provides a snapshot of real-time inventory data. You can use it to monitor inventory levels and determine ordering schedules.

The Current Inventory Snapshot report can help you pinpoint which items are low on stock and place orders accordingly.

For each inventory item, this report lists the item name, description, and preferred vendor. This report shows the following amounts for each location and in total:

  • Reorder Point – the stock level at which a new order for the item needs to be placed.
  • When an item reaches its Reorder Point, a reminder is generated to purchase the item.
  • Quantity On Hand – the number of units of an item in stock.

  • Quantity On Order – the number of units of an item pending receipt from a vendor.

  • Quantity Committed – the number of units of an item reserved by unfulfilled sales orders.

  • Quantity To Order – the number of units of an item you need to order to maintain stock.

  • Preferred Stock Level – the optimum quantity to maintain in stock of an item.
  • Along with the reorder point, this quantity is used to determine your replenishment needs on the Order Items page.
  • Average Cost – total units available during a period divided by the starting inventory cost plus the cost of additions to inventory.

  • Last Purchase Price – the most recent transaction price at any location.

  • Last Transaction Date – the most recent transaction date at any location.

  • Preferred Stock Level – the optimum quantity to maintain in stock of an item. The ideal quantity is the amount you need to fulfill orders in a timely manner without either running out or overstocking.

  • Reorder Point – the stock level at which a new order for the item needs to be placed.
  • When an item reaches its Reorder Point, a reminder is generated to purchase the item.
  • In Transit – items are in the process of being transported.
  • Also, a value does not display for these fields for items that do not have a preferred location set.

To see a current inventory snapshot report:

Go to Reports > Inventory/Items > Current Inventory Snapshot.

Leave a comment

Your email address will not be published. Required fields are marked *