Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
servicemanagement_creating_labor_8145
servicemanagement_creating_labor_8145
You can create labor rate groups based on pay code and position or based on pay code, position, and department. When you use pay code, position, and department, you create overhead groups and associate the overhead group with the labor rate group. Overhead groups are created in Service Management or Job Cost and are shared between the products.

Note

You must mark the setup option in the Service Management Service Options window to use overhead amounts from Job Cost. See Choosing service optionsService Options.

When you create labor rate groups, you are doing two things: establishing labor billing amounts and adding an overhead amount to the Microsoft Dynamics GP pay rate.

...

  1. Choose Microsoft Dynamics GP > Tools > Setup > Service Management > Invoice Setup > Labor Rates.
  2. Complete the following fields.
    • Labor Rate Group Name: Create
      Create a name for the labor rate group.
    • Position: Use
      Use the lookup window to select the position to which this labor rate should apply.
    • Pay Code: Pay
      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. For example, a Preferred labor group may have an overtime rate and a regular time rate for technicians, supervisors, and helpers. 

      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
      Enter a description. For example, Supervisor - Regular or Supervisor - Overtime would differentiate one pay code from another.
    • Fixed OH per Hour: The
      The fixed overhead per hour is a flat amount charged to recoup overhead costs such as union fringe benefits paid per hour.The amount appears in the Extended Cost + Overhead field of the Added Costs window for labor. It constitutes the overhead portion of the amount - the extended portion is the pay rate multiplied by the number of hours.
    • OH Percentage: The
      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. The OH Percentage field can contain up to five numbers.The amount appears in the Extended Cost + Overhead field of the Added Costs window for labor. It constitutes the overhead portion of the amount - the extended portion is the pay rate multiplied by the number of hours.
    • Billing Amount: The
      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.

...

Note

You must mark the setup option in the Service Options window to use overhead amounts from Job Cost. Without marking this setup option, you will not see the Overhead Detail Code window or the Overhead Group Setup window as specified in the following steps. See Choosing service optionsService Options.

Step 1: Create overhead detail codes.

Overhead detail codes define how overhead amounts are calculated based on payroll costs. You can recognize indirect labor costs, not typically set up as cost codes on an hourly or piecework basis, as overhead. These costs are added to posted amounts for the details and are not identified separately on customer invoices.

  1. Choose Microsoft Dynamics GP > Tools > Service Management > Invoice Setup > Labor Rates > Overhead Detail Code.
  2. Complete the following fields, as necessary.
    • Overhead Code, Description: Enter
      Enter a name and description for the code.
    • Allocation Method: From
      From the drop-down list, assign a method of calculating overhead for the detail code. Enter an amount in one of the following fields, depending on the option you chose.
    • Fixed Portion: Allows
      Allows you to allocate overhead for payroll transactions on a cost-per-unit basis. For example, if you want to apply hourly overhead to account for the cost of travel to and from a job site, you could add $1.50 per hour (the unit of measure) with an overhead detail code.
    • Percent Portion: Allows
      Allows you to allocate overhead for payroll transactions on a percentage basis. For example, you can set up an overhead detail code for the cost of taxes incurred on an employee's pay rate, that adds 16 percent of the wages.
  3. Choose Save.
Note

If you modify the overhead detail codes in the future, posted transactions will not be affected.

Step 2: Create overhead groups.

Overhead group codes organize overhead detail codes logically per departments, positions, and pay codes. For example, you could set up detail codes for hourly compensation, overhead and travel time. These details can be combined under a group code named Hour. The group code is applied to technicians assigned to the installation department.

  1. Choose Microsoft Dynamics GP > Tools > Service Management > Invoice Setup > Labor Rates > Overhead Group Setup.
  2. Complete the following fields, as necessary.
    • Overhead Group, Description: Use
      Use the Tab key to move from the name to the description.
    • Department, Position, Pay Code: You
      You can enter All in each of these fields. 

      Note

      Facilitating setup by using All: Since
      Since the number of combinations of department, position, and pay code for a given overhead group code can become quite large, you can facilitate the setup by entering the word All in any of those fields. For example, if all departments, all positions, and all pay codes have a general overhead detail code, All could be used with each of those items. If a specific combination of department, position, and pay code has a unique detail code, that combination will be used along with any All combinations for the overhead group that match the same criteria. For example, if the administration department, CEO position, and salary pay code combination had a special bonus overhead detail code, and the All departments, CEO position, and All pay codes combination also had a bonus overhead detail code, both detail codes would be used.


    • Detail Code: Use
      Use the lookup to select the detail code.
  3. Choose Save.
Note

Overhead groups should be set up with different combinations of department, position, and pay code. For example, the combination of SRV, ENG, and HOUR should not appear in more than one overhead group.

Step 3: Create labor rate groups.

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.

...