BeyondERP.Newsletter
Menu

Setup step on the Lease movements page · Asset leasing

Run the Lease movements report

Produce the Lease movements figures for the period you report.

Business process
Analyze asset leases
Menu item
AssetLeaseMovementRPAction
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 rollforward report of the lease liability balance for each lease.
What you do hereUse this report to see a lease's liability transactions (initial recognition, payments, interest and adjustments) during a period you specify.
ExampleFor example, at the end of Q1 the BEAT controller runs it from 1/1 to 3/31 and ties the ending lease liability per book to the lease liability accounts in the trial balance.
Lease movements 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.

When to run it

When to run itAt period end, after lease payments and interest for the period are posted, to reconcile the lease liability.
How oftenMonthly or at each period end close.
What the output showsA liability rollforward per lease: Payments remaining, Beginning balance, Initial recognition, Payments (negative), Interest, Adjustments and Ending balance. An ending balance that doesn't match the ledger usually means journal entries that were created but not posted, or entries posted outside Asset leasing.

Source: Microsoft Learn

Setup steps on this page

Run the Lease movements report

Produce the Lease movements figures for the period you report.

Steps from Microsoft

  1. Go to Asset leasing > Inquiries and reports > Lease reports > Lease movements.
  2. Enter the From date and To date of the period you want to roll forward, usually the fiscal period or year you close.
  3. Filter on the leases or lease groups you want to reconcile.
  4. For each lease, check that Beginning balance plus Initial recognition, Payments, Interest and Adjustments equals the Ending balance, and compare the total with the lease liability account in the ledger.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Payments remainingThe number of lease payments not yet posted.Microsoft Learn
Beginning balanceThe liability balance from all transactions before the report start date.Microsoft Learn
Initial recognitionAny initial recognition amount posted within the report dates.Microsoft Learn
PaymentsPayment transactions posted within the report dates, shown as negative amounts.Microsoft Learn
InterestInterest accruals posted within the report dates.Microsoft Learn
AdjustmentsAdjustment transactions posted within the report dates.Microsoft Learn
Ending balanceThe liability balance of all posted transactions as of the To date.Microsoft Learn

Common errors and fixes

MessageWhat to do
The report shows lower figures than expectedJournals for the period aren't posted yet, or a schedule isn't confirmed. Post the period's journals and run it again. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Lease movements reportRun it for the period's From and To dates after all lease journals are posted, and reconcile the ending balance with the lease liability accounts.It rolls the liability forward (beginning balance, initial recognition, payments, interest, adjustments, ending balance), so every posted movement shows and an unposted one shows as a difference.How is the lease liability reconciled each period?Reconciling before the period's payment and interest journals are posted.Test: Liability rollforward ties to the ledger

Feature management and licence

Feature to turn onAsset leasing (Must be on)Multi-company purpose (Optional)
Licence or add-inAsset leasing must be turned on in Feature management (feature Asset leasing). Microsoft Learn describes three Asset leasing roles: Maintain lease (add, edit and post leases), View lease (view leases and schedules and run reports) and Lease clerk (create new leases only). View lease users run it, as do Maintain lease users.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyRuns for the legal entities you select. With the Multi-company purpose feature (version 10.0.44) the legal entities are picked from an organization hierarchy. Microsoft Learn
Can it be undoneReversible: The report changes no data.
If you change it laterThe report reads the posted lease schedules and changes nothing. Its figures change only when journals are posted, reversed or a lease is adjusted, so run it after the period's journals are posted. Microsoft Learn
Technical architect

6Technical

Menu itemAssetLeaseMovementRPAction Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itLease accountant AssetLeaseLeaseMaintainAccountant LedgerAccountantLease manager AssetLeaseLeaseViewAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=AssetLeaseMovementRPAction
Data migrationLoad order: The Lease movements report has no data entity in Data management, so it can't be loaded from a file or a configuration template. A report stores no data; it reads the lease books and schedules, so migrate the leases instead.Microsoft Learn
Everyone

8Sources

To cite this step: AL-RPT-020, Run the Lease movements report. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/AL-RPT-020