BeyondERP.Newsletter
Menu

Setup step on the Expense management parameters page · Expense management

Set up Expense management parameters

Use this page to set defaults across the module, such as the mileage rate, posting journal, tax recovery, per diem rules, number sequences and anti-corruption messages.

Used by
Auditor, Business Performance Planning app role, Data management administrator and 6 more roles
Business process
Develop people strategy
Menu item
TrvParameters
Main table
TrvParameters
Data entity
TrvExpenseParametersEntity
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 that holds the main settings for Expense management.
What you do hereUse this page to set defaults across the module, such as the mileage rate, posting journal, tax recovery, per diem rules, number sequences and anti-corruption messages.
ExampleFor example, if employees get a complimentary breakfast, the per diem can be reduced by 10 percent through the breakfast reduction setting.
Expense management parameters 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 › General › Expense management parameters
Set up firstJournal names Microsoft Learn Set up Journal names
Used next byExpense report policies Microsoft Learn
Related pagesPurpose of expense report Microsoft Learn Per diem locations Microsoft Learn
In this process Set up Leave types · Set up Absence groups
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 management parameters1 screen

Use this page to set defaults across the module, such as the mileage rate, posting journal, tax recovery, per diem rules, number sequences and anti-corruption messages.

  1. Screen 1

    Review the expense management parameters

    Go to Expense management > Setup > General > Expense management parameters

    1. Open the page and review the General tab
    2. Use the other tabs to set the posting, per diem, number sequence and anti-corruption defaults
    1Standard rate of mileage0.000
    2Evaluate expense management policiesOn line save
    3Validate expense purposeNo
    4Personal expenses paid byPaid by employee
    Review the expense management parameters (zoomed on the outlined fields)
    Show the full screenReview the expense management parameters
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Expense management > Setup > General > Expense management parameters.
  2. Select the Per diem tab.
  3. In the Calculate meal reduction by field, select Meal type per trip, Meal type per day or Number of meals per day.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Standard rate of mileageThe rate multiplied by the miles entered to work out the mileage refund.Microsoft Learn 0.000KmPrice
Validate expense purposeLimits users to the set list of expense report purposes.Microsoft Learn NoValidateTravelPurpose
Personal expenses paid byWho pays card amounts marked as personal.Microsoft Learn Paid by employee
Preauthorization of travel is mandatoryRequires an approved travel requisition before an expense report can be submitted.Microsoft Learn IsTravelRequisitionMandatoryForExpense
Evaluate expense management policiesWhen policies are checked: when a line is saved or when the report is submitted.Microsoft Learn On line save
Allow intercompany expense linesLets employees enter expenses for other legal entities on a report.Microsoft Learn UseInterCompanyExpense
Ledger daily journal nameThe journal that approved expense reports are posted to.Microsoft Learn GlWorkSheet
Enable tax recovery from expensesTurns on tax recovery for eligible expenses.Microsoft Learn EnableTaxRecovery
Post cash advances immediatelyPosts an approved cash advance when Pay and transfer completes.Microsoft Learn PostImmediately
Correct accounting date during postingMoves the accounting date to the next open period if the current one is on hold or closed.Microsoft Learn IsAllowUpdateAccountingDate
Calculate meal reduction byHow the per diem meal reduction is worked out.Microsoft Learn MealReductionType
Display anti-corruption attestationShows the anti-corruption text when an expense report is created.Microsoft Learn UseAntiCorruption
Enter employee credit card numberWhether a 15- or 16-character Card ID can be saved on an employee's Credit cards page.Microsoft Learn 16
Enable posting of expenses on posting datePosts expenses with the expense report's posting date (from 10.0.45); with Correct accounting date during posting on, a closed period moves to the first date of the next open period.Microsoft Learn
Allow expense report submit on budget overrun for budget register and project budgetLets employees submit reports that go over the budget register or project budget.Microsoft Learn

Common errors and fixes

MessageWhat to do
Posting fails because the accounting date is in a period that is on hold or closedTurn on Correct accounting date during posting on the Financial tab of Expense management parameters, so the date moves to the next open period, or open the period. Microsoft Learn
Enable tax recovery from expenses can't be selectedIt can't be used when US sales tax and use tax rules are enabled. Decide on tax recovery before you turn on the US sales tax rules. Microsoft Learn
Card numbers can't be saved on the employee's Credit cards pageEnter employee credit card number sets whether a 15- or 16-character Card ID is accepted. Match it to the card provider. Microsoft Learn
Submit or approval is blocked because the expense goes over the budgetCheck the budget. The parameters Allow expense report submit on budget overrun and Allow expense report approval on budget overrun decide whether employees and approvers may continue. Microsoft Learn

Test checklist

  1. Set Ledger daily journal name and Correct accounting date during posting = Yes.
  2. Put the current period on hold, then approve and post an expense report dated in it.
  3. Check the voucher date moved to the next open period.
  4. Approve a cash advance, run Pay and transfer and check a posted voucher or an unposted journal according to Post cash advances immediately.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Expense management parametersSet the Ledger daily journal name, Correct accounting date during posting = Yes, Evaluate expense management policies = on line save, and decide tax recovery and intercompany before the first report is entered.These parameters decide where reports post, what happens in a closed period, when employees see policy messages, and whether tax recovery and intercompany lines are possible; tax recovery can't be turned on once US sales tax rules are used.Should approved cash advances post immediately?Expecting Enable tax recovery from expenses to work in a legal entity that uses US sales tax and use tax rules; Learn says the option can't be selected there.Test: Parameters drive posting and policy checks

Number sequences

ReferenceShared or per companyNote
Cash advance request numberPer companyBEAT uses number sequence Trav_5. Checked in Dynamics 365
Tax recovery numberPer companyBEAT uses number sequence Trav_9. Checked in Dynamics 365
VoucherPer companyBEAT uses number sequence Trav_13. Checked in Dynamics 365
InvoicePer companyBEAT uses number sequence Trav_17. Checked in Dynamics 365
Expense report numberPer legal entityBEAT uses number sequence Trav_22. Checked in Dynamics 365
Travel requisition numberPer legal entityBEAT uses number sequence Trav_26. Checked in Dynamics 365
Itemization groupSharedExpenseItemizationGroupId, shared across all legal entities and shown on the Shared number sequence tab; BEAT uses Trav_1. Microsoft Learn

Feature management and licence

Feature to turn onEnable number sequence configuration in the Expense parameters form (Optional)Expense reports reimagined (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 the parameters. From 10.0.45 the Number sequence and Shared number sequence tabs show the expense number sequences here; they don't change how sequences are used.

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: Parameters apply to expense reports, cash advances and postings processed after the change; posted expenses keep their accounting dates and journals.
If you change it laterEnable tax recovery from expenses can't be turned on when US sales tax and use tax rules are enabled. Microsoft Learn
Technical architect

6Technical

Menu itemTrvParameters Checked in Dynamics 365
FormTrvParameters Checked in Dynamics 365
TableTrvParametersShown as “Parameters” in Record infoChecked in Dynamics 365
Data entitiesTrvExpenseParametersEntityExpense management parameters Microsoft data model
Who can open itPrivilegesMaintain parameter settings for expense management TrvParametersMaintainView parameter settings for expense management TrvParametersViewDutiesMaintain Parameters entity data for data management DataManagementApplicationParametersEntitiesMaintainView Parameters entity data for data management DataManagementApplicationParametersEntitiesView ExpenseAgentDuty ExpenseAgentV2DutyInquire into expense management policies TrvTravelAndExpensePoliciesInquireEnable expense management process TrvTravelAndExpenseProcessEnableInquire into expense management reference data TrvTravelAndExpenseReferenceDataInquireMaintain travel requisitions and expenses TrvTravelRequestsAndExpensesMaintain
10 security rolesAuditor AuditPolicyManagerBusiness Performance Planning app role BPPBudgetPlanningAppRoleData management administrator DataManagementAdministratorData management migration user DataManagementMigrationUserExpense administrator ExpenseAdministrator ExpenseAgentRoleContractor HcmContractorEmployee HCMEmployeeDemand 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 ScpDemandPlanningAppRoleTo use itContractor HcmContractorEmployee HCMEmployeeExpenseAgentRole ExpenseAgentV2Role Auditor AuditPolicyManagerGive people one of these roles. On this system, 11 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=TrvParameters
Integrate withTrvExpenseParametersEntity data entity Microsoft data model
Data migrationTrvExpenseParametersEntity (Expense management parameters): loaded for each company, in Microsoft's default template 600 - Expense.Load order: Microsoft's default template 600 - Expense loads Expense management parameters at execution unit 1, level 600, 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 Retail)Microsoft Learn
Table definitionTrvParameters columns and relations Microsoft data model
Everyone

8Sources