Skip to main content
D
diamondeng
January 30, 2024
Question

Build shortages displaying incorrectly - showing items of sufficient quantity sub-assemblies as shortages.

  • January 30, 2024
  • 1 reply
  • 0 views

Quickbooks enterprise 2024, We are having problems when running build shortage reports. It would appear when there is a shortage of any item in the main assembly (can be item or assembly) causes the items of sub-assemblies to show up in the shortage list even if there are enough of the sub-assemblies on-hand.  What is displayed is a false shortage but makes it nearly impossible to use the shortage list.

This is 100% replicable, we have replicated on our live company file and a brand-new sandbox file to ensure that we aren't using "corrupted data" and yes, we have verified, rebuilt and sent our file off to the "QB Doctor" 

 

Assume we want to build: 

Assembly A consisting of: 

        -Item A - 4 required, 4 on-hand - OK

        -Sub-assembly A - 1 required 3 on hand -- OK

               Sub assembly A contains: Sub-Item1 - 1 required to build sub-assembly A, 0 on hand (OK because sub-assembly A is already on-hand)

The Scenario above builds with NO errors, this is great.....  Now here is where the problem happens: 


If everything stays the same except you try to build Assembly A , with only 3 of Item A on hand, it will come up with the menu with the shortages button, if you display the shortages here is what you see: 

A Shortage of Item A by one item ---- This is correct

A Shortage of Sub-item1 ---- This is incorrect!!!!! , this part should not be in the list, It is a part of sub-assembly A which we already have 3 on hand, but somehow is calculating quantities needed from the QOH of the subassembly items.  This is grossly wrong and makes a HUGE mess if you are only missing one part in the entire build. 

 

The quantity of items required to build a sub-assembly should not even be looked at if there is sufficient quantity of the sub assembly already on hand.  (yes this happens WITH or WITHOUT automatically build sub-assemblies checked and as I mentioned these are false reports because when you have sufficient quantity of all the other item(s) it builds with no issues and all parts are taken out of inventory properly. 

 

Essentially this can cause 1 shortage to show tens, hundreds, or more  of false shortages depending on what is in your main assembly

 

Step by step screen shots can be uploaded if necessary. 

1 reply

G
GlinetteC
January 30, 2024

I commend you for reporting this issue with us, diamondeng.

 

Pulling up an accurate Shortage Report for Build is essential in every business. I'm here to assist you in resolving this.

 

There are no known concerns similar to this one. As an alternate, manually check and count the build assembly for the short items and adjust the inventory count.

 

In addition, I'm sharing this article to learn about combining inventory items: Combine your inventory items to build finished goods.

 

Furthermore, you can check this article for more benefits in tracking inventory, which includes assigning items purchased to a specific location and moving your inventory to another location: Multiple Inventory Sites.

 

If you require further assistance managing reports or related matters, reply to this thread. I am here to support you at any time.

D
diamondengAuthor
January 30, 2024

Thank you for your reply, I realize a text description is not the best therefore I have attached screenshots to show the actual problem.  It is very clear that one part shown in the shortage list does not belong there and not an actual shortage. I would like this to be recognized as a legitimate known issue and assigned a ticket number so that your developers can correct the problem.  While not a huge problem for a simple assembly as shown, but if with a bunch of sub assemblies there could be hundreds of false shortages shown making the shortage report useless.  Your developers are welcome to reach out to me for further instructions to replicate the problem. 

 

 

J
JamaicaA
January 30, 2024

Thank you for adding screenshots to get me on the same page, @diamondeng. Let's go over your Shortage report to clarify the deficit item assemblies.

 

As of designates the point in time from which something occurs. In this case, you'll want to take note of the Date you selected items in the Build Assembly window.

 

For instance, you added 5 in the available quantity on December 20. However, the reporting period you've set on the report ends on December 15. Therefore, it will show a mismatch because of the indicated term. See these screenshots below:

 

 

 

Let me add the article on how you can track the products you build using inventory items. 

 

If there's a need to modify your inventory, scan this resource for more information: Adjust your inventory quantity or value in QuickBooks Desktop.

 

Feel free to drop me a line if you're struggling with inventory in QuickBooks. I'd be happy to offer you my expertise. 

Terms & ConditionsAccessibility statement