More flexible payment schedule options for data migration of contracts with “Ordinary annuity” as the annuity type
We are trying to do beginning balance data migration for some lease schedules with “Ordinary annuity” as the annuity type.
The cut-off date is 1-Feb-2024, and the payment should fall on the 5th of February...
Asset Leasing - Lease Status - Always set to Not acquired
On the Asset Book details the asset lease status shows "closed" however on the lease details grid, the lease status shows "not yet acquired". The lease status on the book and the grid are not in sequence.
The control name is different for both fields.
Idea ...
Asset Leasing - Don't update lease start date to date of the modification
When adjusting a lease via the wizard it automatically updates the lease start date to the date of the adjustment. This should not be updated and should remain the date of the start of the lease contract. My suggestion is to change this to stop the lease start date from being updated.
Asset lease adjustment - Adjust lease end dates based on lease adjustment
After adjusting a lease via the lease adjustment wizard, the lease end date should update in the lease details page. Currently only updates in the book.
Lease data migration
We have been utilising this Microsoft data migration approach document for opening lease balance migration
https://community.dynamics.com/blogs/post/?postid=df76953f-bb2c-405a-ad21-cabcf82d742d
It is not possible to use the historical lease transactions to arr...
Dual Reporting on Asset Leasing
As per Microsoft documentation, the following asset leasing books should be configured in the system for Dual reporting requirements:
https://learn.microsoft.com/en-us/dynamics365/finance/asset-leasing/dual-reporting
- IFRS 16 book (Posting layer=Custom layer 1)
- Statutory b...
Leasing Module - Include methods for calculating NPV
In Excel there are 3 known ways of calculating NPV (PV, NPV, XNPV). The net present value calculation is the basis for the amounts posted in the asset leasing module.
The issue occurs when migrating leases from legacy systems that uses a different method for calculating NPV. ...
Index rate (%)
Would need the Index rate (%) field to be based on Revaluation date and not on Lease start date.
The revaluation according to Index rate (%) should be reflected in the Payment schedule, with a recalculation of the instalment amounts starting from revaluation date, by the perce...
Contracts from previous years not being able to be added
The data ( transactions ) we need to be uploaded from the previous years for the assets , but the issue that the previous years is already closed in the system and some of them not opened , our fiscal calendar in system is starting from 01-01-2021 and the transactions which are relate...
Security Deposit Amortization as per IFRS 9 Functionality to be integrated with Asset leasing module
As per IFRS 16, in case any Security deposit is given for the lease without any consideration then the present value of the
Generally, in a lease agreement a security deposit is payable at the beginning of the lease term. This security deposit is generally refund...