I need to find a report that appears a comparison between standard BOM quantity and actual in build assembly with a cost. Please

Nice to see you again, @alimonqith.

We can attempt running an Inventory Valuation Summary to check the average cost and quantity of your assembly items.

Let me show you an example:

1. Go to the Inventory menu and select Inventory Center.
2. Locate the BOM on the left-side and click the Inventory Valuation Summary on the Inventory Information.

You can also refer to this helpful blog for more info about this report: Common QuickBooks inventory accounting mistakes.

Additionally, I'll include this link for other reports you can use to keep track of your inventory: Customize item reports.

You're always welcome to post here in the Community in case you have additional questions. I'll be around to help. Have a good one.

Dear @IntuitLily 

Firstly I'd like to thank you for your quick respond 

Secondly, I have known this report Inventory Valuation Summary, this report did not appear the standard cost of the BOM.

I Mean when I created Assembly Item BOM named (X) I will put the standard quantity, sometime when the Productions Manager needs to create a build assembly for Item X he will but the actual that he spent. so, in this case, he has some waste for some reason, so I need to know :
1- The amount of deviation between the standard quantity and the actual quantity in the production process
2- the total standard BOM cost as you have shown in the attachment, please 

Thanks.

Dear @IntuitLily 

Firstly I'd like to thank you for the quick response.

Secondly, I have known this report Inventory Valuation Summary, this report did not appear the total of the standard BOM Cost.

I mean when I created Assembly Item for example named (X) with Standard BOM when Production Manager needs to create a build assembly for Item (X) sometimes he needs to change the quantity to the actual that he has spent in the productions process maybe he faced some waste for some reasons, so I need to know in the report:

1-  The deviation between the standard quantity and the actual quantity in the production process.

2- The total cost BOM as shown in the attachment, I need this cost appears in the report.

Thanks

I appreciate the complete details you've provided, @alimonqith.

Let me share some information on how the Total Bill of Materials Cost affects inventory reporting.

The Total Bill of Materials Cost field is not directly tied to the cost or avg cost values. This is the sum of the cost values of the components in the Bill of Materials as the total cost of the assembly. Also, the amount reflected on the Cost value field will not be updated automatically.

This is not used to calculate the actual cost on reports like the profit and loss. Though, it will display a cost on the Item Listing and Price List reports. Changes made on the components does not affect the Average cost. 

Let me know if you have other questions about generating inventory-related reports. I'm always here to help.

Dear @IamjuViel 

Thank you for your response to my inquiry. I appreciate the information you have provided me with and I appreciate the prompt reply.

I know the cost or avg cost values in the reports depending on what we are selected in the preferences ( The default is weighted average costing or we can enable the FIFO ) and both of these methods are not tied to Total BOM cost field.

I am wondering if we can customize a report containing the  Total BOM cost field + Average cost for every build assembly.

Please, for example, As you have shown in the screenshot the average cost for every build assembly and I need to appear the Total BOM cost field under the Cost in the same report to see the comparisons and help us to try to enhance our productivity.

Thank you for your patience.
شكرا جزيلا يا عزيزي

Hi alimonqith, 

If this is something beneficial to your business, I will send this directly to our engineers. They can put customer's ideas to work in the future.

You might want to check out our QuickBooks blog for product updates and announcements.

For future reference, let me share this article: Customize company and financial reports.

We'll be around if you have any other concerns. Have a good one.

Hi, 

I have the same needs as yours. We want to see comparison between BOM cost and actual cost of products produced. I wonder if you have an update or found a workaround for it. 

Thank you

Hello there, ThuanPham.

I can see the idea of running a report on the comparison between BOM cost and the actual cost of products produced.

As of now, this option is still not available in QuickBooks. I'll be taking note of this suggestion and share it with our Developers team.

You may check our blog to check and see our latest product updates.

Feel free to take a look at this article when customizing company reports: Customize Company and Financial Reports.

I'm just a post-away if there's anything that I can help. Take care!

How do I make BOM default for all my total cost. There are 3 choices. I just want to make BOM my default for all my build assembly. 3 choices are Use global preference, Use defined cost and Use Total BOM.

Hey there, @SELBY1. 

It's great to see you back in the Community. I hope your day is going well so far. 

There isn't a report preference for BOM at this time. However, you can customize the report the way you'd like. Here's how: 

1. Go to the Reports tab. 
2. Locate and click the report you want. 
3. Hit Customize Report when on the "Report" window. 
4. On the Modify Report window, go to the tab/s you need to update, then select OK when you're done.

It's that easy! For future reference, check out this guide for all details about reports: Understand reports. 

Feel free to reach back out if you have any questions. I'm only a post away if you need me. Take care!