Loan Function

jayshyne

Hi,
I'm trying to write a function in navision to replicate the pmt (loan) function in excel. Any idea how the parameters work to get the final value. Any help will be much appreciated. thanks

Alex_Chow

jayshyne wrote:

Hi,
I'm trying to write a function in navision to replicate the pmt (loan) function in excel. Any idea how the parameters work to get the final value. Any help will be much appreciated. thanks

What you need is the financial formula to calculate the interest compounded over time. I think you're probably better off picking up a finance book and replicate the formula in C/AL code.

Ravi_Thakkar

Did anybody get converted the PMT function in Navision?

I just need the detailed logic behind PMT function in Excel to replicate in NAV.

Any suggestions?