BeyondERP.Newsletter
Menu

Report page · Asset leasing

Five years undiscounted payment forecast

A report that shows the projected undiscounted lease payments for the next five years from a date you enter.

Business process
Analyze asset leases
Menu item
AssetLeaseSsrsUndiscountedYearlyPayments
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 report that shows the projected undiscounted lease payments for the next five years from a date you enter.
What you do hereUse this report to see lease payments grouped by year: the next 12 months, then months 13-24 up to 49-60, and everything after that.
ExampleFor example, for BEAT's year-end accounts the controller runs it as of 12/31 and copies the Current, 13-24 to 49-60 and Thereafter totals into the lease maturity analysis note.
Five years undiscounted payment forecast 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 › Five years undiscounted payment forecast
Set up firstConfirmation batch Microsoft Learn
Used next byLease balances forecast Microsoft Learn
Related pagesGAAP - cash flows 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 each reporting date when you prepare the lease maturity analysis for the financial statements.
How oftenAt each quarter or year end close, or on demand for a payment forecast.
What the output showsOne line per lease and book with Classification, Posting layer and Currency, and the undiscounted payments in the buckets Current, 13-24, 25-36, 37-48 and 49-60 months, and Thereafter. Totals that are too low usually mean leases with unconfirmed payment schedules or a reporting date that is later than intended.

Source: Microsoft Learn

Setup steps on this page

Run the Five years undiscounted payment forecast report

Produce the Five years undiscounted payment forecast figures for the period you report.

Steps from Microsoft

  1. Go to Asset leasing > Inquiries and reports > Lease reports > Five years undiscounted payment forecast.
  2. Enter the reporting date. The yearly buckets are counted from this date, so use the balance sheet date of the disclosure.
  3. Filter on the legal entities, lease groups or books you need for the disclosure.
  4. Read the columns Current, 13-24 months up to 49-60 months and Thereafter for each lease, and compare their total with the remaining payments on the payment schedules.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
ClassificationThe classification of the lease.Microsoft Learn
Posting layerThe posting layer the lease posts to.Microsoft Learn
CurrentLease payments due within 12 months of the reporting date.Microsoft Learn
13-24 monthsLease payments due between 13 and 24 months from the reporting date.Microsoft Learn
49-60 monthsLease payments due between 49 and 60 months from the reporting date.Microsoft Learn
ThereafterLease payments due 61 months or more after the reporting 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 Five years undiscounted payment forecast reportRun it as of the balance sheet date, filtered on one posting layer, for the maturity analysis.The buckets count from the report date, and every book of a lease is a line, so the date and the posting layer decide the totals.Which book feeds the maturity analysis?Adding up all posting layers, so a lease with an IFRS 16 book and a local book is counted twice.Test: Maturity buckets add up

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 lease payment schedules; 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 itemAssetLeaseSsrsUndiscountedYearlyPayments 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=AssetLeaseSsrsUndiscountedYearlyPayments
Data migrationLoad order: The Five years undiscounted payment 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
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.