web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Wave 2 Asset Leasing: How to set the Opening balance for the Lease liability amortization schedule

(0) ShareShare
ReportReport
Posted on by 25

Hi All,

I'm am currently setting up the Asset Leasing module and I would like to set the opening balance for specific Lease Summary.. However I am unable to set the Opening balance for the Lease Liability Amortization Schedule.

Is there a way to set the Opening balance? Can someone point me to the right direction? Appreciate all your replies.

Thank you in advance.

Aleeia

I have the same question (0)
  • Verified answer
    brjo Profile Picture
    on at

    I will start with a link to our DOCS site for your concern about the setup of the "Asset Leasing" module and some of its nuances:
    https://docs.microsoft.com/en-us/dynamics365/finance/asset-leasing/asset-leasing-quick-start

    I will do a bit more checking, too.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Aleeia,

    The short answer is no, the opening balance for the lease liability amortization schedule is a system calculated value of the sum of the present value of payments from the payment schedule. This value cannot be inputted manually because the module will automatically calculate this value to ensure the lease liability value will fully amortize over the life of the lease.

    Are you hoping to match the beginning balance to the current carrying value of your lease liability from a legacy system? There are ways you can "back into" a specific opening balance by entering an incremental borrowing rate and compounding interval that will discount your remaining lease payments to a specific value.  The remaining lease payments discounted at the rate you had originally discounted your lease payments should equal the same value if the rates are compounded the same.

    As an example, if you have a lease with 36 monthly payments of $1,000, discounted at 5%, annuity due, and compounding monthly starting on 1/1/2020, the carrying value of the liability would be $22,889 as of 1/1/2021 after 12 months of payments. If you wished to enter this lease in Asset Leasing as of 1/1/2021 and were hoping for a beginning balance of $22,889, you would simply enter the remaining payments discounted at the same rate as the legacy system. Therefore, a lease commencing on 1/1/2021 with 24 monthly payments of $1,000, discounted at 5%, annuity due, and compounding monthly would yield a beginning balance of $22,889.

    Please let me know if you could provide additional details and I'd be happy to suggest a way to accommodate your scenario.

    Thanks,

    Brian

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans