BeyondERP.Newsletter
Menu

Setup page · Project management and accounting

Project groups

A setup page where you create project groups, which set the basic accounting rules for the projects of a given project type.

Used by
Accounting manager, Project accountant, Project supervisor
Business process
Manage project financials
Menu item
ProjGroup
Main table
ProjGroup
Data entity
ProjectGroupEntity
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 create project groups, which set the basic accounting rules for the projects of a given project type.
What you do hereUse this page to decide whether hour, expense, item and on-account transactions for the group's projects post to profit and loss accounts or balance accounts.
ExampleFor example, BEAT keeps TM-STD for Time and material projects with hours journalized to Balance (WIP), and INT-COST for internal projects with hours posted straight to profit and loss, so PRJ-0042 (customer work) and PRJ-0090 (internal training) post 1,200.00 of hours to different accounts.
Project groups 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 Project groups1 screen

Use this page to decide whether hour, expense, item and on-account transactions for the group's projects post to profit and loss accounts or balance accounts.

  1. Screen 1

    Create a project group

    Go to Project management and accounting > Setup > Posting > Project groups

    1. Select New
    2. Enter the project group code and name
    3. Select the project type the group is for
    4. Check the ledger posting and line property search priorities
    5. Select Save
    6. Open the Ledger, Cost accounts and Revenue accounts sections to enter the posting accounts when you are ready to post
    1Project groupBEAT-PG
    2NameProject group
    3Project typeTime and material
    4Ledger posting search priorityCategory
    Create a project group (zoomed on the outlined fields)
    Show the full screenCreate a project group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Posting > Project groups.
  2. Select New, enter the Project group and Name, and select the Project type the group is for.
  3. On the Ledger FastTab, choose for hour, expense and item costs whether they post to Profit and loss or Balance, and whether on-account invoices post to revenue or WIP.
  4. Select the default line property and the Ledger posting search priority (project or category first).
  5. For fixed-price and investment groups, set the cost template and period code on the Estimate FastTab.
  6. Check the setup before you assign the first project, because the ledger options lock after that.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Project typeThe type of project the group is for; a project can only join a group made for its type.Microsoft Learn Time and materialprojType
On-account invoicingWhether on-account invoices for Time and material and Fixed-price projects post to revenue accounts or work-in-process (WIP) accounts.Microsoft Learn WIPInvoicePosting
Search priorityWhether ledger accounts are found by project settings first or by category settings first.Microsoft Learn Category
Cost templateFor fixed-price and investment projects, the cost template that controls estimate costs.Microsoft Learn STD-COST
Period codeHow often estimates are calculated for the group's projects.Microsoft Learn MONTH
Foreseeable lossesRecognize losses at once when estimated costs go over the contract value or the capitalization limit.Microsoft Learn
Project groupThe unique ID of the project group.Microsoft Learn TM-STDProjGroupId
NameThe name of the project group.Microsoft Learn Time and material - standardName
Ledger posting search priorityThe order in which the system searches the ledger posting setup, for example by category first.Microsoft Learn CategoryLedgerPosting

Common errors and fixes

MessageWhat to do
The journalizing options of a project group can't be changed.A project is already assigned to the group. Create a new project group with the right options and move new projects to it. Microsoft Learn

Test checklist

  1. Create a Time and material project group with hour journalizing set to Balance and another set to Profit and loss.
  2. Create one project in each group and post the same hour journal to both.
  3. Open the vouchers and check the Balance group posts to the WIP cost account and the Profit and loss group to the cost account.
  4. Try to change the journalizing option on a group that has a project and check it is locked.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Project groupsAt least one project group per project type, with journalizing set per transaction type: Profit and loss for short-term work, Balance (WIP) for long-term or capitalized workEvery project must belong to a project group, and the group sets whether hour, expense, item and on-account postings go to Profit and loss or Balance accounts. Microsoft describes posting short-term projects straight to P&L and using WIP for long-term projects.Should this project group post costs and on-account invoices to Profit and loss or to Balance (WIP) accounts?Planning to fix the posting setup later: once a project is assigned to a project group, its ledger posting options can't be changed, so a wrong group means creating a new group and moving projects.Test: Project group drives P&L or WIP posting

Feature management and licence

Licence or add-inOn the live system, Project accountant maintains this page; Project supervisor and Accounting manager 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 undoneOne-way: Warning: once any project is assigned to the group, its ledger posting options are locked. Moving a project to a group of another project type also changes the project's type. Microsoft Learn
If you change it laterOnce a project is assigned to a project group, the group's ledger posting options can't be changed. Microsoft Learn
Technical architect

6Technical

Menu itemProjGroup Checked in Dynamics 365
FormProjGroup Checked in Dynamics 365
TableProjGroupShown as “Project groups” in Record infoKey field: ProjGroupId, Name, projTypeChecked in Dynamics 365
Data entitiesProjectGroupEntityProject groups Microsoft data model ProjProjectGroupV2EntityProject groups V2 Microsoft data model
Who can open itPrivilegesMaintain project groups ProjGroupMaintainView project groups ProjGroupViewDutiesInquire into project groups master ProjProjectGroupsMasterInquireMaintain project groups master ProjProjectGroupsMasterMaintain
3 security rolesAccounting manager LedgerAccountingManagerProject accountant ProjProjectAccountantProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject accountant ProjProjectAccountantTo use itProject supervisor ProjProjectSupervisorAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 3 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=ProjGroup
Integrate withProjectGroupEntity data entity Microsoft data model
Data migrationProjectGroupEntity (Project groups): loaded for each company, in Microsoft's default template 650 - Project accounting.ProjProjectGroupV2Entity (Project groups V2): loaded for each company.Load order: Microsoft's default template 650 - Project accounting loads Project groups at execution unit 1, level 70, sequence 10. 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 dependency bands 30 to 90)Microsoft Learn
Table definitionProjGroup columns and relations Microsoft data model
Everyone

8Sources