cancel
Showing results for 
Search instead for 
Did you mean: 
Dav
Level 5

Question About "Inventory Stock Status By Item" Report - Problem

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".

11 Comments 11
Rustler
Level 15

Question About "Inventory Stock Status By Item" Report - Problem

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?

Dav
Level 5

Question About "Inventory Stock Status By Item" Report - Problem

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.

Dav
Level 5

Question About "Inventory Stock Status By Item" Report - Problem

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?

ClayJ
QuickBooks Team

Question About "Inventory Stock Status By Item" Report - Problem

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!

Anonymous
Not applicable

Question About "Inventory Stock Status By Item" Report - Problem

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.

Alessandra_B
QuickBooks Team

Question About "Inventory Stock Status By Item" Report - Problem

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.

Dav
Level 5

Question About "Inventory Stock Status By Item" Report - Problem

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:

  1. Run the "Pending Builds" inventory report and pick one of the items from that report. (Note - Qty on the Pending Builds report is also known as the “To Be Built” quantity.)
  2. Then, go to menu bar "Inventory"  - "Item List" - look up the item you picked from the Pending Builds report.
  3. Click on the item line , right click your mouse to get a pop-up menu, choose "Current Availability". 
  4. In the next screen you'll see a a pop-up window and a figure that shows "Quantity Available".   Assuming you ran your inventory report with no date restrictions, this "Quantity Available" should tie to "Available" in the "Inventory Stock Status by Item" report.

 

 

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?

 

 

 

 

@ClayJ @Alessandra_B @Rustler 

 

Archie_B
QuickBooks Team

Question About "Inventory Stock Status By Item" Report - Problem

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:

 

  1. Go to the Help menu.
  2. Select Send Feedback Online.
  3. Click on Product suggestion.

 

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!

Dav
Level 5

Question About "Inventory Stock Status By Item" Report - Problem

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?

Dav
Level 5

Question About "Inventory Stock Status By Item" Report - Problem

Hi QuickBooks -

 

What is the status on fixing this report problem?

Charies_M
Moderator

Question About "Inventory Stock Status By Item" 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:

 

  1. Go to Help.
  2. Click Update QuickBooks.
  3. Choose the Options tab.
  4. Select Yes to enable the Automatic Update method.
  5. Click Save then Close.

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.

Need to get in touch?

Contact us