How to Set Up Asset Leasing in Dynamics 365 Finance & Operations

If you’re a system administrator setting up asset leasing in Dynamics 365 Finance & Operations for the first time, you may be looking for some guidance. Below are step-by-step instructions to help you avoid any misconfigurations.

Read more about Using Asset Leasing in Dynamics 365 Finance & Operations here and Reporting on Asset Leasing in Dynamics 365 Finance & Operations here.

It’s important to set up asset leasing correctly in order for the system to work properly. The following steps are in the most efficient order, to avoid having to bounce back and forth between screens.

Asset Leasing Parameters

Account leasing -> Setup -> Asset leasing parameters

A. Asset Leasing Parameters | Leases

Screenshot of D365 Finance and Operations, highlighting Journal Name area.

Fill out the journal names. If they are not created, go to General ledger -> Journal setup -> Journal names. You only have to fill out the boxes you intend to use.

Screenshot of D365 Finance and Operations highlighting General area.
  1. Allow manual classification override: Allows the lease classification to be overwritten manually. This allows the lease classification to be changed until the payment schedule is confirmed.
  2. Cross entity batch: Allows you to create and post journal entries using the batch creation process in different legal entities.
  3. Allow depreciation reversals on closed books: Allows posted depreciation transactions to be reversed for a closed book version.
  4. Allow deletion of confirmed leases: Allows the lease to be deleted if it is confirmed.
  5. Allow payment amount breakdown: Allows lease payment schedule line amounts to be broken down.

B. Asset Leasing Parameters | Accounts

Screenshot of D365 Finance and Operations in Accounts area.

Create the lease accounts. Asset leases are defined in ASC 842 and IFRS 16.

Create the executory costs, if needed.

Note: These have to be set up for all posting types for the leases.

Screenshot of D365 F & O showing posting types.

C. Asset Leasing Parameters | Number Sequences

Screenshot of D365 F & O showing number sequences area.

Change the number sequences code. You can change the code by clicking on the code or you can create new codes. This is recommended as that will keep all old codes in the system and you can see that you created a new code.

Leasing Groups

Asset leasing -> Setup -> Leasing groups

The leasing groups define the different groups such as building, land, equipment, etc. You can be as specific as you need and define each building, land, vehicle. It is very important that these groups reflect your asset leasing.

Screenshot of D365 F & O showing building lease group.

In the action pane you can press “Books”.  See later on in this blog for the setup of Books.

Screenshot of D365 F & O showing books area.

Location Details

Location indicates the asset’s location. The location can be cities, counties, states, countries, etc. It can also be warehouses or inventories.

Screenshot of D365 F & O showing location details.

Index Rate Types

The index rate is used on the payment schedule line in the book. The “index rate method” can be either index rate value difference or index rate value.

“Index rate value difference” is for calculating the lease payment based on the difference between the index rate at commencement date and the most recent index rate-defined index rate field where the “index rate value” calculates the lease payment, using the percent defined in the index rate % field.

The rest of the field is up to you to define, as these have to make sense with your assets.

Screenshot of D365 F & O showing index rate method.

Books

Books are all about which accounting frameworks should be used.

Screenshot of D365 F & O showing books area. Screenshot of D365 F & O highlighting general area in books.
  1. Posting layers: Each book that is attached to a lease is set for a posting layer that has different purposes.
  2. Lease type: The lease type can be an operating lease or a finance lease. It can also be set to automatic, as this will result in fewer books.
  3. Accounting framework: The most common ones are IFRS 16 and ASC 842 which set up the principles and rules for asset leasing. ASC 840, IAS 17 and cash basis can also be used.
  4. Lease term/useful life % set up: This field will classify the asset as a finance lease, if the lease term is set to automatic, and if the lease terms are over the asset’s useful life and is equal or greater than the % in this field.
  5. Present value/asset fair value (%) set up: % of assets fair value. This field will classify the asset as a finance lease if the lease term is set to automatic, and if the present value of future lease payment over asset fair value is equal or greater than the % in this field.
  6. Leasing convention: Commencement date. If this is set to none, the start date will be the commencement date.
  7. Short term threshold: Enter the number of months that will be used as a short-term threshold.
  8. Low value threshold: Enter the amount to use as a low value threshold.
  9. Pay to vendor: Set to yes, it will allow a lease payment to be posted as an invoice to the vendor account specified on each lease.

Expense Types

Usually these are administrative expenses. Expense types are expenses related to an asset and have to be associated to accounts under “Asset leasing parameters | Accounts” on executory costs. For a building, it could be maintenance, insurance, utility, property taxes, etc.

Screenshot of D365 F & O showing expense types area.

If you have any questions about Asset Leasing in Dynamics 365 Finance & Operations, please get in touch with us.

Glossary of Terms for Dynamics 365 Finance & Operations Users

Do you have questions about all the different terms in D365FO? Check our glossary of the most commonly asked-about terms, with definitions and examples.

See Full Glossary

Glossary of D365 Finance & Operations Terms

See Full Glossary