BeyondERP.Newsletter
Menu

Setup page · Project management and accounting

Category groups

A setup page where you create category groups, which let related project categories share settings, mainly posting profiles.

Used by
Accounting manager, Project accountant, Project manager and 1 more role
Business process
Manage project financials
Menu item
ProjCategoryGroup
Main table
ProjCategoryGroup
Data entity
ProjCategoryGroupEntity
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 category groups, which let related project categories share settings, mainly posting profiles.
What you do hereUse this page to group project categories of the same transaction type; each transaction type needs at least one category group.
ExampleFor example, BEAT groups the hour categories CONSULTING and TRAINING in LABOR, posting their cost to 640100, and the expense categories TRAVEL-AIR and HOTEL in TRAVEL, so a new category added to LABOR posts correctly from its first 7.50-hour line.
Category 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

Business processManage project financials
Menu pathProject management and accounting › Setup › Categories › Category groups
Set up firstLine properties Microsoft Learn
Used next byProject categories Microsoft Learn Set up Project categories
Related pagesLedger posting setup 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 Category groups1 screen

Use this page to group project categories of the same transaction type; each transaction type needs at least one category group.

  1. Screen 1

    Create a category group

    Go to Project management and accounting > Setup > Categories > Category groups

    1. Select New
    2. Enter the category group code and name
    3. Select the transaction type, such as Hour, Expense or Item
    4. Select Save
    5. Enter the cost and revenue accounts when the group is used for posting
    1Category groupBEAT-CG
    2Transaction typeHour
    3Category group nameCategory group
    Create a category group (zoomed on the outlined fields)
    Show the full screenCreate a category group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Categories > Category groups.
  2. Select New.
  3. In the Category group field, enter an ID.
  4. In the Transaction type field, select the transaction type for the group.
  5. Optionally, enter a Category group name and select a Line property.
  6. On the Cost accounts FastTab, select the cost accounts.
  7. On the Revenue accounts FastTab, select the revenue accounts.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Transaction typeThe transaction type of the group; its categories must be of the same type.Microsoft Learn HourCategoryType
Line propertyThe line property that sets cost and sales percentages, revenue accrual and cost capitalization for the group.Microsoft Learn CHARGE
Category groupThe unique ID of the category group.Microsoft Learn LABORCategoryGroupId
Category group nameThe name of the category group.Microsoft Learn Consulting laborName

Common errors and fixes

MessageWhat to do
A category can't be selected on an hour journal line.The category belongs to a group of another transaction type. Create it in a category group of type Hour. Microsoft Learn

Test checklist

  1. Create one category group each for Hour, Expense, Item and Fee.
  2. Create a project category in the Expense group.
  3. Open an expense journal line and check the category is offered.
  4. Open an hour journal line and check the expense category is not offered.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Category groupsAt least one category group per transaction type, grouping categories that share posting accountsEach transaction type needs at least one category group, and groups are how related categories share properties, mainly posting profiles.How should project categories be grouped?Putting a category in a group of the wrong transaction type. A category takes its group's transaction type, so it won't appear on lines of the type you meant it for.Test: Category inherits the group's account

Feature management and licence

Feature to turn onEnable project categories for on-account transactions (Optional)
Licence or add-inOn the live system, Project supervisor maintains this page; Project manager, Project accountant and Accounting manager can open it. On-account category groups need the Enable project categories for on-account transactions feature (10.0.41).

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: A category belongs to one group and inherits its transaction type and posting setup. Moving categories later changes posting for new transactions, while posted history keeps the old accounts. Microsoft Learn
If you change it laterCategories inherit the transaction type and the posting accounts of their group. Accounts set on the group apply to every category in it that has no account of its own. Microsoft Learn
Technical architect

6Technical

Menu itemProjCategoryGroup Checked in Dynamics 365
FormProjCategoryGroup Checked in Dynamics 365
TableProjCategoryGroupShown as “Category group” in Record infoKey field: CategoryGroupId, Name, CategoryTypeChecked in Dynamics 365
Data entitiesProjCategoryGroupEntityProject category group Microsoft data model
Who can open itPrivilegesMaintain project category groups ProjCategoryGroupMaintainView project category groups ProjCategoryGroupViewDutiesInquire into project category master ProjProjectCategoriesMasterInquireMaintain project category master ProjProjectCategoriesMasterMaintain
4 security rolesAccounting manager LedgerAccountingManagerProject accountant ProjProjectAccountantProject manager ProjProjectManagerProject supervisor ProjProjectSupervisor
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProject supervisor ProjProjectSupervisorTo use itProject manager ProjProjectManagerProject accountant ProjProjectAccountantAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the pageCategory groups: Category groupsOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjCategoryGroup
Integrate withProjCategoryGroupEntity data entity Microsoft data model
Data migrationProjCategoryGroupEntity (Project category group): loaded for each company, in Microsoft's default template 650 - Project accounting.Load order: Microsoft's default template 650 - Project accounting loads Project category group at execution unit 1, level 40, 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 definitionProjCategoryGroup columns and relations Microsoft data model
Everyone

8Sources