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

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

We've found an issue when receiving items where the item receipt is saying we're trying to receive more items that were ordered / open on the PO.

Example: We have a PO with 12pc on it. We received 11pc previously, leaving 1pc remaining to be received. When we go to receive that 1pc, the system says we're trying to receive more than we ordered. When we look at the open PO, it shows that the item was received in full (12pc) and that item is closed. When I look for item receipts to equal that, I can only find a record of the 11pc receipt. The inventory-on-hand quantity is 11pcs. It's just the PO that shows as recieved in full, which blocks us being able to receive the final 1pc on the second item receipt. I'm assuming it's a date-driven issue, possible related to the way / time the bill was entered, but I can't seem to find the issue. 

We're running Quickbooks Desktop Enterprise and have advanced receiving turned on. 

12 Comments 12
JessT
Moderator

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

Hi Huzzy76,

 

Thank you for explaining your concern in detail. Normally, the PO would remain open because you only received 11 pcs out of 12. The receipt date won't matter as well in this case.

 

You can run the Verify and Rebuild data utilities to check if you're having data issues and to fix them. If the same thing happens, please contact our Enterprise Support to check this further. They can use a screen-sharing tool to see your setup.

  1. Open QuickBooks.
  2. Go to Help, then select QuickBooks Desktop Help.
  3. Select Contact Us.
  4. Give a brief description of your issue, then select Let's talk and then choose a way to connect.

Feel free to reach back out if you have other concerns. Have a good one!

Huzzy76
Level 2

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

HI - Thanks for the reply. TO be clear, the PO is not open for that line item. The line item is closed because the PO thinks we received 12pc, when in-fact it was only 11pcs received. When we tried to received the final 1pc, the item receipt pop-up warning window said "you are trying to receive more items that you ordered", which is not true. We've run reports to check to see if there was another receipt at some point for the 1pc, but there is not. Our inventory is accurate, but the PO shows the fill 12pc were received. 

MJoy_D
Moderator

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

Thank you for getting back to us and letting us know more about this concern, @Huzzy76.

 

If you're still encountering this error after running the Verify and rebuild tools, then I suggest reaching our to our Customer Support team. Their tools can get into your account in a secure environment, identify the cause of this issue and help you resolve it. 

 

You can follow the steps below on how to reach them:

  1. From your QuickBooks Desktop account, click the Help menu at the top.  
  2. Click the QuickBooks Desktop Help menu and select QuickBooks Desktop Help.
  3. Provide some information about this concern on the search box.
  4. Click the Contact Us link at the bottom of the window. 
  5. You'll now be provided with a few support options.  

Here's the contact QuickBooks Desktop support article for more information about this.

 

See this article for more information on how to create purchase orders in QuickBooks Desktop and on how to to receive inventory with or without a bill in QuickBooks Desktop.

 

I'm always here if you need more help with your transaction. Just let me know in the Reply section below. Take care and have a great rest of the day!

Poshnosh
Level 1

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

Exactly the same issue . Was concerned that this was a data corruption issue but now seems this is a glitch with the software.

kminb
Level 1

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

Where you ever able to get this issue figured out. We are experiencing a similar issue in which we have a PO for 60 items, we received 15 on an Item Receipt but the PO showed that we have received 30 instead of 45 as it should. It is almost as if it is doubling/duplicating the item receipt without an actual transaction. 

Jen_D
Moderator

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

Thanks for joining this thread and letting us know you're having the same problem with receiving items, @kminb.

 

I understand that having issues like this can be time consuming and cumbersome. For this, I want to make sure we look into this.

 

Regarding this problem, can you please confirm if you run the program as administrator? Also, have you tried this process in a sample file? We need to verify if there's something wrong with the company file or the software itself.

 

To open a sample company file to receive items:

 

  1. You will see the No Company Open window.
  2. Select the drop down arrow beside Open a sample file.
  3. Choose Sample product-based business.

 

If the sample file doesn't show any issues like the actual company file, try running the Verify/Rebuild Utility. Here's how to do that in QuickBooks:

 

  1. Go to the File menu then Utilities.
  2. Select Verify Data then wait until the diagnosis is done.
  3. If there are issues, proceed to rebuilding the company file.
  4. Tap File menu and Utilities again.
  5. Use Rebuild Data this time then click OK.
  6. Follow the onscreen steps to save a backup.

 

However, if the problem also happens in the sample file or after verifying and rebuilding the file, proceed to repairing the software. This fixes program issues in QuickBooks. To do that, follow the steps below:

 

  1. Create a backup copy of the company file beforehand, to avoid any accidental data loss.
  2. Reboot the computer and tap the Windows Start menu.
  3. Find Control Panel on the search field or select it from the list.
  4. Press Programs and Features then Uninstall a Program. Note: If you don't see Programs and Features, select Programs instead. Then select Program and Features.
  5. Pick QuickBooks from the list of Programs, then press Uninstall/Change.
  6. Click on Continue, or Next. then Repair.
  7. Press Next again then wait for the tool to start its diagnosis.
  8. Tap Finish when done.

 

To learn more about repairing QuickBooks and its complete steps, go to this link: Repair your QuickBooks Desktop for Windows.

 

After that, try to receive the items as usual. Still making sure you run the program as administrator. 

 

If the issue persists after doing the suggestions, I recommend that you continue working with our Technical Support Team to get this reported. They have the tools necessary to check your company file and help you resolve this issue. To get our support, follow the steps below:

 

  1. Open QuickBooks and click the Help menu.
  2. Select QuickBooks Desktop Help.
  3. On the pop-up screen select Contact us.
  4. Click the Search for Something else button then type your concern in the Ask us anything box.
  5. Hit Search then scroll down to get your contact options.

 

Refer to this article to learn more about our contact options and support availability: Contact QuickBooks Desktop support

 

Kindly update me on the results in the comment. I want to ensure everything is working well for you, and I'm here to provide further assistance and insights. Have a great day!

Carolyn201
Level 1

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

Were you able to get this issue solved?

We have tried deleting the item receipt and receiving again but it does the same duplication on the Purchase Order and closes it even though it was not all received.

ReymondO
QuickBooks Team

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

Thanks for joining the thread, @Carolyn201.

 

I appreciate the steps you've made to get this resolved. 

 

Since you're still getting a similar result, I'd recommend following the suggested steps above. Let's start by updating QuickBooks Desktop to its latest release. This will help us refresh the program and will keep the software up to date. Here's how:

 

  1. Go to Help and select Update QuickBooks Desktop.
  2. Click Update NowTip: You can select the Reset Update checkbox to clear all previous update downloads.
  3. Select Get Updates to start the download.
  4. When the download finishes, restart QuickBooks.
  5. Once prompted, accept the option to install the new release.

 

When you're done, create again another item receipt and check if the error is gone. 

 

If you're still getting the same result, let's run the Verify and Rebuild Data utility tools. This can help us identify the cause of the problem and fix it by rebuilding your data. 

 

If the issue persists, let's repair QuickBooks using QuickBooks Tools Hub. It contains a set of tools that we can use to fix common errors in the program. 

 

Purchase orders are a part of the Accounts Payable (A/P) workflow. To know more about it, you can see this article: A/P workflow in QuickBooks Desktop.

 

Please let me know the result of your troubleshooting. I want to make sure you're able to complete your task in QuickBooks. Have a good one. 

kminb
Level 1

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

We performed a verify and rebuild of the company file until it showed no errors found, however it did not end up resolving the issue we were having. We ended up just going in and manually changing the numbers to reflect the correct amounts and moved on. Fortunately it has not happened again so I attributed to a user error somewhere in our internal process. 

 

We did not delete the PO we simply just input the correct numbers on the PO that were also reflected on the Item Receipt and it seemed to correct the issue and not effect the inventory numbers.  

Carolyn201
Level 1

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

We did two rebuilds last night until there were no more errors.  It fixed some other issues, but not the one with this particular purchase order.  This has happened to us in the past and deleting the item receipt has worked.

 

It is not having an impact on inventory values or quantities thankfully. It only impacts the non-posting transaction of the Purchase Order, but the guys in the warehouse can't receive against the PO.  

 

 

Teedit
Level 2

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

I'm having the same issue. I am trying to go back into the item receipt once i physically received the item and add a line with a different lot number. When I try to change the item receipt amount, I get the same error everyone else is complaining about. Even if I put the qty to 1ea, I get the error. Definately a bug!

GlinetteC
Moderator

Item Receipt issues: Item receipt is stating that quantity is greater than the open quantity in a PO

I know it isn't easy encountering issues when doing a task in QuickBooks, Teedit.

 

Have you tried the troubleshooting steps provided in the previous replies? If you do, but the issue continues, I recommend contacting our QuickBooks Support Team. This way, they can further investigate this matter and provide additional troubleshooting steps on how to get rid of the error. They can also create an investigation ticket if other users encountered the same issue. 

 

To reach them, please follow the steps below:

 

  1. Go to the Help icon and select QuickBooks Desktop Help.
  2. Click Contact Us.
  3. Write your concerns in the description box, then select Continue.
  4. Select which one of the support options you'd like to use.

 

I've added this article for another way of reaching out to our support team and its support hours: QuickBooks Desktop Support.

 

Also, you can bookmark our Expenses and Vendors Community page to learn more about managing expense records and suppliers.

 

The Community is open to help you again if you have follow-up questions about item receipt and PO or other questions.

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

Need to get in touch?

Contact us