Skip to main content
Solved

Details of average costs

  • February 7, 2022
  • 3 replies
  • 423 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.

    3 replies

    angierowley75
    Acumatica Moderator
    Forum|alt.badge.img+3
    • angierowley75
    • Acumatica Moderator
    • 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!
      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
      • 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.

        Terms & ConditionsAccessibility statement
        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