Creating Labor Rates Based on Pay Code and Position in Key2Act Service Management

by | Updated August 17, 2020 | Dynamics GP, Field Service, Key2Act

Labor rate groups are built using overhead groups created from Service Management or Job Cost. Use the Labor Rate Group Setup window to do this. You can also add a billing amount and description to each overhead group record.

You create labor rates based on pay code and position using the Labor Rates window.
1. Choose Microsoft Dynamics GP > Tools > Setup > Service Management > Invoice Setup > Labor Rates.

2. Complete the following fields.

  • Labor Rate Group Name – Create a name for the labor rate group.
  • Position – Use the lookup window to select the position to which this labor rate should apply.
  • Pay Code – Pay codes are used to distinguish between labor rate groups with the same name and position. Each group may have multiple billing amounts (rates) for a combination of positions and pay codes.
  • Note: Position and pay code set up in Microsoft Dynamics GP must match position and pay code in Service Management’s labor rate group.
  • Description – Enter a description. For example, Supervisor – Regular or Supervisor – Overtime would differentiate one pay code from another.
  • Fixed OH per Hour – The fixed overhead per hour is a flat amount charged to recoup overhead costs such as union fringe benefits paid per hour. It constitutes the overhead portion of the amount – the extended portion is the pay rate multiplied by the number of hours.
  • OH Percentage – The overhead percentage is a percentage charged to cover overhead costs, such as social security, workers compensation insurance, vehicle operating expenses, or unemployment taxes. Your overhead percentage may include general and administrative expenses that you may wish to apply as a percentage of labor cost. It constitutes the overhead portion of the amount – the extended portion is the pay rate multiplied by the number of hours.
  • Billing Amount – The Billing Amount field shows the rate charged for the labor group name, specific position, and corresponding pay code. Leave the field blank to create a zero-dollar billing amount.

3. Choose Save to add the record to the scrolling window and add the labor group name to the Labor Rate Group Name lookup window.

To edit a labor rate group

Double-click the labor rate group in the scrolling window. The text fields in the data entry area of the window fill in with the labor rate group information. And you can change these from here

To delete a labor rate group

Double-click the labor rate group in the scrolling window and choose Delete. This clears all the data entry fields except for the Labor Rate Group Name field and clears the record from the scrolling window.

Common Error Messages

Normally this is because a New Paycode or Position have been added but they were not added to the Labor Rate Group.

I need to know how the overhead amounts and total cost and then billing calculated on this transaction. How do they come up with the amount 111.25 as the total cost?
Your overhead amounts are determined by your Labor Rate Groups in Service Management associated to that service call and your employees’ rates by paycodes and hours worked. An example is the easiest way to demonstrate. Here is our Labor Rate associated to the Service Call

Here is how you determine how the amount of 111.25 cost is calculated. In this case the Technician worked 5 hours with an hourly rate of $17.80 per hour.

Take the techs hourly rate 17.80 x 5 hours worked = $89.00

Take the total cost 89.00 x overhead percentage 25% = 22.25 burden for overhead Add the hourly rate of $89.00 plus the overhead of $22.25 and you have the $111.25 for the cost in the journal entry. Billing rate is 5 X 135.00 in the Labor Rate Group = $675.00

The Invoice has the wrong Billing Rate.

The Labor Rate Group pulls the billing Rate from the Paycode, Position of the Employee Time Track entry.
2 Most common cases are this:
a. This information defaults in from the Employee Card. If the employee entering the Time card changed either of these. This would result in something different than expected.

b. The Labor Rate Group Pulls from the Bill TO address in Customer Maintenance. If the address was changed or the Labor Rate Group was changed, This cold result in a mismatch

 

Check out our other two blog posts on How to Create Labor Rates in Key2Act Service Management & Overview of Overhead Codes and Groups in Key2Act Service Management

Related Posts

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

october

07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Managing Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Management: Introduction of NEW Functionality for Manufacturers Using Dynamics 365

november

18nov10:00 am10:30 amThe Modern Manufacturer - Tears and Trauma of MRP

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X