A report that forecasts lease liability and right-of-use asset balances over a period, taken from the liability amortization and asset depreciation schedules.
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 is
A report that forecasts lease liability and right-of-use asset balances over a period, taken from the liability amortization and asset depreciation schedules.
What you do here
Use this page to set the filters and print projected lease liability, right-of-use asset balances and projected expenses for your leases.
Example
For example, BEAT's budget owner runs it for next year to plan the lease interest, depreciation and the split between short-term and long-term liability.
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
When you budget or forecast lease expenses and balances, or prepare the split of the liability into short-term and long-term.
How often
On demand, typically during budgeting and at year end.
What the output shows
Projected liability and right-of-use asset balances per lease, taken from the liability amortization and asset depreciation schedules. Because it reads the schedules, not posted transactions, a difference from Lease movements usually means schedule lines that are not yet posted.
Produce the Lease balances forecast figures for the period you report.
Steps from Microsoft
Go to Asset leasing > Inquiries and reports > Lease reports > Lease balances forecast.
Enter a From date and To date in the future period you want to project, for example the next fiscal year for a budget.
Filter on the leases or lease groups to include.
Read the liability side (Payments, Interest, Ending balance, Short-term liability, Long term liability) and the asset side (Depreciation expense, Ending balance, Equity adjustment) for each lease.
Run it for the coming year per posting layer to plan interest, depreciation and the short-term liability.It comes from the liability amortization and asset depreciation schedules, so it shows the future balances that confirmed leases will produce.
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
Nothing to undo: The report only reads lease schedules; it changes nothing. Microsoft Learn
If you change it later
The forecast reads the lease schedules and changes nothing; it changes when leases are added, adjusted, revalued or terminated. Microsoft Learn
Technical architect
6Technical
Menu item
AssetLeaseForecastReportChecked 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 Lease balances forecast 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