BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Project payroll allocation (2 periods)

A report that shows payroll allocation per project for two ledger date ranges side by side, so you can compare two periods.

Business process
Analyze project performance
Menu item
output:ProjListProjPayRollProj2ColumnPeriod
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 shows payroll allocation per project for two ledger date ranges side by side, so you can compare two periods.
What you do hereUse it to see how payroll cost per project moved between two periods, for example month against month or quarter against quarter.
ExampleBEAT compares September with October 2026 per project: PRJ-0042 moves from 980.00 to 1,240.00 of payroll allocation because six more consulting hours were posted in October.
Project payroll allocation (2 periods) 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 processAnalyze project performance
Menu pathProject management and accounting › Inquiries and reports › Payroll allocation reports › Project payroll allocation (2 periods)
Set up firstProject payroll allocation Microsoft Learn
Used next byProject payroll allocation (actual vs. budget) Microsoft Learn
Related pagesCategory payroll allocation (2 periods) Microsoft Learn Resource payroll allocation (2 periods) 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 a period is closed, when you want to compare its payroll allocation per project with an earlier period, for example the same month last year.
How oftenOn demand, at period close or for a quarterly project review.
What the output showsOne row per project with a column for Period 1 and a column for Period 2. Unlike Project payroll allocation, it shows two ledger date ranges side by side; a large swing usually means hours were posted late into one of the periods.

Source: Microsoft Learn

Setup steps on this page

Set the selection for Project payroll allocation (2 periods)

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 periods).
  2. Under Include project types, turn on Time and material, Fixed-price, Investment or Internal and cost for the projects to compare across two periods.
  3. Under Ledger date - Period 1, enter the From date and To date of the first period, and under Ledger date - Period 2 the dates of the period to compare it with.
  4. Under Data, set Actual vs. budget and, for budget figures, a Forecast model, so both period columns use the same basis.
  5. Under Layout - rows, choose the Project view and Project level, run the report, and look at projects where the two period columns differ most.

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
One column is much smaller than expected.Hours of that period are probably not posted yet or carry a ledger date in the other period; post the remaining timesheets and check the ledger dates of late hour journals. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set the selection for Project payroll allocation (2 periods)Enter two periods of the same length, for example two full months, under Ledger date - Period 1 and Period 2.The two columns are plain totals for each range, so periods of different length or overlapping dates distort the comparison.How do you choose the two periods?Letting Period 1 and Period 2 overlap: hours posted on the shared dates count in both columns.Test: Project payroll allocation (2 periods) 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: the report changes no data: The Project payroll allocation (2 periods) report only reads posted payroll allocation data; it changes nothing. Microsoft Learn
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:ProjListProjPayRollProj2ColumnPeriod 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:ProjListProjPayRollProj2ColumnPeriod
Data migrationLoad order: Project payroll allocation (2 periods) has no data entity in Data management: the menu item ProjListProjPayRollProj2ColumnPeriod 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