BeyondERP.Newsletter
Menu

Job page · Expense management

Update expense payment information

A periodic job that updates the payment information on expense reports after the employee has been paid through accounts payable.

Business process
Manage time and attendance
Menu item
action:TrvExpPaymentDetailsBatch
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 periodic job that updates the payment information on expense reports after the employee has been paid through accounts payable.
What you do hereUse this job, usually as a recurring batch after payment runs, so expense reports show that they are paid.
ExampleFor example, after the Friday vendor payment run pays 45 employees, the job runs at night and the next morning the 45 expense reports show their payment details.
Update expense payment information 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 processManage time and attendance
Menu pathExpense management › Periodic tasks › Update expense payment information
Set up firstVendor payment journal Microsoft Learn Approved expense reports Microsoft Learn
Used next byAll expense reports Microsoft Learn
Related pagesBatch jobs 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.

When to run it

When to run itAfter vendor payments that reimburse employees are posted.
How oftenAfter each payment run, usually as a recurring batch.
Batch settingsSchedule it as a recurring batch that runs after the payment runs.
What the output showsUpdated payment information on expense reports. A paid report that still shows as unpaid usually means the job hasn't run since the payment was posted.

Source: Microsoft Learn

Setup steps on this page

Bring payment status back to expense reports

Show employees that their reports are paid.

Steps from Microsoft

  1. Go to Expense management > Periodic tasks > Update expense payment information.
  2. The dialog has no selection fields; the job updates payment information on posted expense reports.
  3. Run it after payments to employees have been made, so the expense reports show their payment status.
  4. Afterwards, open a recently paid expense report and confirm that the payment information is filled in.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Run in the backgroundThe dialog has no selection fields; set the batch recurrence here.Checked in Dynamics 365Daily, after the payment run

Common errors and fixes

MessageWhat to do
A paid report still shows as unpaidThe job hasn't run since the payment was posted. Run it, or check its batch job. Microsoft Learn

Test checklist

  1. Post an expense report and pay the employee in a vendor payment journal.
  2. Run Update expense payment information.
  3. Open the report and check the payment details are filled.
  4. Check a report that wasn't paid is unchanged.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Bring payment status back to expense reportsSchedule it as a recurring batch shortly after each payment run.Without it, employees can't see from the report that they were paid and ask accounts payable instead.When does the job run?Running it before the payment journal is posted, so nothing is updated.Test: Payment details reach the report

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 schedules this job. No Feature management feature is needed.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the job updates the expense reports of the legal entity it runs in. Checked in Dynamics 365
Can it be undoneNothing to undo: The job only refreshes payment information from posted payments; run it again if payments change. Microsoft Learn
If you change it laterPosting an expense report creates the amount owed to the employee; the payment itself is made in accounts payable, and this job brings the payment details back to the report. Microsoft Learn
Technical architect

6Technical

Menu itemaction:TrvExpPaymentDetailsBatch Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Data entitiesTrvExpPaymentDetailsEntityExpense payment details (the payment details this job writes; the job itself has no entity) Microsoft data model
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
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=action:TrvExpPaymentDetailsBatch
Data migrationLoad order: The job has no data entity in Data management, so it can't be loaded from a file or a configuration template. It processes data that is already in the system and keeps only its batch settings; set up and schedule it again in each environment.Microsoft Learn
Everyone

8Sources