Skip to main content
Question

Bill of Materials Detailed Report with costs

  • Jun 13, 2023 4:55 PM UTC
  • 14 replies
  • 594 views
  • Translate All

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
Community Manager
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • Jun 13, 2023 5:00 PM UTC

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

Translate

rsieger
Freshman I
  • Author
  • Freshman I
  • Jun 13, 2023 5:49 PM UTC

I can’t seem to find that report?

Translate

rsieger
Freshman I
  • Author
  • Freshman I
  • Jun 13, 2023 5:51 PM UTC

I found it, sorry! Form AM413000 correct?

Translate

Debbie Baldwin
Community Manager
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • Jun 13, 2023 6:07 PM UTC

@rsieger - yest that’s correct. 

Translate

rsieger
Freshman I
  • Author
  • Freshman I
  • Jun 13, 2023 6:15 PM UTC

Thank you @Debbie Baldwin !! You are amazing!

Translate

rsieger
Freshman I
  • Author
  • Freshman I
  • Jun 15, 2023 1:50 PM UTC

@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?

Translate

Debbie Baldwin
Community Manager
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • Jun 15, 2023 2:10 PM UTC

@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) 

Translate

rsieger
Freshman I
  • Author
  • Freshman I
  • Jun 15, 2023 2:23 PM UTC

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):

 

 

Translate

Debbie Baldwin
Community Manager
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • Jun 15, 2023 2:49 PM UTC

@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? 

Translate

rsieger
Freshman I
  • Author
  • Freshman I
  • Jun 15, 2023 3:04 PM UTC

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

Translate

  • Jun 30, 2023 5:34 PM UTC

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

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Jul 13, 2023 10:06 PM UTC

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

Translate

cmoreland
Semi-Pro III
Forum|alt.badge.img
  • Semi-Pro III
  • Apr 18, 2025 7:49 PM UTC

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

Translate

Forum|alt.badge.img
  • Freshman I
  • May 8, 2025 6:39 PM UTC

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?

Translate