Time and attendanceInquiries and reportsAbsence reports
JmgAbsenceColumn
Business process
Record employee absences
Menu item
JmgAbsenceColumn
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 is
A report that prints a grid of workers and days for a period, with the absence registered on each day.
What you do here
Use it to check absence day by day for a period, for example before payroll is transferred.
Example
For example, on a profile with standard time until 15:00 and Flex- from 15:00 to 16:00, a worker who clocks out at 14:30 has 1.5 hours of absence from 14:30 to 16:00, which shows in that day's cell.
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.
When to run it
When to run it
When you need a day-by-day absence grid for a period, for example to check absence before payroll is transferred.
How often
On demand, usually once per pay period.
What the output shows
A grid of workers and days in the period with the absence registered on each day. An empty cell on a day the worker was away means the absence was never registered or calculated.
Absence shows absence codes in the column headings; Weekday shows the weekday for each date.Microsoft Learn
Absence
Common errors and fixes
Message
What to do
The calculation shows an error for a missing absence registration
Add the absence on the Absence tab of the Calculate page for the worker, then select Calculated again. A calculation with an error can't be approved. Microsoft Learn
Print it per pay period with Absence as the column heading.It shows each worker's absence day by day, so a missing or wrong absence code is seen before pay is transferred.
Time and attendance roles come from the security read in the Technical section. On this system access comes from duties such as Production supervisor, Manager. The Microsoft Learn article for this page names no Feature management feature to turn on.
Per 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 undone
Reversible: The report or inquiry only reads data; nothing is changed.
If you change it later
The report changes no data; absence is changed on the Calculate or Approve page. Microsoft Learn
Technical architect
6Technical
Menu item
JmgAbsenceColumnChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To use itProduction supervisor ProdProductionSupervisorManager HcmManagerGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer
7Developer
Open it by URL
https://<your-environment>/?mi=JmgAbsenceColumn
Data migration
Load order: The Absence form 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