Bill of Materials

Forum|Forum|4 years ago
January 13, 2022
3 replies
43 views

Setup Bill of Materials for an item and need to understand based on current orders of the finished good item, what Items need to be purchased. Is there a report available with all this data for a specific time frame?

QuickBooks Desktop

JessT

Moderator

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.

KLemleyAuthor

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

Rose-A

Level 10

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:

Click Reports at the top menu bar.
Choose Custom Reports.
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!

Sign up

Login with SSO

Let's get you signed in

Login with SSO