Build Assemblies - BOM QTY Issue

Thank you for confirming the quantity in your assembly build, cwindham. I'll explain why the numbers appear differently when you generate your report in QuickBooks Desktop (QBDT).

To begin, the quantity to build refers to the number of units of an inventory assembly item you plan to produce or assemble. Thus, when generating the Shortage Report by Item, the For This Build column will be based on the quantity you entered for the item in the Build Assemblies window rather than on the Quantity to Build field.  

Additionally, please ensure that you enter the correct number for each item to ensure your data is accurately reflected in the report. You can refer to the screenshot below for comparison:

If you entered a quantity for each item and it's not showing in the report, I suggest troubleshooting this issue by verifying and rebuilding the data.

Furthermore, if you notice possible data issues or you've done the research and suspect data damage, kindly access this material: Fix data damage on your QuickBooks Desktop company file.

If you have more questions or need further assistance regarding viewing the data in your report, please click the Reply button and share your concern with us. We're here to support you every step of the way.

@cwindham 

Run the Verify/Rebuild Data utility. Any unresolved error messages?

I have done the verify and rebuild function.. no luck. I also deleted the top assembly item from QB and imported again, just in case it did not import correctly (that's what the support guy told me to do over the phone). That did not fix it either. 

I noticed that when I viewed one of the assembly items in "item list" it provides an option to check a box called "subitem of". Do I need to flag each assembly item within the top assembly? Does that make a difference?

I checked the top assembly item (93192-02) BOM in item list and reviewed the Qty column for assembly/raw material, and these quantities are correct (highlighted in pic). 

Thanks for the help! I'm sure it's something I am missing in the settings or something that is throwing off the shortage qty. 

It's unnecessary to check the Subitem of option for each sub-assembly within the main assembly, as it won't make any difference, Cwind. Now, let's delve deeper into why your assembly build quantity doesn't match the figure listed in your shortage report and how we're able to fix it.

A shortage in assembly occurs when the required quantity for an item exceeds your current stock. For instance, if the assembly build requires 25 items of a specific type but only 20 are available, it will lead to a shortage in the assembly.

You'll have to take a look at the items used in your assembly to ensure that the needed quantity is less than or equal to the quantity you have on hand. To do this, here's how:

1. From the Lists menu, select Item List.

2. Double click the Inventory Assembly item. Then, choose Full View to see the bill of materials.

3. From your Bill of Materials Full View, double click each item to verify.

For further information in using inventory assembly items and tracking your finished goods, feel free to read this article: Combine your inventory items to build finished goods (assemblies).

Just incase you'll need to record an adjustment every now and then to keep your inventory status in QuickBooks accurate, just visit this article: Adjust your inventory quantity or value in QuickBooks Desktop.

We're always ready to respond promptly if you have more questions about shortages when creating a build assembly, just revisit this thread. We strive to enhance your QuickBooks experience.

Another troubleshoot, run a Condense Data utility session with any scenario to isolate the problem. You may find a hidden problem in your inventory counts.