BeyondERP.Newsletter
Menu

Setup step on the Resource hour rate page · Project management and accounting

Run the Resource hour rate report

Review revenue and cost per hour per resource (worker) or item.

Business process
Analyze project performance
Menu item
output:ProjListProjHourRateEmplItem
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 of the hour rates, one row per worker: the revenue and cost per hour for hours posted to revenue and cost accounts.
What you do hereIt answers what each hour really earns and costs per resource, so pricing and staffing can be checked against the price lists. Project managers, project supervisors, the CEO and the CFO can run it on this system.
ExampleBEAT runs Resource hour rate for October 2026. Worker W-0042 shows a sales rate of 88.00 per hour against a cost rate of 59.80, while W-0051 bills 64.00, so the manager checks which line property W-0051's hours carry.
Resource hour rate 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 month end, after timesheets are posted and revenue is accrued or invoiced.
How oftenMonthly, or at each price review.
Batch settingsRun it from the dialog; schedule it monthly in the background if it feeds the pricing review.
What the output showsHours with the sales rate and cost rate per hour, one row per worker.

Source: Microsoft Learn

Setup steps on this page

Run the Resource hour rate report

Review revenue and cost per hour per resource (worker) or item.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Hour rate reports > Resource hour rate.
  2. Keep Hour turned on under Include transaction types and turn on the project types whose workers you price, normally Time and material and Fixed-price.
  3. Enter the Ledger date range of a closed period so only hours already posted to revenue and cost accounts count.
  4. Turn on Skip zero to hide workers with no amounts, and Skip blank ID to leave out lines that carry no worker ID.
  5. Read the sales rate and cost rate per hour on each worker row; a sales rate far below the price list points to non-chargeable line properties or old prices.
  6. Compare each worker's cost rate with Cost price (hour) and correct the price line if a worker is costed at the wrong rate.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include project typesTurn on each project type to include. On this dialog the toggles are Time and material, Fixed-price, Investment, Internal and cost, and Time.Checked in Dynamics 365Time and material on
Include transaction typesHour is on by default on this dialog; the report is about hours, so other types add little.Checked in Dynamics 365Hour on
Actual vs. budgetActual (the default) shows posted hour rates; Budget shows the rates in the chosen forecast model.Checked in Dynamics 365Actual
Forecast modelThe forecast model that holds the budgeted hours and prices when Actual vs. budget is Budget.Microsoft Learn BUD-ORIG
Skip blank IDLeaves out lines that have no worker ID.Checked in Dynamics 365
Skip zeroLeaves out rows where every amount is zero.Checked in Dynamics 365Yes
(Project date) From date / To dateLimits the report to hours by the date the work was done.Checked in Dynamics 3651 October 2026 to 31 October 2026
(Ledger date) From date / To dateLimits the report to hours by ledger posting date.Checked in Dynamics 3651 October 2026 to 31 October 2026

Common errors and fixes

MessageWhat to do
The sales rate per hour of a worker is zero.The hours are not on revenue accounts yet (not accrued or invoiced) or sit on Internal or Time projects; accrue or invoice them, then rerun. Microsoft Learn

Test checklist

  1. Post a timesheet of 8.00 hours on PRJ-0042 at a sales price of 95.00 and a cost price of 60.00 for BEAT.
  2. Accrue revenue or invoice the hours.
  3. Run Resource hour rate for that date and check that the row shows 95.00 sales and 60.00 cost per hour.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Resource hour rate reportKeep Hour as the only transaction type and filter on the ledger date of a closed period first.Hour rates are hours posted to revenue and cost accounts; open periods and other transaction types dilute the rate.Which projects should Resource hour rate include?Reading a low rate as underpricing when the hours are simply not accrued or invoiced yet.Test: Resource hour rate shows the posted rate

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 report.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer legal entity: the report reads the projects, transactions and setup of the company you run it in. Run it in each company to compare them. Checked in Dynamics 365
Can it be undoneReversible: The report changes no data.
If you change it laterRerun after timesheets are posted and revenue is accrued or invoiced; hour rates use hours posted to revenue and cost accounts. The report itself changes nothing downstream. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListProjHourRateEmplItem 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:ProjListProjHourRateEmplItem
Data migrationLoad order: Resource hour rate has no data entity in Data management: it is a report. Move the project transactions, timesheets and forecasts it reads, and the report shows them when it runs.Checked in Dynamics 365
Everyone

8Sources

To cite this step: PM-RB-300, Run the Resource hour rate report. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RB-300