BeyondERP.Newsletter
Menu

Setup page · Time and attendance

Payroll statistics groups

A setup page where you define payroll statistics groups that total one or more pay types over a period, to give statistics for worker registrations.

Used by
Payroll administrator
Business process
Manage time and attendance
Menu item
JmgPayStatGroup
Main table
JmgPayStatGroup
Data entity
None for this page's own settings
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define payroll statistics groups that total one or more pay types over a period, to give statistics for worker registrations.
What you do hereUse this page to set up running totals, such as hours by wage type or a vacation balance, from the pay types in each group over a period type.
ExampleFor example, you set up a group that totals a vacation-day pay type over the vacation year to calculate the vacation days each worker earns.
Payroll statistics groups 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

Business processManage time and attendance
Menu pathTime and attendance › Setup › Payroll › Payroll statistics groups
Set up firstPay types Microsoft Learn Period types Microsoft Learn
Used next byStatistical balance setup Microsoft Learn
Related pagesStatistics Microsoft Learn
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 Payroll statistics groups

Use this page to set up running totals, such as hours by wage type or a vacation balance, from the pay types in each group over a period type.

Steps from Microsoft

  1. Go to Time and attendance > Setup > Payroll > Payroll statistics groups.
  2. Select New.
  3. Enter the payroll statistics group, a description and the Transfer setting.
  4. Select Setup.
  5. Select New and select the pay type.
  6. Set the Period code field to the period type to use.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
TransferCarries the closing balance of one pay period forward as the opening balance of the next.Microsoft Learn Transfer
Period code (Setup)The pay period over which the pay type is summarized.Microsoft Learn

Common errors and fixes

MessageWhat to do
A balance ignores old registrationsRecalculate payroll statistics after changing the group's setup. Microsoft Learn

Test checklist

  1. Create a pay type for the balance with Include in export = No and add it to the pay agreement for the vacation absence code.
  2. Create a payroll statistics group with Transfer = No, add the pay type on Setup, and set a yearly period code with generated periods.
  3. Link the group in Statistical balance setup.
  4. Grant a starting balance with a manual premium, register one vacation day and transfer on the Approve page.
  5. Open My day in production floor execution and check the balance dropped by one day.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Payroll statistics groupsOne group per balance you track, with Transfer = No when the group only feeds a balance (such as vacation days) and a period code whose periods match the balance yearLearn's vacation balance example uses a payroll statistics group with Transfer = No and a yearly period code so it counts days earned and used in the vacation year.Are statistics exported?Creating the group but not linking it in Statistical balance setup: the balance then doesn't show in the My day dialog box of the production floor execution interface.Test: Vacation balance group

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 payroll statistics groups. Checked in Dynamics 365
Can it be undoneReversible: Change the group and recalculate.
If you change it laterChanging a group's pay types changes the balances only after Recalculate payroll statistics runs. Microsoft Learn
Technical architect

6Technical

Menu itemJmgPayStatGroup Checked in Dynamics 365
FormJmgPayStatGroup Checked in Dynamics 365
TableJmgPayStatGroupShown as “PAYROLL STATISTIC GROUPS” in Record infoChecked in Dynamics 365
Data entitiesJmgTimeAndAttendanceTimeRegistrationWorkerEntityTime and attendance registration workers (only the time registration workers; payroll statistics groups have no data entity) Checked in Dynamics 365
Who can open itPrivilegesMaintain payroll statistics JmgPayStatGroupMaintainView payroll statistics JmgPayStatGroupViewDutiesInquire into time and attendance payroll policies JmgTimeAttandancePayrollPoliciesInquireEnable 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): Setup, StatisticsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=JmgPayStatGroup
Data migrationLoad order: A payroll statistics group has no data entity in Data management, so it can't be loaded from a file or a configuration template. Re-create the groups by hand in each environment, then load opening balances with Adjust payroll statistics.Checked in Dynamics 365
Table definitionJmgPayStatGroup columns and relations Microsoft data model
Everyone

8Sources