BeyondERP.Newsletter
Menu

Setup step on the Cost price (hour) page · Project management and accounting

Set up Cost price (hour)

Use this page to set a standard hourly cost price, or cost prices by worker, project, category and date in any mix.

Used by
Project accountant, Project manager, Resource manager and 4 more roles
Business process
Manage project financials
Menu item
ProjCostPriceHour
Main table
ProjHourCostPrice
Data entity
ProjHourCostPriceV2Entity
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 setup page where you set cost prices for project hours.
What you do hereUse this page to set a standard hourly cost price, or cost prices by worker, project, category and date in any mix.
ExampleFor example, BEAT sets 45.00 per hour for the category CONSULTING from 01/01/2026 and 52.00 for the senior consultant worker 000245 on the same category, so her 7.50 hours on PRJ-0042 cost 390.00.
Cost price (hour) 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.

Step by step, with screenshots

Set up Cost price (hour)1 screen

Use this page to set a standard hourly cost price, or cost prices by worker, project, category and date in any mix.

  1. Screen 1

    Set an hourly cost price

    Go to Project management and accounting > Setup > Prices > Cost price (hour)

    1. Select New
    2. Enter the effective date
    3. Select the category the price is for (leave the worker, project and other columns blank for a standard price)
    4. Enter the cost price
    5. Select Save
    1CategoryBEAT-SCAT
    Effective date10/19/2026
    Cost price25.00
    Set an hourly cost price (zoomed on the outlined fields)
    Show the full screenSet an hourly cost price
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Prices > Cost price (hour).
  2. Select New and enter the Effective date from which the hour cost applies.
  3. Leave Resource and Project empty for a standard rate, or select a worker, project or category for a specific rate.
  4. Enter the Cost price per hour and save.
  5. Enter an hour journal line and check the cost price it takes.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Effective dateThe date the cost price starts to apply; every cost price needs one.Microsoft Learn 01/01/2026TransDate
CategoryThe project category that the hour cost price applies to.Microsoft Learn CONSULTINGCategoryId
Cost priceThe cost of one hour for the worker and category.Microsoft Learn 45.00CostPrice

Common errors and fixes

MessageWhat to do
Hour lines show a cost price of 0.00.No cost price row matches the line date, worker and category. Add a row with an earlier effective date. Microsoft Learn

Test checklist

  1. Create a cost price row for a category with an effective date.
  2. Create a second row for one worker on the same category.
  3. Enter hour journal lines for that worker and for another worker and check each cost price.
  4. Post and check Posted project transactions shows the same costs.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Cost price (hour)A standard cost price per category, with worker or project rows only where cost really differsThe price used is the one with the highest level of detail, so a general row covers everyone and specific rows override it only where needed.At what level should hour cost prices be kept?Forgetting that a more detailed row wins. A worker-specific price silently overrides the category standard, and a row with a later Effective date doesn't apply to earlier transactions.Test: Most detailed hour cost price is used

Feature management and licence

Feature to turn onStreamline cost price and sales price calculations (Optional)
Licence or add-inOn the live system, Project accountant and Service delivery manager maintain this page; Project manager, Resource manager and sales roles can open it. The optional Streamline cost price and sales price calculations feature changes how prices are calculated.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Date-effective; a new row changes cost for new transactions only.
If you change it laterWhen several cost prices could apply, the one with the most detail is used. Microsoft Learn
Technical architect

6Technical

Menu itemProjCostPriceHour Checked in Dynamics 365
FormProjCostPriceHour Checked in Dynamics 365
TableProjHourCostPriceShown as “Project - hour cost price” in Record infoKey field: CategoryId, Resource, Resource_Name, Resource_ResourceId, Resource_ResourceCompanyId, ResourceCategory, ProjId, TransDate, PSACustAccount, PSAProjInvoiceProjId, PSAPriceGroupId, ELR, IsResourceRateChecked in Dynamics 365
Data entitiesProjHourCostPriceV2EntityProject - hour cost price V2 Microsoft data model
Who can open itPrivilegesMaintain cost prices (hour) ProjCostPriceHourMaintainView cost prices (hour) ProjCostPriceHourViewMaintain service agreement details SMAAgreementDetailsMaintainView service agreement details SMAAgreementDetailsViewDutiesInquire into project cost pricing master ProjProjectCostPricingMasterInquireMaintain project cost pricing master ProjProjectCostPricingMasterMaintainResource manager ProjResourceManagerInquire into service agreement master SMAServiceAgreementMasterInquireMaintain service agreement master SMAServiceAgreementMasterMaintainEnable service agreement process SMAServiceAgreementProcessEnable
7 security rolesProject accountant ProjProjectAccountantProject manager ProjProjectManagerResource manager ProjResourceManagerService dispatcher SMADispatcherService delivery manager SMAServiceDeliveryManagerSales manager TradeSalesManagerSales representative TradeSalesRepresentative
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject accountant ProjProjectAccountantService delivery manager SMAServiceDeliveryManagerTo use itProject manager ProjProjectManagerSales representative TradeSalesRepresentativeSales manager TradeSalesManagerResource manager ProjResourceManagerService dispatcher SMADispatcherGive people one of these roles. On this system, 7 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjCostPriceHour
Integrate withProjHourCostPriceV2Entity data entity Microsoft data model
Data migrationProjHourCostPriceV2Entity Project - hour cost price V2, loaded for each company.Load order: Load hour cost prices after project categories, workers and projects, because a price row refers to them.Load first: Project categories, Workers, ProjectsMicrosoft Learn
Table definitionProjHourCostPrice columns and relations Microsoft data model
Everyone

8Sources