Skip to main content
Question

Bill of Materials Detailed Report with costs

  • June 13, 2023
  • 14 replies
  • 507 views

rsieger
Freshman I

I am trying to get a report showing detailed BOMs including costing and I can’t seem to find how to do this? Can anyone help?

14 replies

Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • June 13, 2023

@rsieger - did you look at the Multi Level BOM report (and select Costed)? Will this work? 


rsieger
Freshman I
  • Author
  • Freshman I
  • June 13, 2023

I can’t seem to find that report?


rsieger
Freshman I
  • Author
  • Freshman I
  • June 13, 2023

I found it, sorry! Form AM413000 correct?


Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • June 13, 2023

@rsieger - yest that’s correct. 


rsieger
Freshman I
  • Author
  • Freshman I
  • June 13, 2023

Thank you @Debbie Baldwin !! You are amazing!


rsieger
Freshman I
  • Author
  • Freshman I
  • June 15, 2023

@Debbie Baldwin So report AM413000 does not show the quantities of the parts within a BOM. So for example if Item XYZ has 2 ABC Parts in the assembly, I am not seeing that in this report. Does that make sense?


Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • June 15, 2023

@rsieger - yes it does - so that’s on the Engineering tab  but you are right - I don’t see anything that has both. Perhaps you could take the report and modify it to show quantities. 

Also take a look at the Engineering Workbench. This might help you too. (Unsure of what you are needing) 


rsieger
Freshman I
  • Author
  • Freshman I
  • June 15, 2023

I am looking for a report that shows all of the BOMs in the system, in detail, costed out. The AM413000 does not show the quantities of the sub-assemblies. Does that make sense? Am I writing that correctly

 

So in this example, look at PLA-035 SEAT CLIP, there are 2 in this item, how is that indicated?

 

So I would like to see something like this (but with the costs associated):

 

 


Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • June 15, 2023

@rsieger - yes - I understood - this is a custom report. (or a customization to the existing report) 

Not sure if anyone on communities has written one that they would want to share? 


rsieger
Freshman I
  • Author
  • Freshman I
  • June 15, 2023

Yeah, that’s what I was afraid of @Debbie Baldwin , thank you! You are amazing!! I appreciate your help! 


Forum|alt.badge.img+1
  • Jr Varsity III
  • June 30, 2023

You can export the report to Excel and manipulate the layout rather than a custom report.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • July 13, 2023

Hi @rsieger were you able to find a solution? Thank you!


cmoreland
Semi-Pro III
Forum|alt.badge.img
  • Semi-Pro III
  • April 18, 2025

Hey jut wondering if you ever found a solution. We are looking for something similar but want to run it for class of part. 


Forum|alt.badge.img
  • Freshman I
  • May 8, 2025

Reading thru this thread something popped up for costing i’ve been in search.  I know how to cost a BOM and the detailed report, etc.  I have multiple BOM’s that have between 1-10 operation ID (multiple different work centers).  For the once with multiple operation ID’s, I’ve been looking for a costing report where is breaks it down for each operation (operation 0030, operation 0040, operation 0050, etc.) for a certain BOM I’m running thru production.  Has anyone had any experience with this?