Solved

Service Order Profitability

  • 16 October 2020
  • 9 replies
  • 312 views

Userlevel 2
Badge

We can see profitability for projects and for appointments but there is no way to see profitability by Service Order. I heard this may be coming in 2021R1. Can this be confirmed?

icon

Best answer by Anacarina Calvo 22 October 2020, 20:56

View original

9 replies

Userlevel 1

Service order profitability is tentatively scheduled for 2021R2

Userlevel 2
Badge

Hi @dalesimmerly87 

Is this functionality will calculate all materials and services expenses related to Service Order?

Regards,
Daru

 

Userlevel 6
Badge +4

Hi @purwandaruw47 
Yes, it will show Materials, Expense Receipts and AP Bills associated, as well as Labor spent on the appointments

Userlevel 1

I have a question about this. How does the profitability tab on an appointment show the profitability for labor? We have tried to enter labor activities etc, and it is not calculating into the gross margin or profitability. Would love to hear some solutions people have for that. 

Userlevel 6
Badge +4

Hi @acheesman 
The profitability for labor is taken based on what is registered on the Log tab. Make sure that on the Log tab, the Labor Item ID column is set, and on the Labor Rates (PM209900) form, the Labor Item is defined for the employee. The system calculates the labor cost for a staff member for an appointment only if the Employee or Labor Item labor rate type and the Hourly type of employment are assigned to the staff member on the Labor Rates form.

Keep in mind that labor only adds Cost to the appointment, so on the profitability tab, the line will not show Unit Price, or Billable Amount, therefor, Profit and Profit (%) will be negative. You can see overall profit analysis on the Totals tab of the appointment form (or on the header on versions 2022R1 or earlier). 
Let me know if this answers your question. 
 

Userlevel 1

Thank you Anacarina, 

I did end up seeing the Totals tab and that does definitely help show an analysis of the Profit and Profit%. That does help, but still confusing as to why if the labor is billable, why those values don’t get populate and reflect on the profitability tab. Again, this is interesting that when we budget for labor before we log the time, we don’t see price/cost, but when the activity is logged, then it shows as a line item, but the billable amount is 0, therefore the profit columns are negative. Just want this to be as intuitive as possible for customers who use this to make business decisions on how and what work should be done on service orders. 

 

Would it be possible to do a session with you for a few so we can run through the scenario and make sure we have run through the processes properly? Feel free to email me at acheesman@premiercomputing.com. Thinking 15-30 min tops. 

Userlevel 6
Badge +4

@acheesman 
If the labor is billable you would need to add a service and register time against the service. The Price will come from the Service and the cost will come from the labor associated. 
I will send you an email to coordinate a meeting and explain any questions

Hi @Anacarina Calvo 

I have a question to clarify on this topic of labor costing in service orders / appointments.
 

If a service order is linked to a project, the labor log items create a time activity. Upon release of the time activity, the labor cost is posted to the associated project and the Labor COGS GL account. Labor cost rate is used from the Labor rates screen as per config. This process works well. 

 

If a service order is not linked a project and invoiced directly, then the labor time activity doesn’t hit the GL because it’s posted to project X. A Project is generally not linked to such service orders, as it’s not the project workflow, but the Service Order to SO Invoice workflow. So in this workflow, what is the best process to book the labor cost to a Labor COGS GL account? 

@Anacarina Calvo  -  I did some more research and found that service order to invoice workflow does not generate Labor COGS transaction, as it uses the non-stock service item on the invoice. The labor item doesn’t produce any transaction if posted to project X. Just want to confirm I am not missing anything here. Thanks.

Reply


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