BeyondERP.Newsletter
Menu

Setup step on the Projects report page · Project management and accounting

Run the projects report for one review question

List the projects that answer one review question, such as open Time and material projects.

Business process
Plan projects
Menu item
output:ProjListProjTable
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 projects with their ID, name, project contract, project group, type and status, for the project types and stages you choose.
What you do hereUse it to answer 'which projects do we have, of which type, and are they still active?' before a portfolio review, a period-end check or a cleanup of finished projects.
ExampleBefore the quarterly portfolio review, the BEAT project controller runs the report for Time and material and Fixed-price with Active projects on and finds 42 projects, including PRJ-0042 on contract CON-0107 in group TM-STD that should have been finished in September.
Projects report 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 processPlan projects
Menu pathProject management and accounting › Inquiries and reports › Projects report
Set up firstAll projects Microsoft Learn Project contracts Microsoft Learn
Used next byAll projects (change status) Microsoft Learn
Related pagesProject contracts report Microsoft Learn
In this process Set up Resource roles · Read hour forecasts for one model
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 portfolio review or period end, and after a batch of project creations, to confirm type, group and contract.
How oftenOn demand; monthly for portfolio reviews.
What the output showsOne line per project with ID, name, contract, group, type and status, printed to screen or a file.

Source: Microsoft Learn

Setup steps on this page

Run the projects report for one review question

List the projects that answer one review question, such as open Time and material projects.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Projects report.
  2. Under Include project types, turn on the types the review covers. Internal and cost covers both Internal and Cost projects, so turn it on when you also want internal work.
  3. Under Data, turn on Active projects for the open portfolio; add Finished projects only when you look for projects to archive.
  4. Read the list by project group and status; a project that is still active after its work ended is the one to close on All projects.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Include project typesWhich of the six project types to list; the dialog toggles Time and material, Fixed-price, Investment, Internal and cost (Internal and Cost project types) and Time. Turn on at least one, or the report is empty.Checked in Dynamics 365Time and material and Fixed-price on, the others off.
Active projectsLists projects that are still open for transactions.Checked in Dynamics 365Yes
Finished projectsLists projects that are finished. Turn it on with Active projects to see the whole portfolio.Checked in Dynamics 365No

Common errors and fixes

MessageWhat to do
The report comes back empty.Turn on at least one project type and at least one of Active projects or Finished projects; all toggles start at No. Checked in Dynamics 365
An Investment project is missing from the list.Investment is its own toggle; Internal and cost does not include it. Microsoft Learn

Test checklist

  1. Create two projects, one Time and material and one Fixed-price, on the same contract.
  2. Run the report with only Time and material turned on.
  3. Run it again with both types on.
  4. Check that the first run lists one of the two projects and the second lists both.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the projects report for one review questionTurn on only the project types under review and Active projects; add Finished projects only for a cleanup.Each project type behaves differently for cost and revenue, and finished projects inflate the count, so the toggles decide what the list means.Should the portfolio review list finished projects?Leaving Investment off and assuming Internal and cost includes it, so long-running capitalized projects disappear from the review.Test: Projects report filters by type and status

Feature management and licence

Licence or add-inOn the live system, Project manager, Project supervisor, Project accountant and Project assistant are among the 10 roles that can run this report.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the report lists the projects of the legal entity you're signed in to. Run it in each company for a group view. Microsoft data model
Can it be undoneReversible: Reading the page changes no data.
If you change it laterThe report reflects project changes right away; a changed project group or stage shows the next time you run it. The project type can't be changed after creation, so a project listed under the wrong type has to be replaced, not edited. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListProjTable Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorProject accountant ProjProjectAccountantProject assistant ProjProjectClerkField Service Integration User FieldServiceIntegrationUserGive people one of these roles. On this system, 10 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjListProjTable
Data migrationLoad order: The Projects report has no data entity in Data management: it holds no data of its own and prints the project records. Load projects with Projects V2 (ProjProjectV2Entity), then run the report to check counts by type.Load first: Projects V2 (ProjProjectV2Entity)Microsoft data model
Everyone

8Sources