BeyondERP.Newsletter
Menu

Report page · Time and attendance

Payroll statistics report

A report that prints workers' payroll statistics balances and transactions per pay type, such as a vacation balance.

Business process
Pay employees
Menu item
JmgReport_PayStatTrans
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 report that prints workers' payroll statistics balances and transactions per pay type, such as a vacation balance.
What you do hereUse it after payroll statistics are recalculated or adjusted, or when a worker asks about a balance.
ExampleFor example, after a manual premium of 10 vacation days and one vacation day taken, the report shows a VAC balance of 9 days for worker 000496.
Payroll statistics report 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 › Inquiries and reports › Payroll › Payroll statistics report
Set up firstAdjust payroll statistics Microsoft Learn
Used next byStatistics Microsoft Learn
Related pagesPayroll statistics groups 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 payroll statistics are recalculated or adjusted, or when a worker asks about a balance such as vacation hours.
How oftenOn demand, typically after each balance change.
What the output showsPayroll statistics transactions and balances per worker and pay type. A balance that differs from expectation usually means an adjustment was made on the wrong date or the statistic was not recalculated after a setup change.

Source: Microsoft Learn

Setup steps on this page

Check balances after a change

Print the report with the choices that answer one question.

Steps from Microsoft

  1. Go to Time and attendance > Inquiries and reports > Payroll > Payroll statistics report.
  2. Set New page per worker when the report goes to individual workers or files.
  3. Limit the report to a payroll statistics group or to selected workers.
  4. Print it after Recalculate payroll statistics or Adjust payroll statistics and compare each balance with the expected value.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
New page per workerStarts each worker on a new page, for handing out or filing.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
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check balances after a changePrint it after each recalculation or adjustment, per payroll statistics group.It shows each worker's balance per pay type, such as vacation days.Print per group or per worker?Reading a balance before Recalculate payroll statistics has run after a setup change.Test: Check balances after a change

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, Payroll manager, Chief executive officer. 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 undoneNothing to undo: The statistics report only reads balances; nothing is changed. Microsoft Learn
If you change it laterThe report changes no data; balances change with Adjust or Recalculate payroll statistics. Microsoft Learn
Technical architect

6Technical

Menu itemJmgReport_PayStatTrans Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManagerChief executive officer CompanyChiefExecutiveOfficerRetail store manager RetailStoreManagerRetail service RetailServiceGive people one of these roles. On this system, 5 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=JmgReport_PayStatTrans
Data migrationLoad order: The Payroll statistics report report has no data entity in Data management, so it can't be loaded from a file or a configuration template. It only prints data; set up its batch printing again if it is scheduled.Checked in Dynamics 365
Everyone

8Sources