Skip to Content

Hi Friends,

Hope every one doing well, i want to share one document for Employee Loans configuration. i know every one knows how to configure, please treat this document as a reference and give your valuable suggestions.

1. Adjust Value Date

Table no. V_T506S

Here, for your payroll area you have to define Value date


1.JPG


2. Specify Interest Calculation Method


Feature: INTLO

Here, you have to specify the Interest Calculation Method to your country grouping / respective groupings


2.JPG

3. Maintain Loan Types


Table No. VV_T591A_4_VC506

Here, you have to  maintain the Loan types and conditions for Interest calculations


3.JPG

3-1.JPG

3-2.JPG

3-3.JPG

3-4.JPG

 

4. Maintain Loans Eligibility Checks and Limits


Table No. V_T7INJ3

Here, you have to maintain the Eligibility check for the loan types

4.JPG

5. Maintain Loans Grouping


Feature: 40LGR

Here, you have to link the Loan eligibility to Loan Types


5.JPG


TESTING:

IT 0045 – Loans

t-1.JPG


t-2.JPG

Repayment Plan:

t-3.JPG

Salary Slip:

t-4.JPG



Scenario :1


1. When Employee in Full LOP for the Month.


solution:


The solution is depends on the Client Requirement, whether he want Carry forward the Deduction amount to the next payroll period or completely waved off the Regular Repayment and Interest too for the LOP and increase the Regular Repayment one month extra.



Carry forward scenario:


1. Need to change Wage type Arrears Characteristics table V_T51P6


cf-1.JPG


cf-2.JPG

cf-3.JPG



No Deduction Scenario:


1. No need to change any Wage type arrears table.

2. Need to change loan type for installment for that particular period is 0.

3. Extend the Regular Repayment one month more or change the installment amount.


d1.JPG

d2.JPG

d3.JPG


d4.JPG



Thanks and Best Regards,

Praneeth Kumar

To report this post you need to login first.

36 Comments

You must be Logged on to comment or reply to a post.

  1. Sikindar T

    what in case of custom specific loans ? what happens to LRP in case if employee goes full month LOP ? Can you let document those two things along with some other issues mentioned in the previious threads that would be great

    (0) 
    1. praneeth kumar m Post author

      Hi,

      Thanks for suggestion 🙂

      Custom specific loans – it depends on the conditions of Interest rates, Interest method calculations, Interest cycle and Payment cycle. these are client specific requirements.

      About LRP i will update those ASAP

      (0) 
  2. vijay kumar

    Hi,

    Can we define in the system, saying like at the end of the loan installment deduct the Cumulated interest.

    Note : Every month interest should not come.

    Ex: In April, granted amount is 100 rps with 2 installments. My question is for 100 rps Cumulated interest should calculate in the  may period. How to achieve this one?

    (0) 
  3. Naresh .km

    Dear Praneeth,

    Thanks for sharing a helpful document, I would like to know how to integrate loan payments to payroll, I am able to create loan type and able to create a loan record in Infotype 45, but when I am running the payroll it is not deducting from payroll. I would like to now how we can do this? is there any PCR change please do needful.

    Thanks & Regards,

    Naresh

    (0) 
      1. Naresh .km

        Dear Praneeth,

        I have checked in payresult, but there is no wage type available  starting with /L series. is there any problem in my configurations? kindly do needful

        (0) 
  4. Priya Gupta

    Good Document

    where can i see principle amount?

    I would like to know the remaining amount to be paid I would like to know If iam configuring loan suppose for example Employee loan is for 5 years how do i do that

    (0) 
    1. praneeth kumar m Post author

      Hi Priya,

      After maintaining the tabs Basic data, Conditions & Payments click on the button “CREATE REPAYMENT PLAN (F8) ” it will show the no. of months according to the repayment value and interest for every month.

      (0) 
      1. Naresh .km

        Dear Praneeth,

        Thanks for sharing good document as you said it will show the repayment value and the interest for every month as below.

        T Code: PA30

        Capture.PNG

        After you execute it will show a clear record like below.

        Capture.PNG

        Thanks & Regards,

        Naresh

        (0) 
  5. Sai Siva

    Hi Praneeth,

    Thanks for the document on Loan

    Can u please clarify this:

    There is a requirement on which the employee status is inactive – on leave, so payroll is not run but the payment is shown in Remuneration statement.

    August the Payroll is not run  but repayment is shown in Payslip

    Please provide your inputs on this.

    Thank you,

    Sai

    (0) 
    1. Naresh .km

      HI Sai Shiva,

      As Praneeth said in this document you can follow below steps,

      1) Change loan type for installment for that particular period is 0.

      2) Extend the Regular Repayment one month more or change the installment amount, then it will work.


      Regards,

      Naresh

      (0) 
  6. Ahmad Karim

    Hi,

    I was wondering is it possible to use “V_T7INJ3” (maintain eligibility checks) and feature 40LGR for “other countries / International Payroll” as well or not?

    Regards

    (0) 
    1. Bhagyashree Naik

      Hi Praneeth,

      Can you also please specify in your document, if we have different loan types, then it should get triggered in different wage type and posting for the same to be done in different GL’s? This will become very helpful document for future reference in that case.

      Also, I had come across a requirement, wherein user wanted to post these different type of loan in their respective GL’s in the particular employee vendor account. Is this possible?

      Regards,

      Bhagyashree

      (0) 
    2. praneeth kumar m Post author

      Hi Ahmad,

      Table V_T7INJ3 and Feature 40LGR is belongs to country grouping India (40). check for your country Loans configuration nodes you may find some.

      Regards,

      Praneeth kumar

      (0) 
        1. praneeth kumar m Post author

          Ahmad,

          you can do same in the Node payroll – international – loans and go with feature INTLO with Decision operation Country grouping, loan type, loan condition.

          (0) 
          1. Ahmad Karim

            Thanks for the input but how can we limit the system to check the loan payment amount against the employee assets for example gratuity and Provident Fund. Is it possible or should be use ABAP ?

            (0) 
  7. Ravi M

    Hi SAP Guru’s,

    Please help on the below:

    An employee has availed loan of Rs.100000/-, and deduction of Rs. 10000/- is started from Aug 2014, now the employee wants to the EMI to reduced to Rs. 5000/- with effective 01.11.2014.

    When i make changes in IT 0045 instalment amount Rs.5000/-, system is making the changes effective 01 Aug 2014.

    My query is, installment deducted till Oct 2014 should not change.

    Regards,

    Ravi.

    (0) 
    1. praneeth kumar m Post author

      Hi Ravi,

      for this you have to close the loan by 31.10.2014, and create new loan from 01.11.2014 on-wards for the remaining amount with 5000/- installment.

      requesting you open a question,

      Best Regards,

      Praneeth kumar

      (0) 
  8. Ravi M

    Thanks Praneeth,

    Actually i delimited the loan as on 31st Oct 2014 and created a new loan with Rs. 70000/- as opening balance, and run the payroll but iam getting below error:

    Loan ends on 30.10.2014, although the loan was not completely repaid in period 07. Extend the validity period for this loan, or increase the repayment or special repayment in the period.

    please guide.

    Regards,


    Ravi.

    (0) 
    1. praneeth kumar m Post author

      Hi Ravi,

      you are not suppose to delimit the loan, in the payment tab give the date 31.10.2014 and payment type 0200 – spl. repayment (external) and give the remaining amount. and run the payroll live. then create new loan for remaining amount.

      (0) 
  9. Ravi M

    Hi Praneeth,

    Continuation to your response, if we close the loan amount,how do we treat the remaining loan balance amount. Do we have to show it as the remaining loan amount has been recovered from the salary and again re issue the loan, but our finance team doesn’t accept  for it.

    Cant we adjust with existing loan.

    Provide your valuable input.

    Ravi.

    (0) 
  10. Ravi M

    Hi Praneeth,

    Thanks for ur support.

    As suggested, In Payment tab changed the date as 31st Oct 2014 and selected 0200 – Special Repayment (external) and entered the remaining loan amount 70000/-, saved it and run the payroll, its working fine.

    Later i created new loan account with the remaining amount saved and rerun the payroll, but system is not deducting the new loan amount 5000/-.

    pls let me know where am i going wrong.

    Regards,

    Ravi.

    (0) 
  11. Ravi M

    Hi Praneeth,

    I could identify where i was wrong and rectified.

    Actually i missed to enter the details in Payments tab, i.e., loan start date, payment type- Loan Repayment (external) and amount.

    Entered the above and rerun the payroll.

    Its working fine,

    Highly appreciate your kind support in resolving this.

    Tnx.

    Ravi.

    (0) 
    1. Sankarsan Dey

      Hi Priya,

      You can go with priority deduction T51P6 table. but best way to change the repayment start date by copying the current record.

      Regards,

      Sankarsan

      (0) 
        1. praneeth kumar m Post author

          Hi,

          In the document Scenario 1 is LOP scenario.

          and given 2 suggestions ie., carry farword scenario and No deduction scenario

          check these and try for your requirement.

          (0) 

Leave a Reply