BeyondERP.Newsletter
Menu

Page · Asset leasing

Expiring book query

A list of lease books that are close to their expiry date.

Used by
Lease accountant, Lease manager, Accountant and 1 more role
Business process
Maintain asset leases
Menu item
AssetLeaseBookExpirationListPage
Main table
AssetLeaseLeaseDetails
Data entity
AssetLeaseLeaseBookEntity
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 list of lease books that are close to their expiry date.
What you do hereUse this page to see which lease books are about to expire so you can plan renewals or terminations.
ExampleFor example, a lease administrator checks it ahead of quarter end to plan which lease books to close.
Expiring book query 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 processManage active assets › Maintain asset leases
Menu pathAsset leasing › Leases › Expiring book query
Set up firstLease summary Microsoft Learn
Used next byTermination proposal Microsoft Learn
Related pagesExpiring lease query 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.

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

  1. Go to Asset leasing > Leases > Expiring book query.
  2. Set Show expiring within, then filter on Posting layer.
  3. Select a row and use Function to open the book, or go to Lease summary > Books for the lease's schedules.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Lease ID / Lease descriptionThe lease the book belongs to.Checked in Dynamics 365
Lease groupThe lease group, which decides the books each lease gets.Microsoft Learn
BookThe lease book, which holds the accounting policy (framework, lease type, thresholds) and the posted lease transactions.Microsoft Learn
Lease expiration/end dateThe date the lease ends.Checked in Dynamics 365
Show expiring withinThe window the list uses; 30 days by default.Checked in Dynamics 36530 days
Posting layerThe posting layer the book posts to; one book per layer makes dual reporting possible.Microsoft Learn Current
Country/regionThe country/region recorded on the lease.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
A lease that ends next quarter isn't on the listWiden Show expiring within; it defaults to 30 days. Checked in Dynamics 365

Test checklist

  1. Create a lease ending within 60 days.
  2. Set Show expiring within to 30 days and then to a longer window.
  3. Check that the book appears only in the longer window.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Find lease books that expire soonSet 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.When is the Expiring book query list checked, and by whom?Leaving the window at 30 days and finding the lease after its notice period has passed.Test: Expiring book query shows the right books

Feature management and licence

Feature to turn onAsset leasing (Must be on)
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). Maintain lease and View lease users read this list.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer 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 undoneReversible: The list changes no data. Microsoft Learn
If you change it laterThe 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 itemAssetLeaseBookExpirationListPage Checked in Dynamics 365
FormAssetLeaseBookDetail Checked in Dynamics 365
TableAssetLeaseLeaseDetailsShown as “LEASES” in Record infoKey field: LeaseIdChecked in Dynamics 365
Data entitiesAssetLeaseLeaseBookEntityLease books Checked in Dynamics 365AssetLeasePaymentAmountBreakdownEntityLease payment amount breakdown (only the payment amount breakdown lines) Checked in Dynamics 365
Who can open itPrivilegesMaintain lease AssetLeaseLeaseMaintainMaintain lease without vendor invoice access AssetLeaseLeaseMaintainWithoutVendInvoiceAccessView lease AssetLeaseLeaseViewDutiesLease inquire AssetLeaseLeaseInquireMaintain lease AssetLeaseLeaseMaintainMaintain lease without vendor invoice access AssetLeaseLeaseMaintainWithoutVendInvoiceAccess
4 security rolesLease accountant AssetLeaseLeaseMaintainLease manager AssetLeaseLeaseViewAccountant LedgerAccountantAccounting manager LedgerAccountingManager
Checked in Dynamics 365
Roles to set it up and use itTo 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 pageFunctionChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=AssetLeaseBookExpirationListPage
Integrate withAssetLeaseLeaseBookEntity data entity Checked in Dynamics 365
Data migrationAssetLeaseLeaseBookEntity (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
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.