BeyondERP.Newsletter
Menu

Setup step on the Project prices page · Project management and accounting

Check the sales price for a date

Find which sales price applies to a transaction on a given date.

Business process
Manage project financials
Menu item
output:ProjPriceList
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 that lists the project sales prices set up for hours, expenses, fees and subscriptions, filtered by price group, currency, category, resource, worker and effective date.
What you do hereUse it to answer 'which sales price will a project transaction get on a given date?' before a price change, or when a journal line picked up an unexpected price.
ExampleBefore the 1 January price increase, the BEAT project accountant prints hour sales prices for price group PG-STD in EUR on 31 December and finds CONSULT at 150.00 and DEV at 120.00, then checks the new records for 1 January show 158.00 and 126.00.
Project prices 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 itBefore a price change, and when an hour or expense line got an unexpected sales price.
How oftenOn demand; yearly before price increases.
What the output showsSales prices per price type with price group, currency, category, resource, worker and effective date.

Source: Microsoft Learn

Setup steps on this page

Check the sales price for a date

Find which sales price applies to a transaction on a given date.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Prices reports > Project prices.
  2. Turn on only the price types you check, usually Sales price - hour.
  3. Set Price group and Sales currency to the agreement you review, and Category, Resource or Worker if one line priced oddly.
  4. Enter the Effective date of the transaction, run the report, and correct the price record on the matching Sales price page.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Sales price - hourIncludes hour sales prices, which can be set per role, resource, category, project, contract or price group.Microsoft data model Yes
Sales price - expenseIncludes expense sales prices.Microsoft Learn No
Sales price - feeIncludes fee sales prices; fee prices apply to Fixed-price projects as well.Microsoft Learn No
Sales price - subscriptionIncludes subscription sales prices.Microsoft Learn No
Price groupUnder View: limits the report to one project price group.Checked in Dynamics 365PG-STD
Sales currencyLimits the report to prices in one currency.Checked in Dynamics 365EUR
Effective dateLists only prices valid on this date; leave it empty to list every dated price record.Checked in Dynamics 3652026-12-31

Common errors and fixes

MessageWhat to do
Item prices don't appear on the report.Item sales prices are set up in Inventory management, not in project prices; the report covers hours, expenses, fees and subscriptions. Microsoft Learn

Test checklist

  1. Create an hour sales price of 150.00 EUR for role CONSULT, price group PG-STD, effective 1 October.
  2. Run the report for hours, PG-STD, EUR, effective date 31 October.
  3. Check that CONSULT shows 150.00.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check the sales price for a dateTurn on one price type and set Price group, Sales currency and Effective date before running.Prices are dated records per role, category, project or price group; without an effective date the report lists old and new prices side by side.Are hour prices set by role or by named resource?Reading the latest price record as the one in force, although its effective date is after the transaction.Test: Price valid on a date

Feature management and licence

Licence or add-inOn the live system, Project accountant runs this report.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: project sales prices belong to the legal entity; intercompany work uses transfer prices instead. Microsoft data model
Can it be undoneReversible: Reading the page changes no data.
If you change it laterA new price record applies from its effective date to transactions entered afterwards; posted transactions keep their price until adjusted. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjPriceList Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject accountant ProjProjectAccountantGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjPriceList
Data migrationLoad order: The Project prices report has no data entity in Data management: it prints price records. Load hour, expense and fee prices with ProjHourSalesPriceV2Entity, ProjCostSalesPriceEntity and ProjRevenueSalesPriceEntity, then run the report to compare.Load first: Project - hour sales price V2 (ProjHourSalesPriceV2Entity)Microsoft data model
Everyone

8Sources