BeyondERP.Newsletter
Menu

Report page · Human resources

Certificate expirations

A report that lists worker certificates that have expired or are about to expire.

Business process
Track skills and competencies
Menu item
HRMDueCertificate
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 lists worker certificates that have expired or are about to expire.
What you do hereUse this page to find certificates whose end date has passed or is coming up, so they can be renewed.
ExampleFor example, on the first working day of each month HR runs the report for Expires within 60 days and certificate type First aid, finds 5 certificates lapsing in December and books those workers on the next first aid course.
Certificate expirations 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 manage certificates as competencies, for example to plan renewal training for a certificate type.
How oftenOn demand, for example monthly, and before training is planned.
What the output showsCertificates that have expired or will expire in the range. Compare it with the Expiring records tab of the Personnel management workspace; a difference usually comes from the number of days set in the parameters.

Source: Microsoft Learn

Setup steps on this page

Plan certificate renewals

Find certificates that lapse soon and plan renewal training.

Steps from Microsoft

  1. Go to Human resources > Competencies > Reports > Certificate expirations.
  2. Choose Expiration period and set Expires within, for example 30 days, to see what is about to lapse; choose Expiration range for fixed From and To dates.
  3. Turn on Require renewal to leave out certificates that never need renewal.
  4. In Records to include, filter on the certificate type, for example one safety certificate.
  5. Plan renewals per certificate type. This is the same report as under Workers, opened from the competency side.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Expires withinLists certificates that expire within this number of days (with Expiration period chosen).Checked in Dynamics 36560 days
Require renewalLeaves out certificates whose type doesn't need renewal.Checked in Dynamics 365Yes

Common errors and fixes

MessageWhat to do
A certificate known to expire is missingThe end date on a person's certificate is the date it expires and is optional, so a certificate without one never lapses; Require renewal also leaves out types that don't need renewal. Enter the end date and check the certificate type. Microsoft Learn
The workspace tab and the report show different certificatesThe tab uses the Expiring records days on Human resources parameters; the report uses the range you enter. Use the same number of days in both. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Plan certificate renewalsRun it monthly with Expires within set to at least the lead time of the renewal course, Require renewal on, one certificate type at a time.Certificate types record whether renewal is required and each certificate's end date is its expiry, so a range longer than the course lead time leaves time to book.How far ahead should HR look?Reading 'not on the report' as 'valid': certificates entered without an end date never appear.Test: Expiring certificate is listed

Feature management and licence

Licence or add-inHR and training staff run it when they plan development, training and succession for current workers. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared data: certificate types and people's certificates (Certificate competency) are shared in Data management, so the report reads the same certificates from any legal entity. Checked in Dynamics 365
Can it be undoneNothing to undo: The report only lists certificates; it changes nothing. Microsoft Learn
If you change it laterThe Expiring records tab of the Personnel management workspace lists expiring certificates for the number of days set on Human resources parameters; this report uses the range you enter, so the two lists differ when the days differ. A value of 0 in the parameters shows nothing on the tab. Microsoft Learn
Technical architect

6Technical

Menu itemHRMDueCertificate Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itHuman resource manager HcmHumanResourceManagerCompensation and benefits manager HcmCompensationAndBenefitsManagerRecruiter HcmRecruiterPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManagerGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=HRMDueCertificate
Data migrationLoad order: The Certificate expirations report has no data entity in Data management, so it can't be loaded from a file or a configuration template. It lists people's certificates; load certificate types and Certificate competency with the Employee development template and run the report in each environment.Microsoft Learn
Everyone

8Sources