BeyondERP.Newsletter
Menu

Setup page · Expense management

Merchants

A setup page where you set up the merchants that workers can select when they enter expenses on expense reports.

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
TrvExpMerchant
Main table
TrvExpMerchant
Data entity
TrvExpenseMerchantEntity
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 set up the merchants that workers can select when they enter expenses on expense reports.
What you do hereUse this page to give employees a list of merchants to pick on expenses, and to mark preferred merchants; the list is optional.
ExampleFor example, the company has negotiated rates with two hotel chains; listing them as preferred merchants for the Hotel expense type helps employees and approvers see when a booking is outside the agreement.
Merchants 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 › Optional setup › Merchants
Set up firstExpense categories Microsoft Learn
Used next byExpenses Microsoft Learn
Related pagesExpense report policies 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 Merchants1 screen

Offer a list of merchants, with preferred ones marked.

  1. Screen 1

    Add a merchant

    Go to Expense management > Setup > Optional setup > Merchants

    1. Select New
    2. Enter the merchant name
    3. Optionally select an expense type and mark the merchant as preferred
    4. Select Save
    MerchantMerchant
    Add a merchant (zoomed on the outlined fields)
    Show the full screenAdd a merchant
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Expense management > Setup > Optional setup > Merchants.
  2. Select New.
  3. Enter the merchant, choose the expense type, and mark Preferred if the company prefers it.
  4. Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
MerchantThe merchant that workers can choose on expense lines.Microsoft Learn MerchantMerchantId
Expense typeThe expense type the merchant is used for.Checked in Dynamics 365Hotel
PreferredMarks a merchant the company prefers employees to use.Checked in Dynamics 365Yes

Common errors and fixes

MessageWhat to do
The merchant isn't offeredCheck the merchant's expense type matches the expense. Microsoft Learn

Test checklist

  1. Add a merchant for the Hotel type and mark it Preferred.
  2. Enter a hotel expense.
  3. Check the merchant is offered.
  4. Check an imported card line keeps the merchant from the file.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up MerchantsList preferred merchants for categories with negotiated rates; leave the rest to free entry.A preferred merchant shows employees and approvers which suppliers the company wants used.Maintain a merchant list?Trying to keep every merchant here; card lines bring their merchant from the file.Test: A preferred merchant is offered

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 list. 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: Merchants can be added or removed at any time. Microsoft Learn
If you change it laterIf no merchants are set up, workers can enter any merchant. Microsoft Learn
Technical architect

6Technical

Menu itemTrvExpMerchant Checked in Dynamics 365
FormTrvExpMerchant Checked in Dynamics 365
TableTrvExpMerchantShown as “Merchant” in Record infoChecked in Dynamics 365
Data entitiesTrvExpenseMerchantEntityMerchant Microsoft data model
Who can open itPrivilegesMaintain merchants available during expense entry TrvExpMerchantMaintainView merchants available during expense entry TrvExpMerchantViewDutiesMaintain 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=TrvExpMerchant
Integrate withTrvExpenseMerchantEntity data entity Microsoft data model
Data migrationTrvExpenseMerchantEntity (Merchant): loaded for each company, in Microsoft's default template 600 - Expense.Load order: Microsoft's default template 600 - Expense loads Merchant at execution unit 1, level 30, sequence 10. 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 General ledger)Microsoft Learn
Table definitionTrvExpMerchant columns and relations Microsoft data model
Everyone

8Sources