SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
An inquiry page for payroll statistics, which summarise one or more pay types over a period so that you can see how workers' pay builds up for wage types such as standard time and overtime.
What you do here
Use this page to view workers' statistical payroll balances; balances can be adjusted and recalculated when the setup changes.
Example
For example, worker 000496 has a VAC vacation balance of 10 days from a manual premium; after one vacation day is approved and transferred, this page shows 9 days.
The page in Dynamics 365. page title tab to open what to set or check
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
Read and adjust one worker's balance
Read the page to answer one question about registrations or pay.
How to use it
Go to Time and attendance > Inquiries and reports > Payroll > Statistics.
Use the Filter box to find a worker.
On the Overview tab, review Pay type, Payroll statistics group, From date, To date, Opening balance, Change, Adjustment and Pay time.
Select Edit and then Set adjustment to adjust a selected row.
The group that totals the pay type over a period.Microsoft Learn
VAC
From date / To date
The period the balance covers, from the group's period type.Microsoft Learn
Opening balance
The balance at the start of the period, set with Adjust payroll statistics or Set adjustment.Microsoft Learn
Adjustment
Manual adjustments made with Set adjustment for this worker.Microsoft Learn
Common errors and fixes
Message
What to do
The payroll statistics balance doesn't change after an adjustment
A 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
Filter on the worker and the payroll statistics group, such as the vacation balance.Statistics total one or more pay types over a period, such as vacation days.
Time 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, Payroll manager. The Microsoft Learn article for this page names no Feature management feature to turn on.
Per company: each legal entity has its own payroll statistics. Checked in Dynamics 365
Can it be undone
Reversible: The report or inquiry only reads data; nothing is changed.
If you change it later
If the setup of a payroll statistic changes, the worker balances for that statistic must be recalculated. Microsoft Learn
Technical architect
6Technical
Menu item
JmgPayStatTransChecked in Dynamics 365
Form
JmgPayStatTransChecked in Dynamics 365
Table
JmgPayStatTransShown as “PAYROLL STATISTICS” in Record infoChecked in Dynamics 365
Who can open it
PrivilegesView payroll statistics transactions JmgPayStatTransViewDutiesMaintain time and attendance payroll adjustments JmgTimeAttendancePayrollAjustMaintainMaintain time and attendance payroll JmgTimeAttendancePayrollMaintainInquire into time and attendance payroll data JmgTimeAttendancePayrollProgressInquire2 security rolesPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManagerChecked in Dynamics 365
Roles to set it up and use it
To use itPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the page
(Action Pane without tabs): Set adjustmentChecked in Dynamics 365
Developer
7Developer
Open it by URL
https://<your-environment>/?mi=JmgPayStatTrans
Data migration
Load order: A payroll statistics balance has no data entity in Data management, so it can't be loaded from a file or a configuration template. Load opening balances with Adjust payroll statistics (Opening balance).Microsoft Learn
Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.
To cite this step: TA-INQ-100, Read and adjust one worker's balance. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/TA-INQ-100