BeyondERP.Newsletter
Menu

Setup page · Project management and accounting

Sales price (hour)

A setup page where you set sales prices for project hours.

Used by
Project accountant, Project manager, Resource manager and 4 more roles
Business process
Manage project financials
Menu item
ProjSalesPriceHour
Main table
ProjHourSalesPrice
Data entity
ProjHourSalesPriceV2Entity
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 setup page where you set sales prices for project hours.
What you do hereUse this page to set a standard hourly sales price, or prices by worker, project, category, role or date.
ExampleFor example, BEAT charges 120.00 per hour for the role CONSULTANT from 01/01/2026 and a negotiated 110.00 for project PRJ-0042, so 7.50 hours on PRJ-0042 are invoiced at 825.00.
Sales 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

Business processManage project financials
Menu pathProject management and accounting › Setup › Prices › Sales price (hour)
Set up firstResource roles Microsoft Learn Set up Project categories
Used next byHour journal Microsoft Learn
Related pagesCost price (hour) 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.

Step by step, with screenshots

Set up Sales price (hour)1 screen

Use this page to set a standard hourly sales price, or prices by worker, project, category, role or date.

  1. Screen 1

    Set an hourly sales price

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

    1. Select New
    2. Enter the effective date
    3. Select the category the price is for
    4. Set Valid for to All to use the price for every project, or to Table or Group for a narrower price
    5. Check the sales currency and enter the price under Pricing
    6. Select Save
    1CategoryBEAT-SCAT
    Effective date10/19/2026
    Valid forAll
    Pricing50.00
    Set an hourly sales price (zoomed on the outlined fields)
    Show the full screenSet an hourly sales price
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Prices > Sales price (hour).
  2. Select New and enter the Effective date and the Currency.
  3. In Valid for, select All, Group or Table for the projects the price covers, and select a role, worker or category if needed.
  4. Enter the Pricing amount and save.
  5. Create an invoice proposal for hours on the project and check the sales price used.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Sales price modelThe calculation method used to get the final sales price.Microsoft Learn ProjSalesPriceModel
PricingAn amount or a percentage, depending on the sales price model.Microsoft Learn 120.00ProjSalesPricing
RoleThe resource role the price applies to.Microsoft Learn CONSULTANT
CurrencyThe sales currency; every sales price needs one.Microsoft Learn USD
Effective dateThe date from which the hour sales price applies.Microsoft Learn 01/01/2026TransDate
CategoryThe project category that the sales price applies to.Microsoft Learn CONSULTINGCategoryId
Valid forWhether the price applies to all projects, a project group or a single project.Microsoft Learn AllProjValidFor

Common errors and fixes

MessageWhat to do
Hours on a project are invoiced at the general price instead of the negotiated one.The negotiated row has a later effective date than the hours, or its Valid for doesn't match the project. Check the date and the project relation. Microsoft Learn

Test checklist

  1. Create a sales price row for a role with an effective date.
  2. Create a worker-specific row for one worker.
  3. Enter hour journal lines for both workers and check the defaulted sales price.
  4. Create an invoice proposal and check the hours carry those prices.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Sales price (hour)A standard sales price per category or role, with worker or project rows for negotiated ratesSales prices can be set by role, worker, project, category and date; the most detailed match is applied when hours are entered.How should hourly sales prices be set?A general price and a worker-specific price both exist and users expect the general one. The worker-specific price is used.Test: Negotiated project rate wins

Feature management and licence

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.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: New effective-dated rows change sales prices going forward; uninvoiced posted hours can be corrected with project adjustments. Microsoft Learn
If you change it laterThe price used on an hour journal line is the most detailed sales price that matches it. Microsoft Learn
Technical architect

6Technical

Menu itemProjSalesPriceHour Checked in Dynamics 365
FormProjSalesPriceHour Checked in Dynamics 365
TableProjHourSalesPriceShown as “Project - hour sales price” in Record infoKey field: TransDate, CategoryId, PSACustAccount, PSAProjInvoiceProjId, Resource, Resource_Name, Resource_ResourceId, Resource_ResourceCompanyId, ResourceCategory, ProjValidFor, ProjId, ProjPriceGroupChecked in Dynamics 365
Data entitiesProjHourSalesPriceV2EntityProject - hour sales price V2 Microsoft data model
Who can open itPrivilegesMaintain sales prices for hour transactions ProjSalesPriceHourMaintainView sales prices for hour transactions ProjSalesPriceHourViewMaintain service agreement details SMAAgreementDetailsMaintainView service agreement details SMAAgreementDetailsViewDutiesInquire into project sales pricing master ProjProjectSalesPricingMasterInquireMaintain project sales pricing master ProjProjectSalesPricingMasterMaintainResource 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=ProjSalesPriceHour
Integrate withProjHourSalesPriceV2Entity data entity Microsoft data model
Data migrationProjHourSalesPriceV2Entity Project - hour sales price V2, loaded for each company.Load order: Load hour sales prices after resource roles, project categories, projects and currencies, because a price row refers to them.Load first: Resource roles, Project categories, ProjectsMicrosoft Learn
Table definitionProjHourSalesPrice columns and relations Microsoft data model
Everyone

8Sources