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

My Quantity on purchase order shows a negative value.

 
10 Comments 10
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

JRS22
Level 1

My Quantity on purchase order shows a negative value.

We use POs (non-inventory items only) to track what is delivered to feed animals based on the scale at our location, but we know that we will be billed the point of origin weights.  It would be so helpful to be able to enter adjustment qty positive AND negative on the PO for daily delivery reporting of differences as a separate item/line since it may take weeks even months to be billed and the billing is done from point of origin.  This difference cannot be run from the bill date it has to be run off the PO date.  I know this thread is old but we are using a current version of Enterprise.

 

Jennifer

Irene R
QuickBooks Team

My Quantity on purchase order shows a negative value.

I appreciate you joining this thread with your Quantity adjustment concern in QuickBooks Desktop (QBDT), JRS22.

 

In QuickBooks Desktop, your inventory quantity data depends on the flow of your business, including what you have sold and purchased. However, entering an adjustment quantity with positive and negative in your POS in a separate line item is not possible.

 

I can see how this feature is beneficial in running your business aligning with QuickBooks Desktop, therefore I recommend sending this feature suggestion to our Product Development team. To do so, you can follow the steps provided below:

 

  1. Go to the Help option.
  2. Select the Send Feedback Online option.
  3. Choose the Product Suggestion option. A pop-up window displays.
  4. Type in your feedback suggestion.
  5. Click the Send Feedback button. The feedback is sent.

 

Furthermore, you can refer to these helpful materials in adjusting your quantity in inventory and making a purchase order in QBDT:

 

 

Moreover, you can refer to this article for getting the latest feature information and updates in QuickBooks: What’s new in QuickBooks.

 

Let me know if you have further inquiries about modifying your PO or making quantity adjustments in your inventory in QBDT, JRS22. I’ll be here to assist you at any time.

userinfo18
Level 1

My Quantity on purchase order shows a negative value.

Back on January 31, 2024 - Case#15111785227 was opened.

Issue of negative quantities on purchase orders and how to remove them. NEVER RESOLVED but you closed the case. Now I have to make a bogus purchase order for the negative quantities (zero dollars) and never close out the PO. I just keep adding to it. If I presell, the quantities should balance out once items are received, but they do not. They just keep growing negative numbers. I wonder if this happens with Oracle NetSuite.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us