BeyondERP.Newsletter
Menu

Setup step on the Pay types page · Time and attendance

Set up Pay types

Use this page to set up pay types and their rates, or pay types that count a balance, such as vacation days, instead of pay.

Used by
Payroll administrator
Business process
Manage time and attendance
Menu item
JmgPayTable
Main table
JmgPayTable
Data entity
JmgPayTypeEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you create the pay types that pay agreements use to calculate different kinds of pay, with rates for date intervals and, if needed, individual worker rates.
What you do hereUse this page to set up pay types and their rates, or pay types that count a balance, such as vacation days, instead of pay.
ExampleFor example, you create a pay type that is not included in the export and use it to count each worker's earned vacation days.
Pay types page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Pay types

Use this page to set up pay types and their rates, or pay types that count a balance, such as vacation days, instead of pay.

Steps from Microsoft

  1. Go to Time and attendance > Setup > Payroll > Pay types.
  2. Select New.
  3. Enter a value in the Pay type field and a description.
  4. Select Save.
  5. Select Rates, then select New.
  6. In the Rate field, enter the rate and save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
ReferenceAn existing pay type that this pay type's rate is calculated from.Microsoft Learn RefPayCostType
Rate / Percent (Rates)The rate for a date interval, or a percentage of the reference pay type.Microsoft Learn
Pay raise method (Change pay)How a new rate period raises the rate: by an amount, by a percentage or as a new rate.Microsoft Learn

Common errors and fixes

MessageWhat to do
A counter pay type appears in the pay fileSet Include in export = No on pay types that only count, such as vacation days. Microsoft Learn

Test checklist

  1. Create a pay type, select Rates and add a rate for the current date interval.
  2. Use it on a pay agreement line for Standard time.
  3. Approve and transfer a worker's day and check the pay item uses the pay type and rate.
  4. Create a counter pay type with Include in export = No and check it doesn't appear in the pay export.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Pay typesPay types for each kind of pay used in agreements; rates only where Time and attendance must value pay (for example job cost), and Include in export = No for counter pay types such as vacation balancesLearn notes rates are not always needed because the payroll system may hold them, and uses a pay type with Include in export = No to count a vacation balance instead of pay.Which pay types are exported?Leaving Include in export on for a balance counter. It then goes out in the pay file as if it were pay.Test: Counter pay type not exported

Feature management and licence

Licence or add-inTime and attendance roles come from the security read in the Technical section. On this system the page is opened with roles such as Payroll administrator. The Microsoft Learn article for this page names no Feature management feature to turn on.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own pay types. Checked in Dynamics 365
Can it be undoneReversible: Pay types and rates are used when registrations are transferred, so changes affect later transfers; rates are kept per date interval.
If you change it laterWhen you raise a rate for a new period, the worker-specific rates linked to it are raised automatically as well. Microsoft Learn
Technical architect

6Technical

Menu itemJmgPayTable Checked in Dynamics 365
FormJmgPayTable Checked in Dynamics 365
TableJmgPayTableShown as “PAY TYPES” in Record infoChecked in Dynamics 365
Data entitiesJmgPayTypeEntityPay types Microsoft data model
Who can open itPrivilegesMaintain pay types JmgPayTableMaintainView pay types JmgPayTableViewDutiesMaintain pay agreement master JmgPayAgreementMasterMaintainInquire into time and attendance payroll policies JmgTimeAttandancePayrollPoliciesInquireMaintain time and attendance payroll adjustments JmgTimeAttendancePayrollAjustMaintainMaintain time and attendance payroll JmgTimeAttendancePayrollMaintainEnable time and attendance payroll process JmgTimeAttendancePayrollProcessEnableInquire into time and attendance payroll reference data JmgTimeAttendancePayrollRefDataInquire
1 security rolePayroll administrator HcmPayrollAdministrator
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itPayroll administrator HcmPayrollAdministratorGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Rates, StatisticsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=JmgPayTable
Integrate withJmgPayTypeEntity data entity Microsoft data model
Data migrationJmgPayTypeEntity (Pay types): loaded for each company, in Microsoft's default template 410 - Production control.Load order: Microsoft's default template 410 - Production control loads Pay types at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionJmgPayTable columns and relations Microsoft data model
Everyone

8Sources