BeyondERP.Newsletter
Menu

Setup page · Expense management

Shared categories

A setup page where you maintain shared categories, the parent categories that expense and project categories are built on and that can be shared across modules.

Business process
Administer system features
Menu item
TrvSharedCategory
Main table
SharedCategory
Data entity
SharedCategoryEntity
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 maintain shared categories, the parent categories that expense and project categories are built on and that can be shared across modules.
What you do hereUse this page to create and adjust the shared categories that Expense management and Project management and accounting use as the basis for their own categories.
ExampleFor example, the shared category Airfare is created once with Can be used in Expense on and its expense type set; each legal entity then creates its own Airfare expense category from it, with its own main account.
Shared 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

Business processAdminister system features
Menu pathExpense management › Setup › General › Shared categories
Set up firstExpense management parameters Microsoft Learn
Used next byExpense categories Microsoft Learn Project categories Microsoft Learn Set up Expense categories
Related pagesExpense categories Microsoft Learn Project categories 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 Shared categories1 screen

Use this page to create and adjust the shared categories that Expense management and Project management and accounting use as the basis for their own categories.

  1. Screen 1

    Create a shared category

    Go to Organization administration > Setup > Categories > Shared categories

    1. Select New
    2. Enter the category ID and name
    3. Turn on where the category can be used, here Can be used in Project
    4. Select Save
    1Category IDBEAT-SCAT
    2Category nameShared category
    3Can be used in ProjectYes
    Create a shared category (zoomed on the outlined fields)
    Show the full screenCreate a shared category
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Expense management > Setup > General > Shared categories.
  2. Select a shared category that has the Expense transaction class.
  3. Set the Can be used in Expense option to Yes.
  4. Select the expense type to use.
  5. Save the record, and then use the shared category to create an expense category.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Can be used in ExpenseTurn this on so the shared category can be used to create expense categories.Microsoft Learn
Category IDThe unique ID of the shared category.Microsoft Learn CONSULTINGCategoryId
Category nameThe name of the shared category.Microsoft Learn Shared categoryCategoryName
Can be used in ProjectWhether project categories can be created from this shared category.Microsoft Learn Yes

Common errors and fixes

MessageWhat to do
The shared category isn't offered when you create an expense categoryTurn on Can be used in Expense and choose the expense type on the shared category. Microsoft Learn
Expense and Production can't both be turned onA shared category can be shared by Project and Expense, or Project and Production, but not Expense and Production. Create a separate shared category. Microsoft Learn

Test checklist

  1. Create a shared category with Can be used in Expense and Can be used in Project set to Yes and an Expense type.
  2. Try to set Can be used in Production to Yes as well and check the system doesn't allow both Production and Expense.
  3. In a legal entity, create an expense category from it and check the Expense type is filled in and Use in Project can be set to Yes.
  4. Check the category is offered on a new expense line.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Shared categoriesDecide per category whether it's shared between Project and Expense or Project and Production, and set Can be used in Expense / Can be used in Project to matchShared categories are the parent for expense and project categories in every legal entity, and they can be shared between Project and Expense or Project and Production, but not between Expense and Production.Which modules can each shared category be used in?Creating project categories before the shared category exists. A shared category must exist before a project category can be created in any legal entity that uses it. With Project Operations, shared categories are created from Dataverse transaction categories, so create the transaction category there first.

Feature management and licence

Licence or add-inIn this system Employee and Contractor enter their own expenses, and Expense administrator sets up the module and processes documents. The expense mobile app needs the Employee role, a company on the user account and a link to an employee with active employment. The expense administrator, or the project administrator for shared project categories, maintains this list. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneHard to reverse: Shared categories are used by every legal entity. The Expense type and the project setting on each company's expense categories come from the shared category, so a change must be checked in every legal entity that uses it. Microsoft Learn
If you change it laterAn expense category can be created only from a shared category that has Can be used in Expense on. A shared category can be used for Project and Expense or Project and Production, not Expense and Production. Microsoft Learn
Technical architect

6Technical

Menu itemTrvSharedCategory Checked in Dynamics 365
FormGlobalCategory Checked in Dynamics 365
TableSharedCategoryShown as “Shared category” in Record infoChecked in Dynamics 365
Data entitiesSharedCategoryEntityShared category Microsoft data model
Roles to set it up and use itTo set it up or change itExpense administrator ExpenseAdministratorInformation technology manager SysServerITManagerBusiness Performance Planning app role BPPBudgetPlanningAppRoleData management migration user DataManagementMigrationUserDemand planning app role ScpDemandPlanningAppRoleTo use itContractor HcmContractorEmployee HCMEmployeeExpenseAgentRole ExpenseAgentV2Role Project accountant ProjProjectAccountantGive people one of these roles. On this system, 16 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=TrvSharedCategory
Integrate withSharedCategoryEntity data entity Microsoft data model
Data migrationSharedCategoryEntity (Shared category): shared by all companies; load it before the expense categories of each company.Load order: Load shared categories first (template 600 - Expense, with Can be used in Expense set), then Expense category for each company.Microsoft Learn
Table definitionSharedCategory columns and relations Microsoft data model
Everyone

8Sources