BeyondERP.Newsletter
Menu

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

Run the Category hour rate report

Review revenue and cost per hour per project category.

Business process
Analyze project performance
Menu item
output:ProjListProjHourRateCategory
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 project category: 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 project category, 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 Category hour rate for Q3 2026. Category HOURS-CONS earns 104.50 per hour and HOURS-SUPP 72.00, which supports raising the support rate in the next price review.
Category 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 project category.

Source: Microsoft Learn

Setup steps on this page

Run the Category hour rate report

Review revenue and cost per hour per project category.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Hour rate reports > Category hour rate.
  2. Keep Hour turned on under Include transaction types and turn on the project types whose project categories 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 so categories with no amounts in the dates drop out, and keep the category list short enough to compare at a glance.
  5. Read the sales rate and cost rate per hour on each project category row; a sales rate far below the price list points to non-chargeable line properties or old prices.
  6. Compare the category rates with Sales price (hour) per category and propose the price changes for the next period.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include project typesTurn on each project type to include; Time projects carry hours with no ledger postings.Microsoft Learn Time and material on
Include transaction typesKeep Hour on; the report is about hours.Microsoft Learn Hour 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 project category ID.Checked in Dynamics 365
Skip zeroLeaves out rows where every amount is zero.Checked in Dynamics 365Yes

Common errors and fixes

MessageWhat to do
The sales rate per hour of a project category 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 Category 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 Category 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 Category hour rate include?Reading a low rate as underpricing when the hours are simply not accrued or invoiced yet.Test: Category 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:ProjListProjHourRateCategory 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:ProjListProjHourRateCategory
Data migrationLoad order: Category 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