cancel
Showing results for 
Search instead for 
Did you mean: 

PY-IN : Company Loan - Principal and Interest Calculations

Former Member
0 Kudos

Dear Experts,

I am working on Company Home Loan for PY-IN

Scenario is as following

SR NOLAON AMT12%PRINCIPAL AMTEMI AMTMONTH
13510335115991950Apr-13
23350433516151950May-13
33188931916311950Jun-13
43025830316471950Jul-13

33103 = Loan Amount (Current Month) - Principal Amount = Next month loan amount (See Sr. No. 2)

Now SAP working is as following

01. Principal is not showing

SR NOLAON AMT12%EMI AMTMONTH
1351033511950Apr-13
2331533321950May-13
3312033121950Jun-13
4292532931950Jul-13

33103 = Loan Amount (Current Month) - EMI Amount = Next month loan amount (See Sr. No. 2), But client want less only Principle amount from Loan Amount.  How it will correct in SAP Config.


Thanks in advance..:)

Regards,

Santosh Shivane

Accepted Solutions (0)

Answers (1)

Answers (1)

Sanky
Active Contributor
0 Kudos

Hi Santosh,

Is it the requirement that client want 1st principal amount has to deduct and then only EMI deduction start.

Am i correct?

Regards,

Sankarsan

Former Member
0 Kudos

Dear Sankarsan,

Client required as per following scenario.

Scenario is as following

SR NOLAON AMT12%PRINCIPAL AMTEMI AMTMONTH
13510335115991950Apr-13
23350433516151950May-13
33188931916311950Jun-13
43025830316471950Jul-13

33103 = Loan Amount (Current Month) - Principal Amount = Next month loan amount (See Sr. No. 2)

Not required first principal and then Interest deduction.  Only requirement is from Loan Amount less only Principal Amount. But system behavior is less emi amount.

Regards,

Santosh Shivane

Former Member
0 Kudos

Dear Experts,

Company Loan required Scenario is as following

SR NO

LAON AMT

12%

PRINCIPAL AMT

EMI AMT

MONTH

1

35103

351

1599

1950

Apr-13

2

33504

335

1615

1950

May-13

3

31889

319

1631

1950

Jun-13

4

30258

303

1647

1950

Jul-13

Calculation FIL:

  1. 01. Loan Amount  -> 35103 (Sr.No.1) = Loan Amount (Current Month) Rs.35103 – Rs.1599 Principal Amount =  33504 Next month loan amount opening balance  (See Sr. No. 2)
  2. 02. Loan Amount  -> 33504 = Loan Amount (Current Month) Rs.33504 – Rs.1615 Principal Amount =  31889 Next month loan amount opening balance (See Sr. No. 3). 
  3. Only deduct principal amount from Loan Amount
  4. I have updated in IT0045 - Fix Deduction EMI - Rs.1950


Please suggest, how to resolve the Issue.


With Regards,


Santosh Shivane

Sanky
Active Contributor
0 Kudos

Hi Santosh,

As per your reply and explanation you would like to deduct the 1950 amount where interest amount getting down but principal amount getting up.

But at the same time you would like biffercate amount 1950 into principal amount and 12% amount of loan amount. which is required to post to financial G/L account.

Regards,

Sankarsan