BeyondERP.Newsletter
Menu

Setup step on the Subcategory codes page · Expense management

Set up Subcategory codes

Map subcategory codes to expense subcategories.

Business process
Develop people strategy
Menu item
TrvPBSSubCategoryCodes
Main table
TrvPBSSubCategoryCodes
Data entity
None for this page's own settings
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define subcategory codes, each with a description and a list of the expense subcategories it maps to.
What you do hereUse this page to create subcategory codes and map each code to one or more expense subcategories, the parts an itemized expense is split into, such as room rate, tax and parking on a hotel folio.
ExampleFor example, a code for hotel folios is mapped to the subcategories Room rate, Tax and Parking of the Hotel expense category.
Subcategory codes 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 processDevelop people strategy
Menu pathExpense management › Setup › Calculations and codes › Subcategory codes
Set up firstExpense categories Microsoft Learn
Used next byExpenses (Itemize) Microsoft Learn
Related pagesCredit card category codes Microsoft Learn
In this process Set up Terms of employment · Set up Compensation regions
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 Subcategory codes1 screen

Map subcategory codes to expense subcategories.

  1. Screen 1

    Create a subcategory code

    Go to Expense management > Setup > Calculations and codes > Subcategory codes

    1. Select New
    2. Enter the subcategory code and a description
    3. Under Subcategory code mappings, select the expense subcategory the code maps to
    4. Select Save
    1Subcategory codeBEAT-SUB
    2DescriptionSubcategory code
    Create a subcategory code (zoomed on the outlined fields)
    Show the full screenCreate a subcategory code
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Expense management > Setup > Calculations and codes > Subcategory codes.
  2. Select New and enter the subcategory code and a description.
  3. In the mappings, add the subcategories the code covers.
  4. Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Subcategory codeThe unique code for the subcategory.Checked in Dynamics 365AIRFARESubCategoryCode
DescriptionA short description of the subcategory code.Checked in Dynamics 365Subcategory codeDescription

Common errors and fixes

MessageWhat to do
No subcategories are offered in the mappingThe expense category has no subcategories. Add them to the category first. Microsoft Learn

Test checklist

  1. Check the Hotel expense category has the subcategories Room rate, Tax and Parking.
  2. Create a subcategory code and map it to those subcategories.
  3. Save and reopen the code.
  4. Check the mappings are kept.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Subcategory codesMap each code to the expense subcategories it stands for, and keep the codes in line with the subcategories set on the expense categories.Subcategories are the parts an expense is itemized into and can carry their own tax handling, so a code mapped to the wrong subcategory puts that part of the cost in the wrong place.Which categories are itemized into subcategories?Mapping a code to a subcategory of another expense category.Test: A code maps to its subcategories

Feature management and licence

Feature to turn onAbility to itemize recurring expenses quickly (Optional)
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 maintains subcategory codes.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Codes and mappings can be changed.
If you change it laterSubcategories, set on the expense category, decide how an itemized expense is split, whether a part is excluded from tax recovery, and which item sales tax group it uses. Microsoft Learn
Technical architect

6Technical

Menu itemTrvPBSSubCategoryCodes Checked in Dynamics 365
FormTrvPBSSubCategoryCodes Checked in Dynamics 365
TableTrvPBSSubCategoryCodesShown as “Subcategory codes” in Record infoChecked in Dynamics 365
Data entitiesTrvExpenseSubCategoryEntityExpense subcategory (the expense subcategories (table TrvExpSubCategory) that the codes map to, not the codes themselves) Microsoft data model
Roles to set it up and use itTo set it up or change itExpense administrator ExpenseAdministratorGive people one of these roles. On this system, 1 role 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=TrvPBSSubCategoryCodes
Data migrationLoad order: A subcategory code has no data entity in Data management, so it can't be loaded from a file or a configuration template. Enter the codes by hand in each environment; load the subcategories themselves with the Expense subcategory and Shared expense subcategory entities (template 600 - Expense).Microsoft Learn
Table definitionTrvPBSSubCategoryCodes columns and relations Microsoft data model
Everyone

8Sources

To cite this step: EM-SETUP-140, Set up Subcategory codes. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/EM-SETUP-140