BeyondERP.Newsletter
Menu

Setup step on the People by department report page · Human resources

List staff by department as of a date

Produce the staff list of each department for a given date.

Business process
Develop people strategy
Menu item
HRMPeopleDepartment
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 isA report that prints the workers of each department as of a date, placed in departments through their position assignments, with contractors optional.
What you do hereUse this page to print a list of workers by department.
ExampleFor example, BEAT prints the report as of January 31, 2027 with Include contractors set to No and gets 11 employees under Sales; a contractor working in Sales appears only when Include contractors is Yes.
People by department 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

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 a manager or HR needs a list of who works in each department on a given date, for example before a reorganization or a department meeting.
How oftenOn demand, when you need a current or past staff list by department.
What the output showsWorkers grouped by department as of the date you entered. A worker who is missing usually has no position assignment on that date, or is a contractor while Include contractors is off.

Source: Microsoft Learn

Setup steps on this page

List staff by department as of a date

Produce the staff list of each department for a given date.

Steps from Microsoft

  1. Go to Human resources > Departments > People by department report.
  2. Under Parameters, enter the As of date. Workers are placed in departments through their position assignment on that date.
  3. Set Include contractors to Yes to list contractors as well as employees, or No to list employees only.
  4. In Records to include, filter on one or more departments if you only need part of the company.
  5. Read the workers under each department and look for people who appear in the wrong department or not at all.

Source: Microsoft Learn

Common errors and fixes

MessageWhat to do
A worker is missing from every departmentThe worker has no position assignment on the As of date, or is a contractor and Include contractors is No. Assign a position or include contractors. Microsoft Learn

Test checklist

  1. Assign an employee and a contractor to positions in one department.
  2. Run the report with Include contractors No, then Yes.
  3. Check the first run lists one worker and the second lists two.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
List staff by department as of a dateSet the As of date first, then Include contractors; run it per department when a department meeting or reorganization needs the list.Workers are placed in departments only through their position assignment on that date.Should contractors be on department lists?Reading a missing worker as a leaver: a worker with no position assignment on the date, or a contractor, simply isn't printed.Test: As of date drives the list

Feature management and licence

Licence or add-inOn BEAT the page is run by Human resource manager, Human resource assistant, Compensation and benefits manager, Recruiter and Payroll administrator; the full list is under the page's security roles. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared data: positions and departments are shared by all companies (Data management lists Positions V2 and Operating unit as shared). Checked in Dynamics 365
Can it be undoneNothing to undo: The report reads data and changes nothing.
If you change it laterWorkers are placed in departments through their position assignment on the As of date, so a transfer prints under the new department only for dates from the new assignment. Microsoft Learn
Technical architect

6Technical

Menu itemHRMPeopleDepartment Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itHuman resource manager HcmHumanResourceManagerHuman resource assistant HcmHumanResourceAssistantCompensation and benefits manager HcmCompensationAndBenefitsManagerRecruiter HcmRecruiterPayroll administrator HcmPayrollAdministratorGive people one of these roles. On this system, 9 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=HRMPeopleDepartment
Data migrationLoad order: The People by department report has no data entity in Data management, so it can't be loaded from a file or a configuration template. It prints worker and position data; load positions and Position worker assignments V2, then run the report in each environment.Microsoft Learn
Everyone

8Sources

To cite this step: HR-RORG-110, List staff by department as of a date. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/HR-RORG-110