BeyondERP.Newsletter
Menu

Setup step on the Adjust payroll statistics page · Time and attendance

Load or correct a group's payroll statistics

Set opening balances or apply one correction to all workers of a payroll statistics group.

Business process
Pay employees
Menu item
JmgPayStatAdjustBalance
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 periodic page that adjusts statistical payroll balances for all workers in a payroll statistics group for one pay type and date.
What you do hereUse this page to set an opening balance, set the current balance, or add an adjustment to the payroll statistics of several workers at once.
ExampleFor example, entering 2 with the Adjustment type adds two hours to the payroll balances of all workers in the selected payroll statistics group.
Adjust 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

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 itWhen you take over balances from a previous system, or when a group of workers needs the same correction, such as extra vacation hours.
How oftenOn demand, when a group-wide balance correction or opening balance is needed.
What the output showsUpdated statistical payroll balances for every worker in the group for the pay type and date. If a worker's balance didn't change, no payroll record usually exists for that worker on the date.

Source: Microsoft Learn

Setup steps on this page

Load or correct a group's payroll statistics

Set opening balances or apply one correction to all workers of a payroll statistics group.

Steps from Microsoft

  1. Go to Time and attendance > Maintain payroll > Adjust payroll statistics.
  2. In Payroll statistics group, select the group of workers to adjust, and in Pay type the balance to change.
  3. In Date, enter the adjustment date. A payroll record must exist for that date.
  4. In Adjustment type, choose Opening balance to set the opening balance to the value, Balance to set the current balance to the value, or Adjustment to add the value to the payroll record on the date.
  5. In Value, enter the number of hours, for example 2 to add two hours with Adjustment, and run the job. Print the Payroll statistics report to see the result for each worker.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Payroll statistics groupThe group of workers whose balances are adjusted.Microsoft Learn VAC
Pay typeThe pay type whose balance is adjusted.Microsoft Learn 5151-1
DateThe date of the adjustment. A payroll record must exist for that date.Microsoft Learn
Adjustment typeOpening balance sets the opening balance to the value, Balance sets the current balance to the value, and Adjustment adds the value to the payroll record on the date.Microsoft Learn Adjustment
ValueThe number of hours applied according to the adjustment type.Microsoft Learn 2

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 balance is twice what it should beAdjustment always adds to the balance. To set a figure, use Balance or Opening balance instead of running Adjustment again. Microsoft Learn

Test checklist

  1. Payroll statistics for two workers in the group show the new value on the date.
  2. With Adjustment, each balance changed by exactly the entered number of hours.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Load or correct a group's payroll statisticsOpening balance on the go-live date for balances taken over from the old system; Adjustment only for a one-off correction that applies to everyone in the group.Opening balance and Balance set the figure; Adjustment adds to it, and a payroll record must exist on the date.How are opening balances brought over at go-live?Running Adjustment twice, so the hours are added twice.Test: Add two hours to a group

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 undoneHard to reverse: No reversal; run again with Balance or Opening balance to set the correct figure.
If you change it laterChanges the statistical payroll balance of one pay type for all workers in the payroll statistics group. An adjustment can only be made for a date on which a payroll record exists. Microsoft Learn
Technical architect

6Technical

Menu itemJmgPayStatAdjustBalance 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=JmgPayStatAdjustBalance
Data migrationLoad order: Adjust payroll statistics has no data entity in Data management, so it can't be loaded from a file or a configuration template. Use the job itself to load opening balances, such as vacation hours, with Opening balance on the go-live date.Microsoft Learn
Everyone

8Sources

To cite this step: TA-PAY-040, Load or correct a group's payroll statistics. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/TA-PAY-040