Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi -
I have a question about how "Available" is calculated in the "Inventory Stock Status By Item" report.
This appears to be the current formula used in Quickbooks Enterprise:
On Hand - For Assemblies (To Be Built + On Pending Builds) - Sales Order = Available.
I don't think "To Be Built" (which is picked up in the "For Assemblies" column) should be lowering the "Available" quantity.
For example, let's say this is the data.
To keep it simple, we'll assume no Sales Order yet.
On Hand = 100
To Be Built = 35
On Pending Builds = 10
For Assemblies* (To Be Built + On Pending Builds) = 35 + 10 = 45
*This is how it's currently calculated in Quickbooks Enterprise.
Current calculation: 100-45 (To Be Built+On Pending Builds) = 55 Available
I think it should be: 100- 10 (On Pending Builds) = 90 Available
The “To Be Built” should not take away from what we have “Available”.
Once the "To Be Built" are complete, that will boost the On Hand and Available anyway. This is unlike "On Pending Builds", items that are being consumed to make an item.
As you can see, there is a big difference from thinking you have only 55 “Available” when really you have 90 “Available”.
(Just a fyi to anyone following along, to see specific quantities for an item you can go to Inventory – Item List – and then type in and look up an item number. There you can see fields “On Hand”, “To Be Built”, “On Pending Builds”, etc. If you don’t see those fields, just click on the row, right click your mouse, choose “Customize Columns”, then choose the fields you want to see.)
(The attached image has different numbers because it's an actual example.)
My preference settings for "When calculating Quantity Available for my inventory, deduct:" have both of these checked "Quantity reserved for Pending Builds" and "Quantity on Sales Orders." I'm ok with the quantity "On Pending Builds" being deducted. The issue is that "To Be Built" should not be deducted. It doesn't make sense to deduct "To Be Built".
I use premier so maybe something is different in enterprise, I have one column, for assemblies
that number comes from pending builds, you have told QB you will need those items in the future for a build
On sales order means you have promised that qty to a customer
So qty available is the qty remaining that is not "reserved" for a customer or build.
Actually QB does not reserve anything, even if the qty need for a build is 5, and 5 are stocked, you can sell those 5
In menu edit>preference>inventory>company tab you can select whether or not you use on sales order and pending builds in the available calculation.
Would you post a screen shot of the report showing a column for to be built, and for assemblies?
Hi Rustler -
Thank you for your feedback. As requested, I've posted screenshots. Also, I've reviewed my settings. My settings show "When calculating Quantity Available for my inventory, deduct: Quantity reserved for Pending Builds and Quantity on Sales Orders".
I understand if the quantity for "On Pending Builds" is deducted because those items will be consumed to make a different item. The issue is that the "To Be Built" quantity should Not be deducted from "Available". "To Be Built" implies that more of an item is in the works. Once "To Be Built" is complete, it will boost the "On Hand" and therefore "Available" quantities.
When will "Availability" quantity in Quickbooks Enterprise (QE) be fixed on the Inventory Stock Status By Item report? Interestingly, the "Availability" quantity appears to be correct in other sections of QE.
Will the problem be fixed in the release of the 2019 Quickbooks Enterprise?
Hey there, @Dav.
Allow me to share additional insight into the Inventory Stock Status By Item report. The report shows any and all inventory statuses that would affect quantity on hand for an item. This includes "to be built" and "pending builds" for assemblies.
You're right in stating the "to be built" will later increase the available quantity, however, because these items have not been completed, the assemblies are not yet available. "To be built," like "pending builds," refers to anything that has not yet been finished, but in this case has been noted as being sold in the future. In addition, similar reports may show differently, as they gather and organize the same data, but for different purposes.
The point you're trying to make is not lost on me, however. I also see how this can be beneficial to a business to not have "to be built" included with the other data. What I've gone ahead and done for you, is submit feedback to the Product Development team to have them take a look at this. Even though QuickBooks 2019 has already been rolled out, it's not too late to have your voice heard, and this is the best way to go about that.
I hope this helps to clear up any questions about the Inventory Stock Status By Item report. Should you have any further inquiries about this or anything else QuickBooks, don't hesitate to reach out to me here in the Community!
Please don't shut your mind and blindly regurgitate answers. This is a major problem with Quickbooks and it is causing our company some major problems with inventory management.
I'm going to restate the question referencing the "Build Assembly" screen. Go to a build assembly and populate it with a build and make the build a pending build with the build amount set to "1".
In the upper right hand corner of the build, it lists the:
quantity on hand
quantity reserved for other assemblies
quantity available
For my item it lists:
Quantity on Hand: 200
Quantity Reserved for Other Assemblies: 10
Quantity Available: 190
Now click Build and New and then navigate back to this build.
It now Lists
Quantity on Hand: 200
Quantity Reserved for Other Assemblies: 11
Quantity Available: 189
So, effectively making a pending build of an assembly reduces the quantity available of that assembly by 1.
Hey @Anonymous,
We are striving hard to provide on-point answers to our customers' concerns. All your comments and suggestions are important for us to provide you with the best product.
Your Quantity Reserved for Other Assemblies denotes the number of items that are available for your builds. Whenever you mark a build as pending, it adds to your reserved quantity.
Also, even if it deducts your Quantity Available, you can always sell your assemblies.
Please let me know if you have other concerns.
Hi -
As of QuickBooks Enterprise v20, this report problem was somewhat addressed but not completely resolved.
Basically, instead of the "To Be Built" quantity erroneously decreasing "Available" quantity, it is now increasing "Available" quantity and it should not. The "To Be Built" quantity should not be part of the "Available" equation.
(Side note - the prior problem of "To Be Built" decreasing "Available" quantity was especially bad because it would flag the "Order" column to re-order when you actually had enough being built on pending builds. Now, with the current QB version, your item won't be flagged to "Order" if you have enough being built, but the problem is that your "Available" quantity is overstated and assumes you already have those items in stock.)
In other areas of QuickBooks, if you look up "Quantity Available" and "Available" in other reports, it ties. However, in the "Inventory Stock Status Report by Item", "Available" quantity is not tying to "Quantity Available". Assuming you're looking at data with the same date range, those 2 figures should tie out.
To better understand / see this issue:
The "To Be Built" quantity should function in the report like the "On PO" quantity. For example, if an item's "Available" quantity + "On PO" quantity is over the Reorder Point, the item won't be flagged in the "Order" column for reorder because the QB system recognizes you already have enough ordered on a PO. Just to be clear, the "On PO" quantity is not part of the "Available" quantity. Anyhow, the "To Be Built" quantity should be handled in the same way in this report. If "Available" quantity + "To Be Built" quantity is over the Reorder Point, the item won't be flagged in the "Order" column. Also, this report should have a permanent "To Be Built" column.
For quick reference, this the correct formula for Available quantity for an item:
Available qty = On Hand qty. - On Sales Order qty. - On Pending Builds (otherwise known as For Assemblies)
(The On Pending Builds qty. is how much of the item is going to be consumed by pending Build Assemblies.)
Can this report problem be fixed in the next software update?
Thank you for getting back to us, Dav.
As what my colleague mentioned above, similar reports may show differently, as they gather and organize them for different purposes.
You're welcome to provide your comments and product suggestions that will be beneficial to your business needs in the future. I'll show you how you can submit a feedback or product suggestion inside QuickBooks.
Like this:
You can visit this link where you can check for any news and updates of our products: QuickBooks Blog.
Post your concerns or click the reply button for any other questions about inventory. I got your back. Have a nice day!
Hi @Archie_B -
There is a problem with the report. This issue is not about differences in they way reports run or designed.
There is a real problem here.
When will QuickBooks fix this?
Can you submit this to Product Development, and keep us posted on the status?
Hi QuickBooks -
What is the status on fixing this report problem?
Welcome back to this thread, Dav.
Let me share additional information regarding your concern about the Inventory Stock Status By Item report in QuickBooks Desktop (QBDT).
The moment you send a product suggestion through the feedback option shared by my colleague, we should start working on it. However, regarding its status, we're unable to provide an exact time frame as to when will this report be available.
While we are working on this, I encourage you to turn on the automatic updates in QBDT. This way you will get updates whenever there are new features, releases, and critical fixes available.
To do that:
Another way to get you in the loop about the latest news and product developments in QuickBooks Desktop is to visit our Firm of the future site. To narrow down your search, you can go to the Product & Industry News tab.
You might also be interested in learning more about customizing reports through the following articles below:
Anything else you need help with can be answered here in the Community. Just let me know and I'm always here to assist. Have a good one.
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