Skip to Content
author's profile photo Former Member
Former Member

EMI calculation

Dear all,

Is it possible to calculate Equated monthly installment (EMI), Simple interest and compound interest say for some principal amount in B one using some UI and complex the mapping process will be with finance module so that accounts are geting effected properly.

Good example for this will be concept used in home loans.

Thanks and Regards

swapnil

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 12:44 PM

    Try out using 'Financials -> Recurring Postings' which Posts JE on specified Intrevals.

    or

    Try using 'No. of Installments" in the "Payment Terms Setup"

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 01:50 PM

    Hi Swapnil

    SAP Business One does not cater as standard for interest calculations on loans for example. You could use Freight Charges (Additional Exp. in 2005) to accrue the interest calculation upfront on the invoice and use recurring journals to post the monthly interest charge. Unfortunately any late payments, additional interest or interest rate changes will have to be computed manually and posted as adjustments. You could then use installments to collect the monthly charge, but to change the installment if the interest rate changes will be a problem. I am almost certain that there is an add-on that might cater for some of this functionality. Could be a bit tricky and complex to set up in standard SAP. Other alternative is SDK development.

    Kind regards

    Peter Juby

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.