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
Find lease books that expire soon
Use the Expiring book query list to find the lease books that need attention.
Steps from Microsoft
Go to Asset leasing > Leases > Expiring book query.
Set Show expiring within, then filter on Posting layer.
Select a row and use Function to open the book, or go to Lease summary > Books for the lease's schedules.
Set Show expiring within to the notice period of your lease contracts, then filter on Posting layer.The default window is 30 days, which is usually shorter than the notice period for renewal or return.
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
The list only reads lease books. The books change through the lease's own actions: confirming the payment schedule, posting journals, impairment with Close book, adjustment and termination. Microsoft Learn
Technical architect
6Technical
Menu item
AssetLeaseBookExpirationListPageChecked in Dynamics 365
Form
AssetLeaseBookDetailChecked in Dynamics 365
Table
AssetLeaseLeaseDetailsShown as “LEASES” in Record infoKey field: LeaseIdChecked in Dynamics 365
Data entities
AssetLeaseLeaseBookEntityLease books Checked in Dynamics 365AssetLeasePaymentAmountBreakdownEntityLease payment amount breakdown (only the payment amount breakdown lines) 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
AssetLeaseLeaseBookEntity data entity Checked in Dynamics 365
Data migration
AssetLeaseLeaseBookEntity (Lease books): reads and exports the books in this list. Lease books are created by Create schedules from the lease group, so load leases, not books. Microsoft's route for bulk leases is the Lease import framework (Lease staging, Payment contract staging, Executory contract staging), then Migrate lease records.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