BeyondERP.Newsletter
Menu

Setup step on the Project payroll allocation page · Project management and accounting

Set the selection for Project payroll allocation

Get payroll allocation per project that can be checked against the ledger or the budget.

Business process
Analyze project performance
Menu item
output:ProjListProjPayRollProj
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 totals the hour cost posted against the payroll allocation account per project, with the hours behind it, for a project date and ledger date range.
What you do hereUse it at period close to see how much payroll cost each project absorbed and to explain the payroll allocation account.
ExampleBEAT's project accountant closes October 2026 with ledger dates 2026-10-01 to 2026-10-31: PRJ-0042 shows 31.00 hours and 1,240.00 of payroll allocation, the same 1,240.00 that was credited to the payroll allocation account for that project.
Project payroll allocation 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 itAt period end, after hour journals and timesheets for the period are posted, to see how much payroll cost was allocated to each project.
How oftenOn demand, at each period close or when a project manager asks for the payroll cost on a project.
What the output showsOne row per project (grouped by the Project view you chose) with the payroll allocation amount and, depending on Show hour, the hours, the cost of the hours or both. A project with too little cost usually has hour transactions dated outside the range or posted to another project.

Source: Microsoft Learn

Setup steps on this page

Set the selection for Project payroll allocation

Get payroll allocation per project that can be checked against the ledger or the budget.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Payroll allocation reports > Project payroll allocation.
  2. Under Include project types, turn on Time and material, Fixed-price, Investment or Internal and cost for the projects whose payroll allocation you want to analyze.
  3. Enter the From date and To date under Project date and Ledger date; the project date range selects the hour transactions, the ledger date range the postings.
  4. Under Data, keep Actual vs. budget on actual values to see posted payroll allocation per project, or pick budgeted values and a Forecast model.
  5. Under Layout - rows, set Project view (for example project group or customer) and Project level for the subproject depth, then run the report and check the totals per project.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Include project typesChoose which project types the report covers.Microsoft Learn
Actual vs. budgetChoose whether the report shows actual values or budgeted values.Microsoft Learn
Forecast modelChoose the forecast model that supplies the budget figures; with project budget control, use the project's budget forecast model.Microsoft Learn
Project viewChoose how the first column of the report is grouped, for example by project group or customer.Microsoft Learn
Project levelSet how many levels of subprojects the report shows.Microsoft Learn
Skip blank IDLeave out transactions that have no ID for the grouping the report uses.Microsoft Learn
Skip zeroLeave out rows where the amounts are zero.Microsoft Learn
Show amountChoose how amounts are shown, such as with decimals, without decimals, or in thousands or millions.Microsoft Learn
Show hourChoose whether to show the number of hours, the cost value of the hours, or both.Microsoft Learn

Common errors and fixes

MessageWhat to do
A project with posted hours shows no payroll allocation amount.Check the project cost and revenue profile of the project: with Post costs - hour set to No ledger or Never ledger the hour cost is not posted against the payroll allocation account. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set the selection for Project payroll allocationUse the ledger date range of the closed period and keep Actual vs. budget on actual values.Posting an hour credits the payroll allocation account with its cost on the ledger date, so a ledger date range makes the report total comparable with the account.Which date range selects the payroll allocation?Expecting every hour to have a ledger amount: hours on projects whose cost and revenue profile posts hour cost to No ledger or Never ledger make no payroll allocation entry in the ledger.Test: Project payroll allocation shows posted hour cost

Feature management and licence

Licence or add-inOn the live system, Project manager, Project supervisor, Chief executive officer and Chief financial officer can run this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer legal entity: the report reads only the project data of the company you are signed in to, so run it in each company you close. Checked in Dynamics 365
Can it be undoneReversible: Running or rerunning the report changes no data.
If you change it laterThe report reads posted hour transactions and, for budgets, forecast lines. A change to cost prices or to the project cost and revenue profile affects only hours posted afterwards; past hours change only through Adjust transactions, after which you rerun the report. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListProjPayRollProj Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjListProjPayRollProj
Data migrationLoad order: Project payroll allocation has no data entity in Data management: the menu item ProjListProjPayRollProj opens a report that only reads posted project data. There is nothing to migrate for the report itself; load the project data it reads, for example opening balances through Journals > Beginning balance, then run the report in the new system and compare its totals with the old one.Checked in Dynamics 365
Everyone

8Sources

To cite this step: PM-RC-040, Set the selection for Project payroll allocation. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RC-040