--- title: Finding Products with Negative on Hand Quantity. description: Since Acctivate allows users to sell into the negative, occasionally it may be necessary to review your inventory to locate products that have a negative quantity on hand and correct them by making adjustments. --- [Skip to content](https://hub.acctivate.com/articles/finding-and-adjusting-products-with-negative-on-hand-quantity#main-content) [Go to Customer Portal](https://hub.acctivate.com/tickets?hsLang=en) ![Acctivate - A CAI Solution](https://hub.acctivate.com/hubfs/Images/Logos/acctivate-cai-logo-svg.svg) - [Knowledge Base](https://hub.acctivate.com/articles) Open main navigation Close main navigation - [Knowledge Base](https://hub.acctivate.com/articles) - [Go to Customer Portal](https://hub.acctivate.com/tickets) - [Support Resources / Create Ticket](https://acctivate.com/support) [Support Resources / Create Ticket](https://acctivate.com/support) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://hub.acctivate.com/articles?hsLang=en) 2. [Inventory](https://hub.acctivate.com/articles/inventory?hsLang=en) 3. [Inventory Manager](https://hub.acctivate.com/articles/inventory?hsLang=en#inventory-manager) April 11, 2025 # Finding Products with Negative on Hand Quantity. ## Since Acctivate allows users to sell into the negative, occasionally it may be necessary to review your inventory to locate products that have a negative quantity on hand and correct them by making adjustments. ### Finding and Adjusting Products with Negative On Hand Quantity Since Acctivate allows users to sell into the negative, occasionally it may be necessary to review your inventory to locate products that have a negative quantity on hand and correct them by making adjustments. This article will discuss how to use Acctivate reports and the Business Alerts feature to locate any products that have a negative on hand quantity, as well as how to make an adjustment to bring the quantity out of the negative. #### **Finding Products Sold into the Negative** There are two different methods in which users can locate products in Acctivate with a negative on hand quantity. Users can run a report to find a printable list of products, or use the Business Alerts Reorders feature to quickly gather and sort this list. Both methods will be discussed below. #### **Option 1: Reporting** The **Stock on Hand Report** can be configured to add a “QtyOnHand” field as a selection prompt, which can then be used as a filter (where QtyOnHand is less than zero). To set up this new selection prompt on the Stock on Hand report: 1. For version 12.1 and later, you'll need to go to **File \> Manage Reports** then locate the **Stock on Hand** report in the Warehouse folder under Inventory. Click the **Edit** button near the top left corner of the window. 1. For Version 12.0 and lower, go to **File \> Configuration Management \> Reports \> Report Catalog**, then locate the **Stock on Hand** report in the Warehouse folder under Inventory. Click the **Edit** button near the top left corner of the window. ![](https://help.acctivate.com/wp-content/uploads/Stock-On-Hand.jpg) 2. Click on the **Selection Prompts** tab on the right side of the Report Catalog window. You should see the three default selection prompts: Product ID, Warehouse, and Product Class. Click the **browse button \[…\]** to open the list of available selection prompts for this report. ![](https://help.acctivate.com/wp-content/uploads/QtyOnHand.jpg) 3. A new window will appear with a list of three data views: Product, ProductClass, and ProductWarehouseSummary. Under **ProductWarehouseSummary**, scroll down to the **QtyOnHand** field and click the **Select** button after highlighting the field. **Save** the changes made to the Report Catalog, then close the Configuration Management window. 4. Now you can pull up the Stock on Hand report using the new QtyOnHand filter. To do this, go to Inventory \> Inventory Reports \> Warehouse \> Stock on Hand. In the Report Selection Criteria window, select the **Less Than** filter for the new **QtyOnHand** field added above, the click **Preview. ![](https://help.acctivate.com/wp-content/uploads/QtyOnHand-Selection-Criteria.jpg)** The above report will return a full list of products in all warehouses that have a negative on hand quantity. #### **Option 2: Business Alerts – Reorders** Another way to quickly determine which products have a negative on hand quantity is to use the Business Alerts feature. In the Business Alerts window, the Reorders tab will display information about current stock levels, costs and vendor information. To display this window: 1. Go to **Alerts** \> **Business Alerts** in the Acctivate menu at the top of the screen, or click the **Alerts** button on the toolbar. 2. In the Business Alerts window, click on the **Reorders** tab. You will see several fields in this tab, all of which can be customized by changing the column order and sorting the data. 3. To quickly return a list of products with negative on hand quantities, click and drag the **On Hand** column and place it closer to the **Product ID** column. ![](https://help.acctivate.com/wp-content/uploads/Reordertab.jpg) 4. Once you have moved the On Hand quantity column, click on the column name to sort your product list by ascending on hand quantity. After sorting this field, any products with a negative on hand quantity will appear at the top of the list, along with other useful information about the warehouse, suggested quantity, how many are currently ordered, and suggested cost based on previous transactions. ![](https://help.acctivate.com/wp-content/uploads/Sort-by-On-Hand.jpg) #### Using Adjustment Transactions to Correct Negative On Hand Quantities Once you have returned a list of products with negative on hand quantities, you may want to post an adjustment to set the quantity back to 0. This can be accomplished using the **[Inventory Balance Adjustment](https://help.acctivate.com/articles/3768/)** in Acctivate (See note after Step 3 for regular Inventory Adjustment information). 1. To create a new Inventory Balance Adjustment, go to **Inventory \> Inventory Balance Adjustment**. In the Inventory Balance Adjustment window, **click New** and **select a warehouse.** 2. Add a product with a negative on hand quantity to the Balance Adjustment by entering the product ID or using the product lookup window to search. To set the quantity on hand to 0, enter 0 in the quantity field, then click **Save** and **Post**. ![](https://help.acctivate.com/wp-content/uploads/On-Hand-Balance-Adjustment.jpg) 3. To confirm the adjustment was successful, open the Product window and review the On Hand quantity. If the Balance Adjustment was posted as of today’s date, your On Hand quantity should match the quantity of the adjustment transaction. **Note:** You can also post an inventory adjustment to set the quantity on hand to 0. Instead of assigning the quantity as 0 like in a balance adjustment, you will need to manually add the negative amount to the adjustment. The same transaction above would appear like this in an Inventory Adjustment: [![](https://help.acctivate.com/wp-content/uploads/On-hand-inventory-adjustment.jpg)](https://help.acctivate.com/wp-content/uploads/adjustment.png)Inventory adjustments will use the **Adjustment** General Ledger account for a specific warehouse, while balance adjustments use the **Gain/Loss** General Ledger account for that warehouse. To verify which accounts are assigned, go to **File \> Configuration Management \> Inventory \> Warehouse**. - [Getting Started](https://hub.acctivate.com/articles/getting-started?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/getting-started?hsLang=en#basics) - [User Interface](https://hub.acctivate.com/articles/getting-started?hsLang=en#user-interface) - [Manager windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#manager-windows) - [List windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#list-windows) - [Transaction windows](https://hub.acctivate.com/articles/getting-started?hsLang=en#transaction-windows) - [License and Users](https://hub.acctivate.com/articles/getting-started?hsLang=en#license-and-users) - [Email](https://hub.acctivate.com/articles/getting-started?hsLang=en#email) - [Getting Help](https://hub.acctivate.com/articles/getting-started?hsLang=en#getting-help) - [Installation](https://hub.acctivate.com/articles/installation?hsLang=en#main-content) - [Acctivate](https://hub.acctivate.com/articles/installation?hsLang=en#acctivate) - [Database Server](https://hub.acctivate.com/articles/installation?hsLang=en#database-server) - [Mobile WMS Setup](https://hub.acctivate.com/articles/installation?hsLang=en#mobile-wms-setup) - [Software Updates](https://hub.acctivate.com/articles/installation?hsLang=en#software-updates) - [Email Setup](https://hub.acctivate.com/articles/installation?hsLang=en#email-setup) - [Remote Access](https://hub.acctivate.com/articles/installation?hsLang=en#remote-access) - [Configuration](https://hub.acctivate.com/articles/configuration?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/configuration?hsLang=en#basics) - [Users](https://hub.acctivate.com/articles/configuration?hsLang=en#users) - [Company Info](https://hub.acctivate.com/articles/configuration?hsLang=en#company-info) - [Customers](https://hub.acctivate.com/articles/configuration?hsLang=en#customers) - [Sales Orders](https://hub.acctivate.com/articles/configuration?hsLang=en#sales-orders) - [Inventory](https://hub.acctivate.com/articles/configuration?hsLang=en#inventory) - [Custom Fields](https://hub.acctivate.com/articles/configuration?hsLang=en#custom-fields) - [Email Message Templates](https://hub.acctivate.com/articles/configuration?hsLang=en#email-message-templates) - [Services](https://hub.acctivate.com/articles/configuration?hsLang=en#services) - [Inventory](https://hub.acctivate.com/articles/inventory?hsLang=en#main-content) - [Products](https://hub.acctivate.com/articles/inventory?hsLang=en#products) - [Costing](https://hub.acctivate.com/articles/inventory?hsLang=en#costing) - [Prices and Units](https://hub.acctivate.com/articles/inventory?hsLang=en#prices-and-units) - [Warehouses and Locations](https://hub.acctivate.com/articles/inventory?hsLang=en#warehouses-and-locations) - [Lot Numbers](https://hub.acctivate.com/articles/inventory?hsLang=en#lot-numbers) - [Inventory Manager](https://hub.acctivate.com/articles/inventory?hsLang=en#inventory-manager) - [Receipts](https://hub.acctivate.com/articles/inventory?hsLang=en#receipts) - [Assemblies](https://hub.acctivate.com/articles/inventory?hsLang=en#assemblies) - [Kits and Assortments](https://hub.acctivate.com/articles/inventory?hsLang=en#kits-and-assortments) - [Landed Cost](https://hub.acctivate.com/articles/inventory?hsLang=en#landed-cost) - [Transfers](https://hub.acctivate.com/articles/inventory?hsLang=en#transfers) - [Adjustments](https://hub.acctivate.com/articles/inventory?hsLang=en#adjustments) - [Counts](https://hub.acctivate.com/articles/inventory?hsLang=en#counts) - [Reports](https://hub.acctivate.com/articles/inventory?hsLang=en#reports) - [Purchasing](https://hub.acctivate.com/articles/purchasing?hsLang=en#main-content) - [Purchase Orders](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-orders) - [Purchase Order Manager](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-order-manager) - [Purchase Invoices](https://hub.acctivate.com/articles/purchasing?hsLang=en#purchase-invoices) - [Vendors](https://hub.acctivate.com/articles/purchasing?hsLang=en#vendors) - [Customers](https://hub.acctivate.com/articles/customers?hsLang=en#main-content) - [Customers](https://hub.acctivate.com/articles/customers?hsLang=en#customers) - [Locations](https://hub.acctivate.com/articles/customers?hsLang=en#locations) - [Credit & Terms](https://hub.acctivate.com/articles/customers?hsLang=en#credit-terms) - [Pricing](https://hub.acctivate.com/articles/customers?hsLang=en#pricing) - [Broadcast Email](https://hub.acctivate.com/articles/customers?hsLang=en#broadcast-email) - [Sales](https://hub.acctivate.com/articles/sales?hsLang=en#main-content) - [Orders](https://hub.acctivate.com/articles/sales?hsLang=en#orders) - [Sales Order Manager](https://hub.acctivate.com/articles/sales?hsLang=en#sales-order-manager) - [Picking](https://hub.acctivate.com/articles/sales?hsLang=en#picking) - [Drop Shipments](https://hub.acctivate.com/articles/sales?hsLang=en#drop-shipments) - [Sales Tax](https://hub.acctivate.com/articles/sales?hsLang=en#sales-tax) - [Packaging](https://hub.acctivate.com/articles/sales?hsLang=en#packaging) - [Shipping](https://hub.acctivate.com/articles/sales?hsLang=en#shipping) - [Invoices](https://hub.acctivate.com/articles/sales?hsLang=en#invoices) - [Payments](https://hub.acctivate.com/articles/sales?hsLang=en#payments) - [Credits](https://hub.acctivate.com/articles/sales?hsLang=en#credits) - [Business Activities](https://hub.acctivate.com/articles/business-activities?hsLang=en#main-content) - [Business Activities](https://hub.acctivate.com/articles/business-activities?hsLang=en#business-activities) - [Business Alerts](https://hub.acctivate.com/articles/business-activities?hsLang=en#business-alerts) - [QuickBooks](https://hub.acctivate.com/articles/quickbooks?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/quickbooks?hsLang=en#basics) - [QuickBooks Online](https://hub.acctivate.com/articles/quickbooks?hsLang=en#quickbooks-online) - [QuickBooks Desktop](https://hub.acctivate.com/articles/quickbooks?hsLang=en#quickbooks-desktop) - [Mobile WMS](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#basics) - [Picking](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#picking) - [Receiving](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#receiving) - [Counts](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#counts) - [Assemblies](https://hub.acctivate.com/articles/mobile-wms?hsLang=en#assemblies) - [Web Store Integrations](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#basics) - [Templates and Options](https://hub.acctivate.com/articles/web-store-integrations?hsLang=en#templates-and-options) - [EDI](https://hub.acctivate.com/articles/edi?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/edi?hsLang=en#basics) - [Orders - 850](https://hub.acctivate.com/articles/edi?hsLang=en#orders-850) - [Shipments - 856](https://hub.acctivate.com/articles/edi?hsLang=en#shipments-856) - [Invoices - 810](https://hub.acctivate.com/articles/edi?hsLang=en#invoices-810) - [Warehouse - 940/945](https://hub.acctivate.com/articles/edi?hsLang=en#warehouse-940-945) - [Reports](https://hub.acctivate.com/articles/reports?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/reports?hsLang=en#basics) - [Standard Reports](https://hub.acctivate.com/articles/reports?hsLang=en#standard-reports) - [Crystal Reports](https://hub.acctivate.com/articles/reports?hsLang=en#crystal-reports) - [Excel](https://hub.acctivate.com/articles/reports?hsLang=en#excel) - [Database](https://hub.acctivate.com/articles/database?hsLang=en#main-content) - [Basics](https://hub.acctivate.com/articles/database?hsLang=en#basics) - [Backup & Restore](https://hub.acctivate.com/articles/database?hsLang=en#backup-restore) - [Microsoft SQL Server](https://hub.acctivate.com/articles/database?hsLang=en#microsoft-sql-server) - [Imports](https://hub.acctivate.com/articles/database?hsLang=en#imports) - [Troubleshoot](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#main-content) - [General](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#general) - [Installation](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#installation) - [Inventory](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#inventory) - [Purchasing](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#purchasing) - [Sales](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#sales) - [Shipping](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#shipping) - [QuickBooks Desktop](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#quickbooks-desktop) - [QuickBooks Online](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#quickbooks-online) - [Mobile WMS](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#mobile-wms) - [Web Store Integration](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#web-store-integration) - [EDI](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#edi) - [Reports](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#reports) - [Database](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#database) - [Imports](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#imports) - [Email](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#email) - [Integrations](https://hub.acctivate.com/articles/troubleshoot?hsLang=en#integrations) [![Acctivate Inventory Software](https://hub.acctivate.com/hubfs/Images/Logos/acctivate-cai-logo-svg.svg "Acctivate Inventory Software")](https://acctivate.com) Acctivate Knowledge Base [mailto:support@acctivate.com](mailto:support@acctivate.com) Copyright © 2025, Alterity, LLC