BeyondERP.Newsletter
Menu

Master data page · Project management and accounting

All projects

The list of every project in the legal entity, and the place where a project is created, opened and planned.

Business process
Plan projects
Menu item
ProjProjectsListPage
Main table
ProjTable
Data entity
ProjProjectV2Entity
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 isThe list of every project in the legal entity, and the place where a project is created, opened and planned.
What you do hereUse it to create a project and then work on it: its work breakdown structure, forecasts, item requirements, purchase orders, journals and invoices start from the project's Action Pane.
ExampleFor example, BEAT creates PRJ-0042 Warehouse fit-out as a Time and material project in group TM-STD on contract PC-0017, then adds a work breakdown structure of 120.00 hours across three tasks.
All projects 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 › Projects › All projects
Set up firstProject contracts Microsoft Learn
Used next byItem requirements Microsoft Learn Project purchase orders Microsoft Learn
Related pagesMy projects Microsoft Learn Posted project transactions 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.

Setup steps on this page

Create projects with the right type and group

Get the project type and project group right when the project is created.

Steps from Microsoft

  1. Go to Project management and accounting > Projects > All projects.
  2. Select New and choose the project type, for example Time and material.
  3. Enter the project name, select the project group and the project contract, and select Create project.
  4. On the Project team and scheduling FastTab, select the scheduling calendar.
  5. On the Plan tab, under Activities, select Work breakdown structure and add the tasks with their effort in hours.
  6. Select Publish, then open Plan > Item requirements or Forecast to plan the project's items and costs.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Project typeSets how the project handles costs and revenue recognition, for example Time and material or Fixed-price. It can't be changed after the project is created.Microsoft Learn Time and materialType
Project contractThe contract that holds the billing terms; every project you invoice needs one.Microsoft Learn PC-0017
Project groupGroups projects for ledger posting; the group's ledger update options can't be changed once a project is assigned to it.Microsoft Learn TM-STD

Common errors and fixes

MessageWhat to do
Hours posted to a Cost or Internal project don't show on Create invoice proposals.Only Time and material and Fixed-price projects can be invoiced. Create the project again with the right type; the type can't be changed. Microsoft Learn

Test checklist

  1. Create a Time and material project in a project group set up for that type and attach it to a project contract.
  2. Post one hour journal line to the project.
  3. Open Posted project transactions and check the hour shows with the expected line property (chargeable or not).
  4. Create an invoice proposal for the project and check the hour is offered for invoicing.
  5. Repeat with a Cost project and check its hour doesn't appear on Create invoice proposals.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Create projects with the right type and groupSelect the project type and project group when you create the project, and attach a project contract to every Time and material or Fixed-price project.The project type can't be changed later, and the project group's ledger update options can't be changed once the project uses it.How should projects be grouped for posting?Putting a billable project in an internal project group or choosing the Cost type: the hours never reach an invoice proposal and the project must be recreated.Test: Create a billable project and check it can be invoiced

Feature management and licence

Licence or add-inOn the live system, Project manager, Project accountant, Field Service Integration User and Sales manager use this page.

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 undoneOne-way: Warning: you can change a project and its project contract later, but not its project type. Once a project is assigned to a project group, the ledger update options defined on that project group can't be changed. Get the project group and type right when you create the project. Microsoft Learn
If you change it laterYou can change a project and its contract later, but not the project type. The project group's ledger update options are fixed once a project uses the group. Microsoft Learn
Technical architect

6Technical

Menu itemProjProjectsListPage Checked in Dynamics 365
FormProjProjectsListPage Checked in Dynamics 365
TableProjTableShown as “Projects” in Record infoKey field: ProjId, JobIdChecked in Dynamics 365
Data entitiesProjProjectV2EntityProjects V2 Microsoft data model ProjectEntityProjects Microsoft data model ProjCDSProjectEntityIntegration entity for project Microsoft data model DimAttributeProjTableEntityProjects Microsoft data model
Roles to set it up and use itTo set it up or change itProject manager ProjProjectManagerProject accountant ProjProjectAccountantField Service Integration User FieldServiceIntegrationUserSales manager TradeSalesManagerTo use itProject supervisor ProjProjectSupervisorChief financial officer CompanyChiefFinancialOfficerProject assistant ProjProjectClerkService delivery manager SMAServiceDeliveryManagerResource manager ProjResourceManagerGive people one of these roles. On this system, 18 roles can open this page.Checked in Dynamics 365
Actions on the pageProject: New, Maintain, Set up, Cost prices, Sales prices, JournalsPlan: Activities, Item requirements, Forecast, Maintain forecast, Budget, ValidationManage: New, Process, Bill, Related informationControl: Statements, Control, Project tracking, Utilization, RetentionOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjProjectsListPage
Integrate withProjProjectV2Entity data entity Microsoft data model
Data migrationProjectEntity (Projects): loaded for each company, in Microsoft's default template 650 - Project accounting.ProjProjectV2Entity (Projects V2): loaded for each company.Load order: Microsoft's default template 650 - Project accounting loads Projects at execution unit 1, level 650, sequence 20. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to Expense management)Microsoft Learn
Table definitionProjTable columns and relations Microsoft data model
Everyone

8Sources