The Negative inventory report lists items in your inventory that currently have negative quantity on hand (QOH) with associated negative inventory adjustment reasons. You can periodically run the report and analyze the data to:
- Identify reasons why items have negative inventory
- Correct the negative quantity on hand of items
- Maintain the most accurate inventory possible
Filtering the Negative inventory report
At the top of the Negative inventory report, you can adjust the filters to refine the results.
- Item Search: Enter an item's searchable details to filter the report by Description, System ID, SKU, and more.
- to: Select a date or date range to only show negative inventory adjustments that occurred during the timeframe.
- Show eCom Orders: Check the box to show items with negative inventory due to eCom (C-Series) backorders. In the eCom Order column, in-store results will show No and eCom orders will show Yes.
- Shop: If you have multiple locations, you can choose to filter by specific location.
- Default Vendor: Filter items by their primary vendor.
- Reason: Filter items by cause of negative inventory: Sale (includes in-store and online), Returned to vendor, or Removed for transfer.
- Results: Adjust the amount of search results per page of the report by clicking # Per Page, entering the number of results to display per page (max 100), and clicking OK.
Understanding columns in the Negative inventory report
Each column in the report contains data that can help you identify why an item has negative inventory. Information in blue is clickable, allowing you to navigate to related areas in Retail POS for more information.
- ID: Unique identifier of each negative inventory adjustment.
- Item: Description of the item with negative inventory. Click to view the item details page.
- QOH: Current quantity on hand of the item. Click to view the item inventory page.
- Inventory Adjustment Reason: Cause of negative inventory: Sale, Returned to vendor, or Removed for transfer.
- Source: Specific sale, transfer, or vendor return that caused the item to have negative inventory. Click to view the details.
- Qty Removed: Amount of stock removed from the item's QOH due to insufficient stock when it was sold, transferred, or returned to the vendor.
- Unit Cost: Cost at which the quantity was removed, determined by the Cost Control setting. Inventory - Product Cost permissions are needed to view this column.
- Employee: Employee who processed the sale, sent the transfer, or sent the vendor return that caused the item to have negative inventory. If the sale was processed online and is an eCom back order, the employee will be eCom.
- Date/Time: Date and time the quantity was removed from the item's QOH.
- Shop: Location affected by the item's negative inventory adjustment.
- Incoming on PO: Total order quantity on all purchase orders with Open, Ordered, or Check-in status for the item and location. Click to view the purchase order page.
- Incoming on Transfer: Total in-transit quantity on all transfers with Sent or Received status for the item and location. Click to view the item's transfer page.
- eCom Order: No for in-store sales, Yes for online sales.
Printing the Negative inventory report
You can also print or export the report. At the top-right of your search results:
- Click Print to print the current page of the search results.
- Click Export to download the report's data as a CSV file.