Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello QBO Community,
I am working on a cleanup for a service business that has no inventory. However, the system has recorded their inventory on hand as +$7M. When I attempt an inventory adjustment to set 1/1/22 inventory on hand to $0.00, I get an error saying:
"The inventory transaction cannot be complete because it requires allocating more than 2000 FIFO acquisition (purchase) lots to a single distribution (sale.)"
What approach should I take instead to remove the erroneous inventory on hand? THANK YOU! Screenshot attached.
Much appreciated!
-Shannon
Solved! Go to Solution.
Thank you all for your help!
I was able to develop a solution.
The Inventory Adjustment was too big to use the regular inventory adjustment workflow, so I did eight $0.00 invoices with quantity of $1M units each (the last one had the difference remaining, not a full $1M.)
Screenshot attached for anyone in the future who encounters this issue.
I love to help you, Shannon.
In QuickBooks Online, you can adjust an item's quantity without recording a purchase or sale to match what you actually have in stock. To ensure that I'll be able to provide you with the most accurate solution, can you provide the screenshot of the error and recorded inventory? It seems that they weren't attached to your original post.
Looking forward to your reply. Have a great rest of the day.
Thank you for your help! I have been on the phone with Intuit Support and they've directed me to Tier 3 Support, but I welcome your help also!
Screenshot attached. The crux of the issue is that QBO limits how many FICO units can be used in an inventory adjustment and this particular false inventory has been accruing since 2013.
Thanks for adding the screenshot, Shannon in Colorado.
The error you encountered usually occurs when you attempt to create an adjustment for a company that has no inventory. Since the program requires a particular number of FIFO units for a single sale, you may need to contact our technical support. This way, we'll be able to pull up your account and perform the adjustment for you. here's how to connect with us:
Keep me posted if you have any other concerns or follow-up questions about inventory. Take care and have a good one.
Thank you so much! Will contact tech support and will post updates here.
Are there actual inventory products in QBO that need to be removed or is that $7M balance just recorded as inventory on the balance sheet with no products in QBO? If there are no products, this can be easily handled with a journal entry. The bigger question is: has this business been recording purchases as inventory when they should have been recording them as expenses? I can't imagine they under-reported their expenses by $7M over the past 10 years but, if that's the case, you need a CPA/tax accountant to help reconcile this.
Thank you all for your help!
I was able to develop a solution.
The Inventory Adjustment was too big to use the regular inventory adjustment workflow, so I did eight $0.00 invoices with quantity of $1M units each (the last one had the difference remaining, not a full $1M.)
Screenshot attached for anyone in the future who encounters this issue.
Thanks for your help! It's a service business with no actual inventory that has been accruing inventory via a inventory item on invoices called "project costs" that should have been a non-inventory item. The $7.9M adjustment was too big for QBO to handle at once, so I broke it out into eight $0 invoices. Included a screenshot of my solve in another post on the thread.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here