Microsoft Dynamics CRM (Archived)

how to implement EMI calculator plugin?Any suggestions?

(0) Share

Report

Posted on by bharrath

195

1307.emi2.png

Hi friends am trying to implement EMI calculator.Can anyone give suggestions?thank you.

Here’s the formula to calculate EMI:

EMI Formula

where

E is EMI

P is Principal Loan Amount

r is rate of interest calculated on monthly basis. (i.e., r = Rate of Annual interest/12/100. If rate of interest is 10.5% per annum, then r = 10.5/12/100=0.00875)

n is loan term / tenure / duration in number of months

For example, if you borrow ?10,00,000 from the bank at 10.5% annual interest for a period of 10 years (i.e., 120 months), then EMI = ?10,00,000 * 0.00875 * (1 + 0.00875)120 / ((1 + 0.00875)120 – 1) = ?13,493. i.e., you will have to pay ?13,493 for 120 months to repay the entire loan amount. The total amount payable will be ?13,493 * 120 = ?16,19,220 that includes ?6,19,220 as interest toward the loan.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi,

Is there any reason you are doing calculation in plugin ? As plugin is server side and you can not get directly the return to client side . So you have to reload the forms to see the results. However in that case you just need to use entity referene of posted entity context to get the value of fields and do the calculations. Here is the c# reference after getting those values you just need to replace the field values.

[View:http://www.authorcode.com/how-to-make-emi-calculator-using-c/]

I would recommend to implement this in client side onchange event of fields so that you can see the result instantly.Here is one reference using jquery.

[View:http://ngiriraj.com/pages/finance/emi.php]

Hope this helps.

Was this reply helpful? Yes No
bharrath 195 on at

Like (0)

Report

Hi Goutam, No specific reason using plugin.I got how to do using javascript but I didn't find any code using plugin.So I want to take help from you people.Thank you very much.

Was this reply helpful? Yes No
bharrath 195 on at

Like (0)

Report

Thank you Goutam its working.my code

//I called this function on load to disable monthlyemi field.

function disable()

{

Xrm.Page.getControl("hdfc_monthlyemi").setDisabled(true);

}

// I called this function on save

function EMI()

{

var loanamount = Xrm.Page.getAttribute("hdfc_loanamount").getValue();

var interest = Xrm.Page.getAttribute("hdfc_interestrate").getValue();

var monthlyInterestRatio = (interest/100)/12;

var term = Xrm.Page.getAttribute("hdfc_loanterm").getValue();

var top = Math.pow((1+monthlyInterestRatio),term);

var bottom = top -1;

var sp = top / bottom;

var emi = ((loanamount * monthlyInterestRatio) * sp);

var res=emi.toLocaleString();

Xrm.Page.getAttribute("hdfc_monthlyemi").setValue(res);

}

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Great !! Good Job Sir.

Was this reply helpful? Yes No

Community site session details

how to implement EMI calculator plugin?Any suggestions?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

how to implement EMI calculator plugin?Any suggestions?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates