BeyondERP.Newsletter
Menu

Job page · Time and attendance

Recalculate payroll statistics

A periodic job that recalculates statistical payroll balances for a group of workers.

Business process
Pay employees
Menu item
JmgPayStatCalculate
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 periodic job that recalculates statistical payroll balances for a group of workers.
What you do hereUse this page to recalculate workers' payroll statistics balances for a payroll statistics group, pay type, and optionally a pay period.
ExampleFor example, after pay type 5151-1, Counter for worker vacation days, is added to payroll statistics group VAC, the payroll administrator recalculates VAC for that pay type so each worker's vacation balance includes the days already registered.
Recalculate payroll statistics 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 compensation and benefits › Pay employees
Menu pathTime and attendance › Maintain payroll › Recalculate payroll statistics
Set up firstPayroll statistics groups Microsoft Learn
Used next byPayroll statistics report Microsoft Learn
Related pagesAdjust payroll statistics 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.

When to run it

When to run itAfter the setup of a payroll statistic changes, so that balances that were built under the old setup are recalculated.
How oftenOn demand, when payroll statistics setup changes.
What the output showsRecalculated statistical payroll balances for the pay type and workers in the group, for example vacation hours. A balance that doesn't change usually means the wrong pay type or Period code was chosen.

Source: Microsoft Learn

Setup steps on this page

Rebuild a payroll statistic after its setup changes

Recalculate one pay type's statistic for a payroll statistics group.

Steps from Microsoft

  1. Go to Time and attendance > Maintain payroll > Recalculate payroll statistics.
  2. In Payroll statistics group, select the group of workers whose statistics you want to recalculate.
  3. In Pay type, select the pay type whose statistical balance must be rebuilt.
  4. If the recalculation should only cover one pay period, select it in Period code; leave it empty to recalculate the whole balance.
  5. Run the job, then open Payroll statistics for a worker in the group, or print the Payroll statistics report, to see the new balance.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Payroll statistics groupThe payroll statistics group to recalculate.Microsoft Learn
Pay typeThe pay type to recalculate.Microsoft Learn
Period codeThe pay period to recalculate, if needed.Microsoft Learn

Common errors and fixes

MessageWhat to do
The payroll statistics balance doesn't change after an adjustmentA payroll record must exist for the date of the adjustment. Pick a date with a payroll record for the workers and run the adjustment again. Microsoft Learn
A worker is missing from the report or jobThe worker isn't set up as a time registration worker, isn't active, or falls outside the query. Check the worker on Time registration workers and the query of the dialog. Microsoft Learn

Test checklist

  1. Payroll statistics for a sample worker show the recalculated balance for the pay type.
  2. Workers outside the group are unchanged.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Rebuild a payroll statistic after its setup changesRun it per payroll statistics group and pay type right after the statistic's setup changes, leaving Period code empty to rebuild the whole balance.Balances built under the old setup stay wrong until they are recalculated.Rebuild the full balance or one period?Entering a Period code and expecting the whole balance to be rebuilt.Test: Vacation statistic rebuilt

Feature management and licence

Licence or add-inTime and attendance roles come from the security read in the Technical section. On this system access comes from duties 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: Time and attendance data is kept per legal entity (every Time and attendance entity in Data management is per company), so the job or report works on the registrations of the company it is run in. Microsoft Learn
Can it be undoneNo undo needed: The balances are rebuilt from existing payroll records; run the job again after fixing the setup if the result is wrong. Microsoft Learn
If you change it laterRebuilds the statistical payroll balance of one pay type for all workers in the payroll statistics group. Microsoft Learn
Technical architect

6Technical

Menu itemJmgPayStatCalculate Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itPayroll administrator HcmPayrollAdministratorGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=JmgPayStatCalculate
Data migrationLoad order: Recalculate payroll statistics has no data entity in Data management, so it can't be loaded from a file or a configuration template. It rebuilds balances from loaded payroll records; load opening balances with Adjust payroll statistics first.Microsoft Learn
Everyone

8Sources