BeyondERP.Newsletter
Menu

Setup page · Project management and accounting

Project categories

A setup page where you create project categories, the basic grouping for project transactions.

Used by
Accounting manager, Project accountant, Project manager and 1 more role
Business process
Manage project financials
Menu item
ProjCategory
Main table
CategoryTable
Data entity
ProjectCategoryEntity
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 categories, the basic grouping for project transactions.
What you do hereUse this page to group project costs and revenue for posting and reporting, with their own cost and revenue accounts when needed.
ExampleFor example, BEAT keeps HOTEL and MILEAGE as separate expense categories in the TRAVEL group, so the 420.00 hotel bill and the 86.40 mileage claim on PRJ-0042 show on separate lines of the project statement.
Project categories 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 categories1 screen

Use this page to group project costs and revenue for posting and reporting, with their own cost and revenue accounts when needed.

  1. Screen 1

    Create a project category

    Go to Project management and accounting > Setup > Categories > Project categories

    1. Make sure the shared category and the category group already exist
    2. Select New
    3. Select the category ID of the shared category the project category is built on
    4. Select the category group and the transaction type
    5. Select Save
    6. Enter the cost and revenue accounts when the category needs its own posting accounts
    1Category IDBEAT-SCAT
    2Category nameShared category
    3Category groupBEAT-CG
    4Transaction typeHour
    Create a project category (zoomed on the outlined fields)
    Show the full screenCreate a project category
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Project management and accounting > Setup > Categories > Project categories.
  2. Select New.
  3. Select the Category ID of the shared category.
  4. Select a category group.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Category IDThe shared category the project category is based on; only shared categories can be picked.Microsoft Learn HOTELCategoryId
Category groupThe category group the category belongs to.Microsoft Learn TRAVELCategoryGroupId
Use in ExpenseLets the category also be used for expenses outside projects.Microsoft Learn YesUseInExpense
Indirect cost componentMarks the category for use with indirect cost components.Microsoft Learn NoPSAIndirectComponent
Category nameThe name of the project category.Microsoft Learn HotelCategoryName
Transaction typeThe type of project transaction the category is used for, such as hour or expense.Microsoft Learn ExpenseCategoryType

Common errors and fixes

MessageWhat to do
A new category isn't offered on journal lines.Check that the category is in a group of the journal's transaction type and is active in journals. Microsoft Learn

Test checklist

  1. Create a project category on an existing shared category and select its category group.
  2. Open a journal of the matching transaction type and check the category is offered.
  3. Post a line and check the voucher uses the category's account, or the group's when the category has none.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Project categoriesOne project category per cost or revenue you need to report separately, each on a shared category and a category groupProject categories are the basic grouping for project transactions and can carry their own cost and revenue accounts, for example to separate hotel from mileage expenses.How detailed should project categories be?Expecting a category to show on every line. Only categories linked to the line's transaction type are offered, so an expense line shows expense categories only.Test: Category posts to its own 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 categories 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: Categories are recorded on every project transaction. Changing a category's group or accounts affects new postings; posted transactions are corrected through project adjustments. Microsoft Learn
If you change it laterA category set up for indirect costs can't be used for direct costs on projects. Microsoft Learn
Technical architect

6Technical

Menu itemProjCategory Checked in Dynamics 365
FormProjCategory Checked in Dynamics 365
TableCategoryTableShown as “Category table” in Record infoKey field: CategoryIdChecked in Dynamics 365
Data entitiesProjectCategoryEntityProject category Checked in Dynamics 365CategoryEntityCategory table Microsoft data model ProjCDSCategoryEntityIntegration entity for categories Microsoft data model
Who can open itPrivilegesMaintain project cost categories ProjCategoryMaintainView project cost categories ProjCategoryViewDutiesInquire 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 setup: Category setupOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ProjCategory
Integrate withProjectCategoryEntity data entity Checked in Dynamics 365
Data migrationCategoryEntity Category table, loaded for each company.ProjectCategoryEntity Project category, loaded for each company.Load order: Microsoft's default template 650 - Project accounting loads Shared category at level 30, Category table at level 40 and Project category at level 60 (execution unit 1, sequence 10). Lower levels load first.Load first: Shared category, Project category groupMicrosoft Learn
Table definitionCategoryTable columns and relations Microsoft data model
Everyone

8Sources