BeyondERP.Newsletter
Menu

Report page · Asset leasing

Asset movement

A rollforward report of the right-of-use asset balance for each lease.

Business process
Analyze asset leases
Menu item
AssetLeaseAssetMovement
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 rollforward report of the right-of-use asset balance for each lease.
What you do hereUse this page to set the filters and print the right-of-use asset transactions of leases for a chosen period.
ExampleFor example, at year end the BEAT controller runs it from 1/1 to 12/31 to tie the right-of-use net book value per book to the right-of-use asset and accumulated depreciation accounts.
Asset movement 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 processAnalyze assets › Analyze asset leases
Menu pathAsset leasing › Inquiries and reports › Lease reports › Asset movement
Set up firstBatch journal creation Microsoft Learn
Used next byLease transactions (find differences) Microsoft Learn
Related pagesLease movements 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 itAt period end, after depreciation for the period is posted, to reconcile the right-of-use assets.
How oftenMonthly or at each period end close.
What the output showsA right-of-use asset rollforward per lease: Initial right of use asset, Beginning balance, Period depreciation expense, Accumulated depreciation, Impairment, Modifications (a count of adjustments) and Net book value. A net book value that doesn't match the ledger usually means depreciation entries that are not posted.

Source: Microsoft Learn

Setup steps on this page

Run the Asset movement report

Produce the Asset movement figures for the period you report.

Steps from Microsoft

  1. Go to Asset leasing > Inquiries and reports > Lease reports > Asset movement.
  2. Enter the From date and To date of the period to roll forward.
  3. Filter on the leases or lease groups whose right-of-use assets you want to reconcile.
  4. For each lease, follow Beginning balance through Period depreciation expense and Impairment to Net book value, and compare the total with the right-of-use asset accounts in the ledger.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Initial right of use assetThe original right-of-use asset value from the initial recognition journal entry.Microsoft Learn
Beginning balanceThe net book value of the right-of-use asset as of the From date.Microsoft Learn
Period depreciation expenseThe depreciation expense taken within the report date range.Microsoft Learn
Accumulated depreciationThe accumulated depreciation as of the From date.Microsoft Learn
ImpairmentThe amount the asset was impaired within the report date range.Microsoft Learn
ModificationsThe number of adjustments to the right-of-use asset between the report dates.Microsoft Learn
Net book valueThe ending net book value of the right-of-use asset 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
Depreciation is missing for a leaseThe lease is linked to a fixed asset; its depreciation posts from Fixed assets. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Asset movement reportRun it for the period after depreciation and impairment journals are posted, and reconcile the net book value with the right-of-use accounts.It rolls the right-of-use asset forward (beginning balance, depreciation, impairment, modifications, net book value), the asset-side twin of Lease movements.Where is the right-of-use asset kept?Expecting leases linked to a fixed asset to depreciate here: their depreciation runs in Fixed assets.Test: Right-of-use 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 undoneNothing to undo: The report only reads right-of-use asset transactions; it changes nothing. Microsoft Learn
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 itemAssetLeaseAssetMovement 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=AssetLeaseAssetMovement
Data migrationLoad order: The Asset movement 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

KEEP EXPLORING

More in Asset leasing.

Open the other pages and setup steps in this module, or go back to the Atlas Hub to search every page.