cancel
Showing results for 
Search instead for 
Did you mean: 
opticsports
Level 2

My Quantity on purchase order shows a negative value.

 
7 Comments 7
RCV
QuickBooks Team
QuickBooks Team

My Quantity on purchase order shows a negative value.

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!

lindzee
Level 3

My Quantity on purchase order shows a negative value.

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. 

FateCandylaneT
QuickBooks Team

My Quantity on purchase order shows a negative value.

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!

lindzee
Level 3

My Quantity on purchase order shows a negative value.

I hope this can be escalated for fast resolution.  Not knowing how much inventory is arriving for sale impacts business greatly. 

lindzee
Level 3

My Quantity on purchase order shows a negative value.

YES!  This is exactly what is happening to us as well. We are on QuickBooks Advanced in Canada, however it appears they use the same code base.  It was also after an apparent upgrade at the end of January that this got broken.   We have been preselling since 2017.  Qioclbooks confirms they are working on this  - but urgency does not seem to be there  As our busy agricultural season approaches we stand to lose a lot of sales because of this 

 

lindzee
Level 3

My Quantity on purchase order shows a negative value.

I'v conbtacted the customer care team three times - they confirm it is an issue, however make no estimate on when or how it might be fixed.  It does not seem to be their highest priority. 

lindzee
Level 3

My Quantity on purchase order shows a negative value.

We are now moving into the third month where this is still a very outstanding issue. As we move into the growing season it will become even more severe.  I do not understand why it is so difficult to fix this.  PO Quantity should show the quantity ordered on the PO regardless of any presale.   It worked before - roll back if need be but this must be given a high priority. examples.png

Need to get in touch?

Contact us