Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
MargaDLS
May 18, 2020
Solved

Quantity on Purchase Orders incorrect

  • May 18, 2020
  • 1 reply
  • 12 views

Hello,

 

I recently switched from Sage50 to QuickBooks Premier Desktop and have been adjusting the inventory. I already changed the inventory on hand to match what we have in the warehouse and closed any open purchase orders that were already received. However, when I run a report on our inventory stock status, all the products I have ever bought have that full amount as "On PO".

For example, a few days ago I ordered 35 of an item. Yet On PO shows I have 2,000 on purchase orders, which is not true. Others have 9,000, etc. I believe the system is using purchase order data from as far back as 2017, even though those purchase orders are all marked as Closed.

 

How can I change the PO quantity of products in order to reflect the correct amount?

 

Thank you!

Best answer by Charies_M

I'm glad to have you here, MargaDLS.

 

If you have run the Inventory Item QuickReport in QuickBooks Desktop, the On Purchase Order section shows all the open Purchase Orders (PO's) for a specific date.

 

I've attached a sample screenshot so you'll know what I'm referring to:

In your case, since it's showing PO's that were marked as closed, then it can be a sign of a damaged data.

 

To fix this, we can run a Verify and Rebuild Utility Tool to your company file. This helps repair any data damage in the system. Below are the steps on how to do this:

 

  1. From the File menu.
  2. Click on Utilities.
  3. Select Rebuild Data/ Verify Data.

 

Let me share this guide on how to adjust an inventory quantity in QuickBooks Desktop: Adjust your inventory quantity or value in QuickBooks Desktop.

 

I'm always here whenever you need help or if you have follow-up questions. Stay safe and enjoy the rest of the day!

1 reply

C
Charies_MAnswer
Level 9
May 18, 2020

I'm glad to have you here, MargaDLS.

 

If you have run the Inventory Item QuickReport in QuickBooks Desktop, the On Purchase Order section shows all the open Purchase Orders (PO's) for a specific date.

 

I've attached a sample screenshot so you'll know what I'm referring to:

In your case, since it's showing PO's that were marked as closed, then it can be a sign of a damaged data.

 

To fix this, we can run a Verify and Rebuild Utility Tool to your company file. This helps repair any data damage in the system. Below are the steps on how to do this:

 

  1. From the File menu.
  2. Click on Utilities.
  3. Select Rebuild Data/ Verify Data.

 

Let me share this guide on how to adjust an inventory quantity in QuickBooks Desktop: Adjust your inventory quantity or value in QuickBooks Desktop.

 

I'm always here whenever you need help or if you have follow-up questions. Stay safe and enjoy the rest of the day!

    A
    aperez2
    August 12, 2022

    How do correct the "on orde" count in QB's online?

    A
    aperez2
    August 12, 2022

    Hi, @aperez2.

     

    Thanks for getting back to us and sharing the details of your concern. Allow me to chime in and help fix the issue you're having with SKUs in QuickBooks Desktop (QBDT).

     

    We haven't received any reports similar to what you're having. Since the Open PO reports shows the correct on order count, there may be a possible damage in your data.

     

    Let's isolate this by running the built-in Rebuild and Verify tools. This automatically fixes minor company file data issues.

     

    Here's how to do it:

     

    1. In QBDT, go to the File menu, then hover over Utilities and select Rebuild Data.
    2. On the QuickBooks Information window, select OK. Follow the onscreen steps to save a backup.
    3. Let the tool repair your file. It may take some time. QuickBooks may seem stuck, but as long as you can move your mouse, the tool is working.
    4. When the tool finishes, select OK.
    5. Go to the File menu. Then hover over Utilities and select Verify Data.
    6. Let the tool check your file for data issues.

     

    If QuickBooks doesn't find any problems, select OK. You can keep using your company file. You don't have any data damage. If it finds an issue, select Rebuild Now.

     

    If the same thing happens, check out this article and proceed to Solutions 2 - 4 for more troubleshooting steps: Fix data damage on your QuickBooks Desktop company file.

     

    In case you need it, I'll add these articles that tackle managing PO and adjusting quantity or total value of your products in QBDT for more information:

     

     

    I also recommend visiting our website for more tips and other resources you can use in the future: Self-help articles.

     

    Please post again or leave a comment in this thread if you have follow-up questions about this or anything else QuickBooks. I'm more than willing to help. Take care always.


    Apologies for not making myself clear. I am working on QuickBooks intuit, not a QBDT.

     

    AP

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement