BeyondERP.Newsletter
Menu

Setup step on the Expense categories page · Expense management

Set up Expense categories

Use this page to link each category to a shared category and to set its main account, default and allowed payment methods, and itemization and project settings.

Business process
Develop people strategy
Menu item
TrvCostType
Main table
CategoryTable
Data entity
CategoryEntity
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 create, for each legal entity, the expense categories that employees pick for every expense.
What you do hereUse this page to link each category to a shared category and to set its main account, default and allowed payment methods, and itemization and project settings.
ExampleFor example, consultants' airfare, meals, hotel and mileage each go to a category, and the category decides the ledger account the cost is booked to.
Expense 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 Expense categories1 screen

Use this page to link each category to a shared category and to set its main account, default and allowed payment methods, and itemization and project settings.

  1. Screen 1

    Create an expense category

    Go to Expense management > Setup > General > Expense categories

    1. Make sure the shared category exists with Can be used in Expense turned on
    2. Select New
    3. In Category ID, select the shared category
    4. Under Expense, select the default payment method and the main account
    5. Select Save
    1Category IDBEAT-ESC
    2Category nameExpense category
    3Default payment methodBEAT-PM
    4Main account610100
    Create an expense category (zoomed on the outlined fields)
    Show the full screenCreate an expense category
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Expense management > Setup > General > Expense categories.
  2. Select New.
  3. In the Category ID field, select the shared category to base it on.
  4. On the Expense tab, select the main account to post to.
  5. On the Allowed payment methods tab, list the allowed payment methods and select a default.
  6. Optionally, add an Item sales tax group if the expense is taxable.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Category IDThe shared category the expense category comes from; only shared categories that can be used in Expense are listed.Microsoft Learn HOTELCategoryId
Default payment methodThe payment method suggested for this category; it is required.Microsoft Learn CORPCARDStdPaiMethod
Expense typeFilled in from the shared category.Microsoft Learn ExpType
Itemization mandatoryRequires the expense to be broken down by subcategory during entry.Microsoft Learn IsItemizationMandatory
InactiveStops the category being used in this legal entity.Microsoft Learn
Import onlyBlocks manual entry for the category, so only imported items can use it.Microsoft Learn isImportOnly
Main accountThe expense account debited when an expense report with this category is posted.Microsoft Learn 610100LedgerDimension
Use in ProjectLets the category be used in projects; off by default.Microsoft Learn UseInProject
Item sales tax groupThe tax group used when the expense is taxable.Microsoft Learn
Category nameThe name of the expense category that workers choose on expense lines.Microsoft Learn Expense categoryCategoryName

Common errors and fixes

MessageWhat to do
Itemize isn't offered on an expenseItemization works only for categories with subcategories; with Itemization mandatory the expense must be itemized before submit. Microsoft Learn
Mileage amounts don't follow the tiersFrom 10.0.18 a tier's quantity is the upper limit. Turn on Mileage calculation improvements when using mileage rate tiers and reset the tiers so each Quantity is the upper limit. Microsoft Learn

Test checklist

  1. Create a Hotel expense category from its shared category with a Main account, Default payment method and Itemization mandatory = Yes.
  2. Enter a hotel expense and check it must be itemized by subcategory before the report can be submitted.
  3. Post the report and check the voucher debits the category's main account (or the subcategory account).
  4. Set the category to Inactive and check it no longer appears on new expense lines.
  5. For Mileage, set up rate tiers under Category setup and enter a mileage expense crossing the first tier; check the two rates are applied.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Expense categoriesOne expense category per shared category used in the legal entity, each with a Main account, a Default payment method and its Allowed payment methods; Use in Project = Yes only where the shared category allows Project, with cost and revenue accounts filled inLearn says the expense category defines the ledger account the expense is booked to, the Default payment method is mandatory, and Use in Project can only be turned on when the shared category has Can be used in Project set to Yes.Should expense categories be shared with Project management and accounting?Turning on the Mileage calculation improvements when using mileage rate tiers feature without resetting the Mileage category tiers. The Quantity field becomes the upper limit of each tier instead of the lower limit, so old tiers calculate the wrong rate.Test: Mileage tiers after the mileage improvements feature

Feature management and licence

Feature to turn onMileage calculation improvements when using mileage rate tiers (Optional)Ability to itemize recurring expenses quickly (Optional)

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: Use the Inactive check box to stop a category from being used in the legal entity; the main account and payment method settings drive how new expenses post.
If you change it laterAfter the Mileage calculation improvements when using mileage rate tiers feature is turned on, the mileage tiers on a category must be reset because the Quantity field now works as an upper limit. Microsoft Learn
Technical architect

6Technical

Menu itemTrvCostType Checked in Dynamics 365
FormProjCategory Checked in Dynamics 365
TableCategoryTableShown as “Category table” in Record infoKey field: CategoryIdChecked in Dynamics 365
Data entitiesCategoryEntityCategory table Microsoft data model ProjCDSCategoryEntityIntegration entity for categories 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, 14 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=TrvCostType
Integrate withCategoryEntity data entity Microsoft data model
Data migrationCategoryEntity (Category table): loaded for each company, in Microsoft's default template 410 - Production control.Load order: Microsoft's default template 410 - Production control loads Category table at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: Shared category, the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionCategoryTable columns and relations Microsoft data model
Everyone

8Sources