Bill of Materials

Hello KLemley,

QuickBooks Desktop uses First In First Out principle. What comes first will be used in sales or when building assemblies (bill of materials). The same thing applies to the purchasing price of the item. Whatever is the purchasing price (at the time they are acquired) of the items being used in assemblies, that will be the COGS when you sell the item. Currently, there isn't a report for this.

By the way, the inventory count of the items in the bill of materials will only decrease once you build the assembly.

Let me know if you have other questions in mind.

So no report available?  Can a custom report be created based on current sales order versus inventory to determine purchasing needs of the items?

Hi, KLemley.

I know how important it is to have a report based on current sales orders versus inventory items, however, this type of report is currently unavailable in QuickBooks Desktop.
 

You can follow the steps below to know what the available custom reports in QuickBooks are:

1. Click Reports at the top menu bar.
2. Choose Custom Reports.
3. Select the desired report.
   

While this report isn't available, I'd suggest visiting the What's New section on your QuickBooks Desktop, to stay informed with our latest news and updates including product improvements.
 

I recommend customizing the report to get the specific details you need. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use.

I'm just a few clicks away if there's anything else you need. Have a great rest of your day!