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:
- From the Launchpad, select Inventory → Reports → Inventory Status Report
- Set Include items if qtys on hand are to Non zero
- Enter or lookup a location
- Click the Inventory tab
- Right click in the filter area and choose customize from the drop-down menu
- Click the line
- Click the filter by field and choose Qty on hand from the drop-down
- Click the filter operator and choose Less than
- Right-click in the filters area and choose Simplify from the drop-down menu
- 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.
- Click Preview