Skip to main content
O
opticsports
March 1, 2023
Question

My Quantity on purchase order shows a negative value.

  • March 1, 2023
  • 1 reply
  • 0 views
Original commenter did not share additional details

    1 reply

    R
    RCV
    March 2, 2023

    Let me share some information about the negative quantity value on your purchase order, opticsports.

     

    You keep a certain number of products in stock to sell to customers. The quantity on hand is the amount of stock that is currently available. When a product is sold out, the quantity on hand is zero. Negative inventory occurs when the quantity on hand is less than zero. Here are some causes of negative inventory:

     

    • The quantity you received from your vendor did not correspond to the purchase order in QuickBooks. This can result in an incorrect count.
    • Your purchase orders were not converted to bills. After you create a bill, QuickBooks only counts items as inventory.
    • You sell more products than you actually had.
    • You didn't enter all of your purchase orders into QuickBooks.
    • Because you undercounted your physical inventory, the quantity in QuickBooks is incorrect.

     

    To resolve this, we'll need to examine your current inventory's quantity on hand. If you have a negative inventory for a product, the QTY column will show a negative amount. Take note of how much you potentially oversold. Here's how:

     

    1. Go to Business overview then Reports, or go to Reports.
    2. Search for and open an Inventory Valuation Detail report.
    3. From the Report period dropdown, choose All Dates.
    4. Tap Run report.

     

    If you only want to see the products you're running out of, follow the guide below:

     

    1. Go to Get paid & pay or Sales,
    2. Choose Products and services.
    3. Select Out of Stock at the top of the list. Tap Low Stock to see what's low.

     

    For other troubleshooting solutions, check out this article: Fix negative inventory issues in QuickBooks Online. I've also added this article for more information about purchase orders: Create and send purchase orders in QuickBooks Online.

     

    Keep your post coming if you have any other questions about purchase orders and inventory. I'll be right here to help. Have a good one!

    L
    lindzee
    March 7, 2023

    We create a purchase order for 400 potatoes.  Inventory is not received yet. however purchase order is saved. 

    We pre-sell 200 potatoes before potatoes are actually received. (this is how the speed of produce business works) 

    now the QTW on Purchase order column will show zero instead of the 400 it should display.  

    Quantity on hand correctly shows -200 because we have sold part of the pending shipment. 

    When purchase order is copied to bill the quantity on purchase order will show a negative number. 

     

    This worked perfectly up to February 24th 2023.  We have been preselling for 5 years with the correct Purchase Order quantity correct. 

    F
    FateCandylaneT
    March 7, 2023

    Thanks for bringing this to our attention, lindzee.

     

    As I've checked my resources here, I've seen similar cases and confirmed an ongoing investigation relating to your issue. I see how relevant this would be for you and other users to correct the quantity on purchase orders. Rest assured that the team has begun the initial analysis and is working diligently in getting this resolved for you.

     

    In the meantime, I'd recommend contacting our Customer Care Team to ensure you're added to the list of affected users and assist you with further procedures.

     

    Moreover, you can check out this article to guide you with some troubleshooting details: Fix negative inventory issues in QuickBooks Online.

     

    We'll always be here, willing to assist you further if you have additional questions with other QuickBooks concerns. Keep safe and have a good one!

    Terms & ConditionsAccessibility statement