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 Index rate type
Use this page to add index rate types and rates, and choose how the index rate is applied, so that index-linked lease payments can be revalued.
Steps from Microsoft
Go to Asset leasing > Setup > Index rate type.
Select New.
Enter the rate type and the name of the index rate.
To add a rate value, select the index rate type, and then select Add.
Select the effective start date and the rate value.
A method that calculates the new payment from the difference between the index rate on the start date and the most recent rate.Microsoft Learn
Index rate value
A method that calculates the payment by using the percentage entered in Index rate (%).Microsoft Learn
Index rate (%)
The index rate percentage used by the selected method.Microsoft Learn
3.2
IndexRate
Common errors and fixes
Message
What to do
Leases are revalued with last year's rate
Revaluation uses the latest rate dated on or before the revaluation date. Add the new value with its effective start date before you run it. Microsoft Learn
Test checklist
Create an index rate type, choose the method and add two dated values.
Use a confirmed lease whose payments depend on that index rate type.
Run Index rate revaluation with a revaluation date after the second value.
Check the revalued payment uses the most recent value as of the revaluation date.
One rate type per published index the contracts use, with every published value entered with its effective start date.Revaluation takes the most recent rate as of the revaluation date, so the dated history decides the new payments.
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 users keep the index rates.
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
AssetLeaseIndexDataEntity data entity Checked in Dynamics 365
Data migration
AssetLeaseIndexDataEntity (Index rate (%)): the index rate types and their dated values.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.Microsoft Learn