Negative Inventory Reporting

Most businesses rarely should have negative inventory quantities for their items. There are scenarios where you might sell items into the negative:

  • Clerks accidentally selects the wrong item to sell
  • Item was received with the incorrect quantity
  • A receiver was never processed for the item

There is a report that you can use to locate items with negative inventory quantities. Follow these steps to run a report for items with negative inventory:

  1. From the Launchpad, select Inventory → Reports → Inventory Status Report


  1. Set Include items if qtys on hand are to Non zero
  2. Enter or lookup a location


  1. Click the Inventory tab
  2. Right click in the filter area and choose customize from the drop-down menu


  1. Click the line


  1. Click the filter by field and choose Qty on hand from the drop-down


  1. Click the filter operator and choose Less than


  1. Right-click in the filters area and choose Simplify from the drop-down menu


  1. Enter a zero in the Qty on hand less than field



NOTE: You can apply other filters to this report by using the item tab to limit your results to things in a certain category or from a certain primary vendor.

  1. Click Preview

Recent Posts