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.
Setup steps on this page
Review leases that expire soon
Find leases that end soon so a renewal, extension or return is decided in time.
Steps from Microsoft
Go to Asset leasing > Leases > Expiring lease query (Leases expiring within 30 days).
Set Show expiring within to the window you need.
Filter on Location number or Responsible.
Select a lease and select Books, or start a Termination proposal or an adjustment from Lease summary.
Set Show expiring within to the longest notice period in your lease contracts, such as 90 days, and review the list each month.A renewal decided late still has to go through the Adjustment wizard, and the default 30-day window is usually shorter than the notice period.
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). Maintain lease and View lease users read this list.
Per company: leases with their books, schedules and journals belong to the legal entity you are working in, and Lease ID numbers come from a number sequence set per company. Turn on Cross entity batch in Asset leasing parameters to create journals for other legal entities from the current one. Microsoft Learn
Can it be undone
Reversible: The query changes no data.
If you change it later
A renewal or extension found here is a lease modification: it goes through the Adjustment wizard, which creates a new lease version and remeasures the liability. Microsoft Learn
Technical architect
6Technical
Menu item
AssetLeaseDetailExpIn30DaysChecked in Dynamics 365
Form
AssetLeaseDetailChecked in Dynamics 365
Table
AssetLeaseLeaseDetailsShown as “LEASES” in Record infoKey field: LeaseIdChecked in Dynamics 365
Data entities
AssetLeasePaymentAmountBreakdownEntityLease payment amount breakdown (only the payment amount breakdown lines) Checked in Dynamics 365AssetLeaseLeaseMasterEntityParent leases Checked in Dynamics 365
To set it up or change itLease accountant AssetLeaseLeaseMaintainAccountant LedgerAccountantTo use itLease manager AssetLeaseLeaseViewAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the page
Lease: New, Maintain(Action Pane without tabs): New, BooksChecked in Dynamics 365
AssetLeaseLeaseMasterEntity data entity Checked in Dynamics 365
Data migration
AssetLeaseLeaseMasterEntity (Parent leases): reads and exports the leases. Bulk lease changes go through the Lease import framework.Load order: Load the Asset leasing setup in Microsoft's order: lease books, lease groups, then the parameters (journal names, posting accounts, executory cost accounts), expense types, payment amount types, index rate types and locations, and only then the leases.Load first: Lease summaryMicrosoft Learn