BeyondERP.Newsletter
Menu

Setup page · Expense management

Expenditure reviewers

A setup page where you define expenditure reviewers that route expense reports for review based on a project role or the owner of a financial dimension.

Used by
Expense administrator
Business process
Develop people strategy
Menu item
action:TrvWorkflowParticipantProviderExpenToken
Main table
WorkflowParticipantExpenToken
Data entity
None for this page's own settings
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 define expenditure reviewers that route expense reports for review based on a project role or the owner of a financial dimension.
What you do hereUse this page to give expense workflows a dynamic reviewer, set per legal entity, for tasks, approvals and manual decisions.
ExampleFor example, instead of a workflow condition for each cost center, you set an owner on each cost center value and the expenditure reviewer picks the right approver.
Expenditure reviewers 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 Expenditure reviewers1 screen

Use this page to give expense workflows a dynamic reviewer, set per legal entity, for tasks, approvals and manual decisions.

  1. Screen 1

    Create an expenditure reviewer token

    Go to Expense management > Setup > Policies > Expenditure reviewers

    1. Select New
    2. Enter the reviewer name
    3. Select Save
    4. For each legal entity, choose the project authority or organization distribution that supplies the reviewer
    1NameBEAT-REV
    Create an expenditure reviewer token (zoomed on the outlined fields)
    Show the full screenCreate an expenditure reviewer token
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Expense management > Setup > Policies > Expenditure reviewers.
  2. Select New.
  3. In the Name field, enter a name for the reviewer configuration, such as cost center.
  4. On the Expenditure reviewers by legal entity FastTab, select the legal entity.
  5. For a project distribution, select each project authority and set each financial dimension to use to Yes.
  6. For an organization distribution, on the Organization distributions tab, set each financial dimension to use to Yes.
  7. Repeat for each other legal entity.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
NameThe name of the expenditure reviewer configuration.Microsoft Learn ReviewersName
Project distributionsRoutes by project authority (project manager, controller or sales manager) or by project financial dimensions.Microsoft Learn
Organization distributionsRoutes by the financial dimensions on the document.Microsoft Learn

Common errors and fixes

MessageWhat to do
The workflow finds no reviewerThe dimension value on the report has no Owner, or the project has no person in the chosen role. Fill the owner or the project's Responsible fields. Microsoft Learn

Test checklist

  1. Create a reviewer named Cost center, and for the legal entity set the Cost center dimension to Yes on Organization distributions.
  2. On General ledger > Chart of accounts > Dimensions > Financial dimensions > Dimension values, set an Owner on the test cost center.
  3. In the expense report workflow, assign the approval to Participant > Expenditure participants > Cost center.
  4. Submit an expense report charged to that cost center and check the approval goes to the owner's user.
  5. Change the Owner and check the next submitted report goes to the new owner.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Expenditure reviewersOrganization distributions on the dimension that owns the budget (for example Cost center), with an Owner set on every value of that dimension; add Project distributions (project manager) where project expenses need the project's approvalLearn recommends expenditure reviewers so you don't need one workflow condition per cost center: the workflow picks the dimension value's owner, and when ownership changes you only update the Owner field.Route by dimension owner or by project role?Dimension values without an Owner, or projects without a Project manager. The reviewer is resolved from those fields, so the workflow has no one to assign; Learn also advises a conditional decision when not every document has a project.Test: A report goes to the cost center owner

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 reviewer configurations for each legal entity. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneReversible: Reviewer configurations, dimension owners and project managers can be changed at any time; new workflow steps pick up the current owner. Microsoft Learn
If you change it laterWhen cost center ownership changes, you only update the Owner field on the financial dimension value; the workflow doesn't need to change. Microsoft Learn
Technical architect

6Technical

Menu itemaction:TrvWorkflowParticipantProviderExpenToken Checked in Dynamics 365
FormWorkflowParticipantExpenToken Checked in Dynamics 365
TableWorkflowParticipantExpenTokenShown as “Workflow participant expenditure token” in Record infoChecked in Dynamics 365
Data entitiesPurchPurchaseRequisitionExpenditureReviewerConfigurationEntityPurchase requisition expenditure reviewer configurations (backed by WorkflowParticipantExpenToken, the table this page edits; its name comes from purchase requisitions, which share the table) Microsoft data model
Who can open itPrivilegesMaintain expense management policies TrvPolicyDetailsMaintainDutiesEnable expense management process TrvTravelAndExpenseProcessEnable
1 security roleExpense administrator ExpenseAdministrator
Checked in Dynamics 365
Roles to set it up and use itTo use itExpense administrator ExpenseAdministratorGive people one of these roles. On this system, 1 role can run 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=action:TrvWorkflowParticipantProviderExpenToken
Data migrationPurchPurchaseRequisitionExpenditureReviewerConfigurationEntity (Expenditure reviewer configuration): loads the reviewer configurations.Load order: Load dimension value owners and project authorities first, then the configurations, then the workflows that use them.Load first: Financial dimension owners, Project authoritiesMicrosoft Learn
Table definitionWorkflowParticipantExpenToken columns and relations Microsoft data model
Everyone

8Sources