BeyondERP.Newsletter
Menu

Setup page · Asset leasing

Lease books

A setup page where you define lease books, which hold the accounting policies that decide how a lease is accounted for.

Used by
Lease accountant, Lease manager, Accountant and 1 more role
Business process
Define leasing policies
Menu item
AssetLeaseBookMaster
Main table
AssetLeaseBookTable
Data entity
AssetLeaseBookSetupDataEntity
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 setup page where you define lease books, which hold the accounting policies that decide how a lease is accounted for.
What you do hereUse this page to create books with their posting layer, accounting framework, lease type and classification thresholds.
ExampleFor example, set a short-term threshold in months so that leases at or under that term are classified as short-term leases.
Lease books 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

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

Set up Lease books

Use this page to create books with their posting layer, accounting framework, lease type and classification thresholds.

Steps from Microsoft

  1. Go to Asset leasing > Setup > Lease books.
  2. Select New to add a book.
  3. Set the posting layer, lease type and accounting framework.
  4. Set the classification thresholds and the other book options.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Posting layerThe posting layer the book posts to.Microsoft Learn PostingLayer
Lease typeWhether leases are classified automatically or predefined as finance or operating.Microsoft Learn AutomaticLeaseType
Accounting frameworkThe accounting framework associated with the book.Microsoft Learn IFRS 16AccountingFramework
Lease term/Useful life setupThe percentage of lease term over useful life at or above which an automatically classified lease becomes a finance lease.Microsoft Learn
Short-term thresholdThe number of months at or under which a lease is classified as short-term.Microsoft Learn 12
Low value thresholdThe amount at or under which a lease is classified as low-value.Microsoft Learn 5,000.00LowValue
Pay to vendorPosts lease payments as invoices to the vendor account on each lease.Microsoft Learn PayToVendor
Leasing conventionSets whether the commencement date is the lease start date or the first day of that month.Microsoft Learn Full monthLeasingConvention
Present value / Asset fair value setupWith Lease type Automatic, the lease is classified as finance when the present value of future minimum payments is at or above this threshold.Microsoft Learn

Common errors and fixes

MessageWhat to do
Leasing convention can't be setTurn on the feature Leasing convention for asset leasing in Feature management. Microsoft Learn
Monthly expenses post mid-monthLeasing convention is None, so the lease start date is used. Use Full month to post on the last day of the month. Microsoft Learn

Test checklist

  1. Create a book with Lease type Automatic, the accounting framework, thresholds and Leasing convention Full month.
  2. Create a lease that starts mid-month with this book and select Create schedules.
  3. Check the Lease classification test FastTab shows the expected Lease type for the thresholds.
  4. Open the depreciation and amortization schedules and check entries fall on the last day of the month.
  5. With Pay to vendor set to Yes, create a lease payment and check it posts as a vendor invoice to the lease's vendor.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Lease booksLeasing convention: Full monthFull month starts the lease accounting on the first day of the month of the start date, so the whole month's expense accrues and posts on the last day of the month. With None, amortization and depreciation can accrue and post mid-month.Should lease payments post to the lessor's vendor account (Pay to vendor)?Leaving Leasing convention at None with leases that start mid-month, so expenses post in the middle of the month. The field needs the Leasing convention for asset leasing feature turned on first.Test: Short-term threshold applies deferred rent

Feature management and licence

Feature to turn onAsset leasing (Must be on)Leasing convention for asset leasing (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). Maintain lease users set up the books.

Microsoft Learn

Solution architect

5Design impact

Can it be undoneHard to reverse: The book setup is applied when schedules are created for a lease. After Confirm schedule the lease can't be edited, so changing the book doesn't fix leases already confirmed; they need a lease adjustment. Microsoft Learn
If you change it laterThe leasing convention affects when expenses accrue; with None, schedules may accrue and post expenses mid-month instead of at month end. Microsoft Learn
Technical architect

6Technical

Menu itemAssetLeaseBookMaster Checked in Dynamics 365
FormAssetLeaseBookMaster Checked in Dynamics 365
TableAssetLeaseBookTableShown as “BOOK TABLE” in Record infoKey field: BookTypeChecked in Dynamics 365
Data entitiesAssetLeaseBookSetupDataEntityBook table 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
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=AssetLeaseBookMaster
Integrate withAssetLeaseBookSetupDataEntity data entity Checked in Dynamics 365
Data migrationAssetLeaseBookSetupDataEntity (Book table): the lease books and their policies.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: Posting layersMicrosoft 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.