Skip to main content
Question

Bill of Materials Detailed Report with costs


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?

12 replies

Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • 477 replies
  • 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
  • 9 replies
  • June 13, 2023

I can’t seem to find that report?


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

I found it, sorry! Form AM413000 correct?


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

@rsieger - yest that’s correct. 


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

Thank you @Debbie Baldwin !! You are amazing!


rsieger
Freshman I
  • Author
  • Freshman I
  • 9 replies
  • 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
  • 477 replies
  • 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
  • 9 replies
  • 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
  • 477 replies
  • 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
  • 9 replies
  • 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
  • 66 replies
  • 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
  • 2750 replies
  • July 13, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings