build assembly count

Hello DonnyMC.

I'll be happy to help you get your inventory tracking properly.

I was able to find something that may work for what you are trying to do. 

An Inventory Assembly item is one type of line items used when creating a sale or purchase form. Creating and adding assembly items to inventory is a two-step process:

1. First, define the Bill of Materials (BOM) to specify what components go into making the assembly item, then build a quantity of the assembly item so QuickBooks Desktop can deduct the component parts from the inventory and add new quantities of the assembled item.
   Note: As soon as you build an assembly item, its component parts no longer exist as separate parts in inventory because they have become part of a new inventory item called an inventory assembly.
2. After assembly items are defined, they are added to inventory by "building" them. An assembly build is necessary to keep inventory quantities accurate.
   Note: Each time an assembly item is built in QuickBooks Desktop, the inventory parts and other assembly items (sub-assemblies) in the BOM are deducted from inventory and the quantity of the assembly item increases.

You can find more information on this here. 

Please look this information over and let me know if that will work for you. I'll be here to make sure this gets resolved.

@DonnyMc

I'm not quite sure what you are wanting.

You build the assembly and 45" are removed from inventory
a QR for the item will show a negative qty, and a QR report for the assembly item will show a positive qty.

An item valuation detail report, customize set the filter for item and select all assembly items - will show the number built for the report date range.

An item QR, customize and set the filter to Item Type, select all assemblies, will show the item use for the report time period

A custom transaction detail report might work to do it all for you
set the columns to show Type, Date, Num, memo, item, qty, and set the total by to Item type - click filters and set the transaction type to Build Assembly

set the date range, refresh the report

Hello SterlingD,

Thanks for the information, but this is stuff I already know and do.  We have raw materials where some are turned into components (assemblies), and finished goods (assemblies) that use raw materials and components.

I know I'm not explaining it well, sorry.  Let's try this.

We have raw rail material DSRLA that we inventory in inches.

On 12 different days during the month of September I put Build Assemblies into the system of various amounts of DSRLAS25A (one of our rail assemblies).  Is there a report I can run, or a place I can look, that tells me, in total, how many DSRLAS25A were built (consumed from raw material DSRLA)?  I can run a Quick Report from the Item List and manually count down the line of positive numbers (build assemblies) and/or the negative numbers (assemblies consumed by higher level build assemblies), but it takes a while.  I want something that gives me a total for either positive build assemblies or negative consumption of those assemblies during that time.

Thank you for the help.

Donny

The closest I can come is the custom transaction report I explained in my first answer

I have edited that response to include the qty column, somehow I forgot it.

 the report will show the number built per day but will not total that column, do it mentally or export to excel and format the column