63

Suggested by Patrick Ocampo – Under Review 

D365 Finance uses "NPV" to calculate the present value of lease payments. The "NPV" calculation assumes the interval between the payments is the always the same, for certain leases such as property leases this is not the case. "XNPV" allows the present value calculation to be more accurate and calculate to exact days. As an example, the rental payments for property leases are typically defined in fixed "rent" days such as 25th December, 25th March, 24th June and 29th September. The system has the ability to setup the fixed "rent" payment days however the present value of the lease payments are not accurate, resulting in a variance with the value of the lease contract when using the XNPV calculation vs NPV. The variance grows exponentially as the value of the lease contract increases. Please add the option for the system to calculate the present value of lease payments using XNPV instead of NPV.

Status Details

Thank you for your feedback.
 
Currently this is not in our roadmap; however, we are tracking it and if we get more feedback and votes, we may consider it in the future.
 
Sincerely,
Mohamed Aamer, PM,
Microsoft.
Comments (6)
  • Mariola Cyran
    Fri, 23 Jul 2021 10:16:20 GMT
    It is not possible to implement Lease module with current algorithm of NPV calculation in the company which has more complex terms in the Lease contract. Client calculate NPV value using XNPV function in excel and receive proper NPV value. Trying to calculate it in D365 receives not proper NPV value. It should be corrected.
  • Mariola Cyran
    Fri, 23 Jul 2021 10:19:33 GMT
    It is not possible to implement Lease module with current algorithm of NPV calculation in the company which has more complex terms in the Lease contract. Client calculates NPV value using XNPV function in excel and receives proper NPV value. Trying to calculate it in D365 receives not proper NPV value. It should be corrected.
  • Jennifer Maritz
    Tue, 23 Nov 2021 21:30:12 GMT
    This is a basic requirement in lease accounting - desperately needed.
  • Mahmoud Ibrahim
    Sun, 16 Oct 2022 07:49:07 GMT

    It is an essential need to use this module!

  • Ivy Yu
    Thu, 05 Oct 2023 23:10:24 GMT

    It's a crucial functionality to have, especially the financing and lease contracts are becoming more complex nowadays.

  • Kathie Loccisano
    Tue, 30 Apr 2024 06:00:24 GMT

    This change is required for clients to report leases accurately. Please make the change to the system

<div>Please <a id="idea-signin-link" href="/SignIn?returnUrl=%2Finsider%2Fpublic-profile%2Fideas%2Fdynamics-operations%2FID0019986">sign in</a> to Vote and Comment on Idea.</div>

Voting

  • 63 Votes up for this idea
  • 0 Votes down for this idea
  • 63 Votes for this idea

Search Ideas