BeyondERP.Newsletter
Menu

Setup step on the Statistics page · Time and attendance

Read and adjust one worker's balance

Read the page to answer one question about registrations or pay.

Used by
Payroll administrator, Payroll manager
Business process
Pay employees
Menu item
JmgPayStatTrans
Main table
JmgPayStatTrans
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 isAn 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 hereUse this page to view workers' statistical payroll balances; balances can be adjusted and recalculated when the setup changes.
ExampleFor 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.
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.

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

  1. Go to Time and attendance > Inquiries and reports > Payroll > Statistics.
  2. Use the Filter box to find a worker.
  3. On the Overview tab, review Pay type, Payroll statistics group, From date, To date, Opening balance, Change, Adjustment and Pay time.
  4. Select Edit and then Set adjustment to adjust a selected row.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExample
Pay typeThe pay type the balance counts.Microsoft Learn 5151-1
Payroll statistics groupThe group that totals the pay type over a period.Microsoft Learn VAC
From date / To dateThe period the balance covers, from the group's period type.Microsoft Learn
Opening balanceThe balance at the start of the period, set with Adjust payroll statistics or Set adjustment.Microsoft Learn
AdjustmentManual adjustments made with Set adjustment for this worker.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

Test checklist

  1. Add a manual premium of 10 on VAC.
  2. Approve one vacation day.
  3. Check the VAC balance is 9 here.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Read and adjust one worker's balanceFilter 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.Adjust balances per worker or per group?Adjusting one worker here when the whole group needs the same change.Test: Read and adjust one worker's balance

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, Payroll manager. 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. Checked in Dynamics 365
Can it be undoneReversible: The report or inquiry only reads data; nothing is changed.
If you change it laterIf the setup of a payroll statistic changes, the worker balances for that statistic must be recalculated. Microsoft Learn
Technical architect

6Technical

Menu itemJmgPayStatTrans Checked in Dynamics 365
FormJmgPayStatTrans Checked in Dynamics 365
TableJmgPayStatTransShown as “PAYROLL STATISTICS” in Record infoChecked in Dynamics 365
Who can open itPrivilegesView payroll statistics transactions JmgPayStatTransViewDutiesMaintain time and attendance payroll adjustments JmgTimeAttendancePayrollAjustMaintainMaintain time and attendance payroll JmgTimeAttendancePayrollMaintainInquire into time and attendance payroll data JmgTimeAttendancePayrollProgressInquire
2 security rolesPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManager
Checked in Dynamics 365
Roles to set it up and use itTo 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 URLhttps://<your-environment>/?mi=JmgPayStatTrans
Data migrationLoad 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
Table definitionJmgPayStatTrans columns and relations Microsoft data model
Everyone

8Sources

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