SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
A rollforward report of the right-of-use asset balance for each lease.
What you do here
Use this page to set the filters and print the right-of-use asset transactions of leases for a chosen period.
Example
For 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.
The page in Dynamics 365. page title tab to open what to set or check
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 it
At period end, after depreciation for the period is posted, to reconcile the right-of-use assets.
How often
Monthly or at each period end close.
What the output shows
A 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.
Produce the Asset movement figures for the period you report.
Steps from Microsoft
Go to Asset leasing > Inquiries and reports > Lease reports > Asset movement.
Enter the From date and To date of the period to roll forward.
Filter on the leases or lease groups whose right-of-use assets you want to reconcile.
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.
Run 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.
Asset leasing (Must be on)Multi-company purpose (Optional)
Licence or add-in
Asset 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.
Runs 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 undone
Reversible: The report changes no data.
If you change it later
The 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 item
AssetLeaseAssetMovementChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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
Load 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