BeyondERP.Newsletter
Menu

Setup page · Expense management

Per diem locations

A setup page where you add the locations where per diems can be used and set their per diem rate tiers.

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
TrvLocations
Main table
TrvLocations
Data entity
TrvPerDiemLocationsEntity
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 add the locations where per diems can be used and set their per diem rate tiers.
What you do hereUse this page to list the locations per diems can be paid for and to set each location's rate tiers, which split the daily allowance into hotel, meal and other percentages; the daily amounts are entered on Per diems.
ExampleFor example, a Redmond (USA) location might carry a daily allowance of USD 150 for lodging, USD 75 for meals and USD 5 for incidentals.
Per diem locations 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 › Per diem locations
Set up firstExpense management parameters (Per diem tab) Microsoft Learn
Used next byPer diems Microsoft Learn Set up Per diems
Related pagesExpense management parameters 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 Per diem locations1 screen

Use this page to list per diem locations and define how a daily allowance splits between hotel, meals and other costs.

  1. Screen 1

    Create a per diem location

    Go to Expense management > Setup > Calculations and codes > Per diem locations

    1. Select New
    2. Select the country or region
    3. Enter the location name
    4. Select Save
    1LocationBEAT-LOC
    Country/regionGBR
    Create a per diem location (zoomed on the outlined fields)
    Show the full screenCreate a per diem location
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Expense management > Setup > Calculations and codes > Per diem locations.
  2. Add the locations where per diems can be used.
  3. For each location, on the Per diems tab, select the per diem rate and currency valid between a start and end date.
  4. Set up the per diem rate tiers for the location.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Country/regionThe country or region of the location.Microsoft Learn GBRCountryRegionId
LocationThe location that per diem rates can be set for.Microsoft Learn NEWYORKLocation

Common errors and fixes

MessageWhat to do
A location isn't offered on the per diemAdd the location here and give it rates on Per diems. Microsoft Learn

Test checklist

  1. Add a location with Country/region and a rate tier using the Minimum hours default from the parameters.
  2. Add a rate for the location on the Per diems page.
  3. Enter a multi-day Per diem expense for the location and check the first and last days use the Meal, Hotel and Other percent from the parameters.
  4. Enter a multi-day per diem with a complimentary lunch and check the lunch reduction is applied.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Per diem locationsEvery location your travel policy pays a per diem for, each with rate tiers that split the daily allowance between hotel, meals and otherLearn configures per diems by adding the locations, then defining rate tiers on each location for the percentage split of the daily allowance; the minimum hours default comes from Expense management parameters.How detailed are per diem locations?Leaving out rate tiers. Learn says the meal reduction is calculated from the per diem rate tiers, so without them the per diem can't be reduced correctly for complimentary meals or short days.Test: A location's tiers split the allowance

Feature management and licence

Feature to turn onPer-diem for expense report re-imagined interface (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 locations.

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: Locations and rate tiers drive the calculation when an employee enters a per diem; they can be maintained at any time. Microsoft Learn
If you change it laterThe rate tiers decide the percentage split of the daily allowance and the meal reduction used when a per diem is calculated. Microsoft Learn
Technical architect

6Technical

Menu itemTrvLocations Checked in Dynamics 365
FormTrvLocations Checked in Dynamics 365
TableTrvLocationsShown as “Travel locations” in Record infoChecked in Dynamics 365
Data entitiesTrvPerDiemLocationsEntityPer diem locations Microsoft data model
Who can open itPrivilegesMaintain per diem rates used during expense entry TrvPerDiemMaintainView per diem rates used during expense entry TrvPerDiemViewDutiesMaintain 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 TrvTravelAndExpenseProcessEnableMaintain expense management process TrvTravelAndExpenseProcessMaintainInquire 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=TrvLocations
Integrate withTrvPerDiemLocationsEntity data entity Microsoft data model
Data migrationTrvPerDiemLocationsEntity (Per diem locations): loaded for each company, in Microsoft's default template 600 - Expense.Load order: Microsoft's default template 600 - Expense loads Per diem locations 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 definitionTrvLocations columns and relations Microsoft data model
Everyone

8Sources