BeyondERP.Newsletter
Menu

Setup page · Expense management

Credit card category codes

A setup page where, for each credit card type, you map the categories in the card provider's file to expense categories.

Used by
Business Performance Planning app role, Data management administrator, Data management migration user and 3 more roles
Business process
Develop people strategy
Menu item
TrvPBSCatCodes
Main table
TrvPBSCatCodes
Data entity
TrvCreditCardCodeEntity
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, for each credit card type, you map the categories in the card provider's file to expense categories.
What you do hereUse this page so imported card transactions arrive with the right expense category: for each card type, map the provider's category codes to expense categories.
ExampleFor example, the provider sends category code 3501 for hotels and 4511 for airlines; mapping them to the Hotel and Airfare expense categories means employees find their card lines already categorized.
Credit card category 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 › Credit card category codes
Set up firstCredit card types Microsoft Learn Expense categories Microsoft Learn Set up Credit card typesSet up Expense categories
Used next byCredit card transactions Microsoft Learn
Related pagesCredit card transactions 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 Credit card category codes1 screen

It is used so that imported card transactions arrive with the right expense category.

  1. Screen 1

    Map a card category code to an expense category

    Go to Expense management > Setup > Calculations and codes > Credit card category codes

    1. Make sure the credit card type and the expense category exist
    2. Select New
    3. Select the card type
    4. Enter the category code and a description
    5. Select the expense category it maps to
    6. Select Save
    1CategoryBEAT-CC
    Card typeBEAT-CT
    DescriptionCard category code
    Expense categoryBEAT-ESC
    Map a card category code to an expense category (zoomed on the outlined fields)
    Show the full screenMap a card category code to an expense category
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Expense management > Setup > Calculations and codes > Credit card category codes.
  2. Select New and choose the card type.
  3. Enter the provider's category code and a description.
  4. Select the expense category it maps to, and save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Card typeThe credit card type that the category code belongs to.Microsoft Learn CORPORATECardType
CategoryThe category code that the card provider sends with a transaction.Microsoft Learn AIRLINECatCode
DescriptionA short description of the provider category code.Microsoft Learn Card category codeCatCodeDesc
Expense categoryThe expense category that transactions with this provider category are mapped to.Microsoft Learn HOTELCostType

Common errors and fixes

MessageWhat to do
Card lines arrive without an expense categoryThe provider's category code isn't mapped for that card type. Add the mapping and import again. Microsoft Learn

Test checklist

  1. For card type Visa, map the provider's airline and meal codes to the Flights and Meals expense categories.
  2. Import a test file with one airline and one meal transaction for an employee's card.
  3. In the employee's expense report, select Add unattached expenses and check both lines carry the mapped expense categories.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Credit card category codesFor each credit card type, map every category code that appears in that provider's file to an expense categoryLearn sets the mapping per credit card type so that imported card transactions arrive with the right expense category on the expense lines.How fine is the category mapping?Mapping codes for one card type only. The mapping is per card type, so a code mapped under Visa doesn't apply to MasterCard transactions.Test: A mapped code sets the category

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 maintains the mapping. No Feature management feature is needed for this page.

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: Mappings are used when card transactions are imported, so they can be corrected before the next import. Microsoft Learn
If you change it laterThe mapping is applied when transactions are imported; transactions already imported keep their category. Microsoft Learn
Technical architect

6Technical

Menu itemTrvPBSCatCodes Checked in Dynamics 365
FormTrvPBSCatCodes Checked in Dynamics 365
TableTrvPBSCatCodesShown as “Credit card category codes” in Record infoChecked in Dynamics 365
Data entitiesTrvCreditCardCodeEntityCredit card category codes Microsoft data model
Who can open itPrivilegesMaintain credit card category codes TrvPBSCatCodesMaintainView credit card category codes TrvPBSCatCodesViewDutiesMaintain Master entity data for data management DataManagementApplicationMasterEntitiesMaintainView Master entity data for data management DataManagementApplicationMasterEntitiesViewMaintain Reference entity data for data management DataManagementApplicationReferenceEntitiesMaintainView Reference entity data for data management DataManagementApplicationReferenceEntitiesViewEnable expense management process TrvTravelAndExpenseProcessEnableInquire into expense management reference data TrvTravelAndExpenseReferenceDataInquire
6 security rolesBusiness Performance Planning app role BPPBudgetPlanningAppRoleData management administrator DataManagementAdministratorData management migration user DataManagementMigrationUserExpense administrator ExpenseAdministratorDemand planning app role ScpDemandPlanningAppRoleInformation technology manager SysServerITManager
Checked in Dynamics 365
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 ScpDemandPlanningAppRoleGive people one of these roles. On this system, 6 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=TrvPBSCatCodes
Integrate withTrvCreditCardCodeEntity data entity Microsoft data model
Data migrationTrvCreditCardCodeEntity (Credit card category codes): loaded for each company, in Microsoft's default template 600 - Expense.Load order: Microsoft's default template 600 - Expense loads Credit card category codes at execution unit 1, level 600, sequence 40. 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 Retail)Microsoft Learn
Table definitionTrvPBSCatCodes columns and relations Microsoft data model
Everyone

8Sources