Skip to main content
Solved

Details of average costs

  • February 7, 2022
  • 3 replies
  • 335 views
I
Freshman I

Is it possible to see a breakdown of total average cost of production into average labor/average material/average overhead and average outside service costs respectively. Is there already a way to do this, is there is sufficient data available to break this out with a custom report or would I need to have a customization to get to this level of traceability? 

Best answer by etrojan73

@iancook36 you can query the database to create a new report. All the fields you are looking for should reside in the database table, AMPRODTOTAL. You will also need to determine your grouping for the report ( ie work center, group by month etc.) Also, creating a parameter would be nice so you can narrow it down by current year or month. Once that is setup you can add an aggregate function to average the labor, material, overhead and outside services for each line. In addition, you can turn that generic inquiry into a pivot table to compare the avg production costs by week, month, year.

View original
Did this topic help you find an answer to your question?

3 replies

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • angierowley75
  • Acumatica Moderator
  • 848 replies
  • February 7, 2022

All the costs are capture and broken out on the production order - but i do not know of a standard report that will calculate total averages - you would need to write a custom report or inquiry.

If I have helped you, please ~ *Like* my post. If I have provided an answer to your question, please mark it as *Best Answer* . Thank you!
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
martingaxiola
Varsity I
Forum|alt.badge.img

I have the same question for my clients as well. 

Martin Gaxiola
E
Varsity I
Forum|alt.badge.img
  • etrojan73
  • Varsity I
  • 26 replies
  • Answer
  • February 7, 2022

@iancook36 you can query the database to create a new report. All the fields you are looking for should reside in the database table, AMPRODTOTAL. You will also need to determine your grouping for the report ( ie work center, group by month etc.) Also, creating a parameter would be nice so you can narrow it down by current year or month. Once that is setup you can add an aggregate function to average the labor, material, overhead and outside services for each line. In addition, you can turn that generic inquiry into a pivot table to compare the avg production costs by week, month, year.

A
Chris Hackett
2 people like this
  • A
    alicezyks51
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved