cancel
Showing results for 
Search instead for 
Did you mean: 
TH-GFL
Level 2

Quantity on Hand Consitency Issues

Hello Everyone,

 

I am having an issue where our Item List inventory isn't matching the QuickReport inventory. It's almost as if there are two separate inventories that Quickbooks is tracking. Please see the two attached screenshots for reference.

 

I am using Quickbooks Enterprise 2019 Release R13P. What's happening is a customer will order a product and our item list inventory will show 0 for the Quantity on Hand. I will create a Build Assembly to make inventory and it will correctly record that number. You can see this in my first reference screenshot, where I built 3 of an item since we had 3 on a sales order. When I then go to invoice the order, I receive the "Negative on Hand Detected" warning shown in the screenshot. I forgot to expand the last 3 columns before I took the screen shot, they are(from left to right) Quantity on Invoice, On Hand, and On Hand After Invoice. So this window is telling me that we actually only have 2 on hand, not 3, even though the "Item List" and the "Build Assembly" window both tell me we have 3 on hand.

QB-SC1.jpg

 

In the item list window, I right click the item and choose "QuickReport". This QuickReport shows the 2 On Hand value that the invoice is seeing when it won't let me make a negative invoice. The weird part is that the Item List still says 3 on hand. In my second screenshot, I show this, with a different item. The Item List says I have 9616.52 MSI on hand for the Fluorescent Red Roll. I right click this item, choose "QuickReport" and it tells me the Quantity on Hand is only 5.47 MSI. 

 

QB-SC2.jpg

 

This is causing issues in many areas since some parts of Quickbooks reference the Item List inventory and others reference this other inventory that shows up in the QuickReports. I cannot find any solutions online. I tried reconciling it with an inventory adjust, but any adjustments I make will affect both inventories. So If I wanted to add 9,611 MSI to the Fluorescent Red Roll that has 5.47 MSI in the second screenshot to bring it up to the QoH shown in the item list, Quickbooks will also add that to the 9616.52 MSI one in the item list so they will forever be about 9,611 apart. I haven't found a way to only change one of the inventories.

 

Another employee has been deleting very old transactions recently to try and help condense the file. My money is on it being something to do with that. Our file won't condense on it's own with the "Condense" feature and he said that this release of Quickbooks has a new feature that allows you to lop off very old fiscal years. I'm not exactly sure what the feature is. He has been rebuilding and verifying the build after every time he does it and it rebuilds successfully. I would think if there was a large inventory error it wouldn't rebuild.

 

Any comments or solutions are greatly appreciated. Thanks!

 

12 Comments 12
Jessica_young
Moderator

Quantity on Hand Consitency Issues

Hello there @TH-GFL, thanks for reaching out to the Community!
I am happy to look at some reasons why you may be seeing these discrepancies. Some possible reasons we may be seeing this:

  • Non-posting transactions are listed on the QuickReport.
  • Transactions include different units of measure.

Note: if you are using different units of measure, there is no workaround at this time. The item QuickReport is displaying the quantity from the transactions without converting it to the base unit. Intuit is aware of this issue and is working on a resolution. Here are some steps we can use to work around this limitation:

  1. Open the Inventory report without making any modifications to it.
  2. Ensure the dates on the report are set to All.
  3. If the issue persists, from the item QuickReport, click Modify Report.
  4. Click the Filters tab.
  5. From the Filters window, scroll to Posting Status, click the posting radio button.

All pending invoices will be removed from the QuickReport, and the quantity on hand value will match the item’s quantity on hand on the items list. Let me know if you have questions on this, or if this does not work so we can explore other options. Take care!

TH-GFL
Level 2

Quantity on Hand Consitency Issues

Hello @Jessica_young  ,

 

Thank you for the reply. I tried this out on a few items and it did not produce matching inventories. I will list the results I received to see if that can clue you or anyone else in to what is happening:

 

Item A

QoH is 1.5 on the Item List

QoH is (1) on the standard QuickReport

QoH is 0 when Non-Posting radio button is selected

QoH is (1) when Posting radio button is selected

 

Item B

QoH is 12 on the Item List

QoH is 2 on the standard QuickReport

QoH is 0 when Non-Posting radio button is selected

QoH is 2 when Posting radio button is selected

 

Item C

QoH is 101 on the Item List

QoH is (89.25) on the standard QuickReport

QoH is (101) when Non-Posting radio button is selected

QoH is 11.75 when Posting radio button is selected

 

*Important note Items A and B currently have no open orders. Item C has an open order for 101. This explains why it has 101 on the Item list and (101) on the Non-Posting because the order hasn't been completed yet. I just don't know where the negative 89.25 and the 11.75 are coming from. When we do complete the and I go to invoice it, I am guessing I will get the negative quantity warning because the invoices seem to look to the standard "QuickReport" inventory and not the Item List inventory.

TH-GFL
Level 2

Quantity on Hand Consitency Issues

Hello @Jessica_young  ,

 

Thank you for the reply. I tried this out on a few items and it did not produce matching inventories. I will list the results I received to see if that can clue you or anyone else in to what is happening:

 

Item A

QoH is 1.5 on the Item List

QoH is (1) on the standard QuickReport

QoH is 0 when Non-Posting radio button is selected

QoH is (1) when Posting radio button is selected

 

Item B

QoH is 12 on the Item List

QoH is 2 on the standard QuickReport

QoH is 0 when Non-Posting radio button is selected

QoH is 2 when Posting radio button is selected

 

Item C

QoH is 101 on the Item List

QoH is (89.25) on the standard QuickReport

QoH is (101) when Non-Posting radio button is selected

QoH is 11.75 when Posting radio button is selected

 

*Important note Items A and B currently have no open orders. Item C has an open order for 101. This explains why it has 101 on the Item list and (101) on the Non-Posting because the order hasn't been completed yet. I just don't know where the negative 89.25 and the 11.75 are coming from. When we do complete the and I go to invoice it, I am guessing I will get the negative quantity warning because the invoices seem to look to the standard "QuickReport" inventory and not the Item List inventory.

MaryLurleenM
Moderator

Quantity on Hand Consitency Issues

Ideally, these reports should match, TH-GFL.

 

There might be data damage that's causing the difference. Let's use the Rebuild Data tool that can resolve minor and common data issues. Here's how:

  1. Go to the File menu, then click Utilities.
  2. Select Rebuild Data.
  3. Click OK, then follow the onscreen steps to save a backup.
  4. 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.
  5. When the tool finishes, select OK.
  6. Go to the File menu. Then hover over Utilities and select Verify Data.
  7. Let the tool check your file for data issues.

If QuickBooks doesn't find any problems, select OK. If QuickBooks finds an issue with your company file, select Rebuild Now.

 

If the same error persists, I recommend contacting our QuickBooks Desktop support. They can check your account and work remotely to see the error you're getting.

  1. Click Help at the top menu and select QuickBooks Desktop Help.
  2. In the Have a Question? window, enter a topic.
  3. Click Contact us.
  4. Hit the Start Messaging button.

I'm also adding these articles you can read more about managing reports in QuickBooks Desktop:

Let me know if there's anything else I can help you with.

Operations_Monkey
Level 3

Quantity on Hand Consitency Issues

I'm here because I'm having the same issue. An item is showing QOH as 15 in the quickreport (I actually 14 on hand), but only 1 in the item list with 7 on a sales order (that I have yet to invoice because the rest of the order is not complete). That means that once I invoice that sales order, I will show -6, when I'll really still have 7 on hand. I went to do an inventory adjustment because I just counted these and thought I had seen that it was really wrong. It's still wrong (again, I have 14 not 15), but when I go to do an inventory adjustment, it shows 1 on hand. None of the transactions are dated in the future, which has caused issues for me in the past, so I have no idea why it is the way it is. The Quickreport numbers add up correctly, but the item list just doesn't show the right number. We've tried running a rebuild but the file crashes when we do so, so I don't have any other options of things to try. I haven't noticed any other items with this issue lately, so I don't know if there is a larger problem or not. I'm about to start a full inventory, so I'm sure I'll find more.

 

I'm running Quickbooks 2020 on Enterprise, and we're upgrading to 2021 next week (for other reasons, not an attempt to fix this issue). We always run 1 version behind to avoid being the beta testers for the newest version, as this has bitten us in the past.

 

TH-GFL, did you ever find a way to fix your issue? Did the rebuild solve it?

 

Thanks!

DivinaMercy_N
Moderator

Quantity on Hand Consitency Issues

Thanks for posting a detailed response about your inventory issue, @Operations_Monkey.

 

Let's dig in and perform some troubleshooting steps to narrow down the cause of the problem. 

 

To start, let's open a sample company in your QuickBooks Desktop (QBDT) and test to see if this will also have quantity on hand issues. Here's how:

 

  1. If you're currently working in your company file, go to the File menu and select Close company. If not, open your QuickBooks Desktop (QBDT) and proceed to step 2.
  2. Then, from the No Company Open window, select the Open a sample file option. 
  3. Select the file you want to access. Once opened, create a sample item with the same on hand quantity (14). 
  4. When finished, create a Sales Order for the sample item and enter 7 in the Ordered column. Click Save & Close when done. 
  5. Next, go back to the Lists menu to check if everything is correct.
  6. Select Item List and highlight the sample item.
  7. Then, click the Reports drop-down arrow and choose QuickReport. 
  8. From there, check if the report's data is the same as what's on the Item List page.

 

You can also perform the steps on other company files to verify if this is only a file issue (file issues can be fixed by verifying and rebuilding the data). If the problem occurs to all other companies and sample files, we may need to repair your QBDT program. Before doing so, please create backup copies first. This is to ensure you have the original information that you can restore in case of accidental data loss or damage. 

 

If all other companies are fine, I highly recommend reaching out to our Technical support team to further guide you in resolving the issue. Once connected, you can also request a screen-sharing session so they can review your set up. 

 

It's also easy to run inventory reports to track the status of your item as well as the transactions linked to them. To get started, simply go to the Reports tab and hover over the Inventory section. From there, choose the report you want to open. 

 

I'm always willing to help you if in case you have any other concerns managing your inventory. Feel free to leave a reply below. Keep safe and have a good day.

Fiat Lux - ASIA
Level 15

Quantity on Hand Consitency Issues

@Operations_Monkey 

How big is your file size? Try running the Condense Data utility to see any difference.

TH-GFL
Level 2

Quantity on Hand Consitency Issues

Good Morning Operations_Monkey, 

 

Unfortunately, I was never able to fix this. We've upgraded to Quickbooks Desktop 22 since my last post and we are still having this issue. Rebuilding never fixed it, that is whenever we could actually get through a rebuild. Like you mention, 9 times out of 10, Quickbooks would crash on us whenever trying a rebuild. We hit a dead-end searching for options and just decided to work around it at the time and are still working around it since we've been busy and shorthanded like many companies at this time.

 

In my opinion, Intuit's biggest issue is tech support. I've never had a situation where I have a QB issue, I contact QB tech support, and they have a solution specific for my issue to give me. It's always a generic response. Any issues that we've had that I was able to fix I either figured out myself or found the solution from a user posting it to this forum or a different website.  The company I work for has not been able to condense our Quickbooks company file we use since before I was employed here, over 8 years now. When attempting, it will either crash out or after 5 hours of verifying and rebuilding, a generic message will come up that says, "Quicbooks was unable to condense this file" and go right back to where I was 5 hours ago. There are never any error codes for anything, so there's no clue as to what is stopping it from condensing. Quickbooks tech support gave the generic steps to try and when those didn't work, they passed me off onto a third-party company that specializes in repairing and rebuilding Quickbooks company files. This company reviewed our file and recommended we start a completely new company file. Even they couldn't tell us WHY our file couldn't condense. Their hourly rate for creating a new company file was obscene so we passed, which lead to the owner of our company attempting to delete very old transactions in order to decrease the file size. This deletion is what I believe caused the double-inventory issue we have now. Sorry for the rant there, I'm a little fired up since I spent almost the entire work day yesterday trying to fix ANOTHER issue that just popped up where one of our 4 users that processes credit cards, can no longer access the credit card screen from "Receive Payments". No error codes or anything, it just sits there and tries to load and eventually after a minute it stops trying to load and stays as a blank white screen. So there's no references or anything for me to go on while trying to solve this. Intuit needs a comprehensive error code system.

 

Good luck with your issue. If you find a solution, please report back here. Thanks!

Fiat Lux - ASIA
Level 15

Quantity on Hand Consitency Issues


@TH-GFL wrote:

they passed me off onto a third-party company that specializes in repairing and rebuilding Quickbooks company files. This company reviewed our file and recommended we start a completely new company file. Even they couldn't tell us WHY our file couldn't condense. Their hourly rate for creating a new company file was obscene so we passed, which lead to the owner of our company attempting to delete very old transactions in order to decrease the file size. 

 

@TH-GFL 

Can you share the name of the 3rrd party company you mentioned?

TH-GFL
Level 2

Quantity on Hand Consitency Issues

Sure. It was Out of the Box Technology, www.outoftheboxtechnology.com . Just to be clear, we had no complaints about this company. They were very professional and timely, it's just their rate was a little too much for our small company since our company file was still working mostly fine, and still is. I don't blame them for the high hourly rate. With how much of a tangled mess Quickbooks is, it must be a difficult job.

Fiat Lux - ASIA
Level 15

Quantity on Hand Consitency Issues

@TH-GFL 

Afaik, their service focuses on data conversion, not condensing or repairing files. You may consider sending us your file and we will review it to give you our opinion. Contact us in private and we can share our starting fee for file condensation for your consideration before sending us the file. Most of the time, if your Total Target is smaller than 350K but you can't condense it, it's most likely that your file is corrupted. What you need to buy is a file repair service or file improvement service.

Operations_Monkey
Level 3

Quantity on Hand Consitency Issues

I'm sad to hear you never fixed your issue either. I swear we are the same person, I could have written everything you just wrote. Quickbooks tech support is TERRIBLE, which is why I came here to see if there's a solution other than a rebuild, or a workaround that you've found. This community is so much more helpful than Quickbooks tech support, so I was hoping to maybe find an answer here. I'll try a few things on my own and report back here if there's anything you may find helpful. Best of luck on your Quickbooks journey, and I hope we can find some solutions to share!

Need to get in touch?

Contact us