Hi Friends,

I want to share with you how to post for Different G/L’s for Different Loan Types. if we have two or more Loan types and Client want it to Post to the Different G/L’s and lines items in the Employee Payslip.

Configuration Steps:


Creation of Loan types and remaining process, check in the below configuration Document.

Step-wise Employee Loans configuration

1. Creation of Loan Payment Type

Table: VV_T591A_4_LOPAY

L1.JPG

2. Assignment of Wage types to Payment Types

Table: V_T506P

L2.JPG

3. Create New Loan Wage Types

T-code: OH11

L3.JPG

4. Create Symbolic Accounts

L4.JPG

*Assign Symbolic Account to Wage Type


5. Assign G/L Account to the newly created Symbolic Accounts


T-code: OBYG

L5.JPG

*We have to Activate the PCR XLOZ – Store user Wage types in the Loan schema INLN


In the PCR ZLOZ (copy of XLOZ) assign custom wage types to the Standard Loan wage types


In the Remuneration form PF51 (Employee payslip) remove the standard loan wage types and maintain the Custom Loan wage types


6. Custom PCR – ZLOZ (Loan accounting: Posting to several collective accounts (custom))

L6.JPG

L7.JPG

7. Custom Schema – ZNLN (Loan accounting (Custom – Pran))

L8.JPG

*Custom PCR has to replace with standard schema INLN in the Payroll Schema IN00


L9.JPG


8. Loan Infotype Maintenance in the Master Data:


8.1 Loan Type: P005

L10.JPG

L11.JPG

8.2 Loan Type: PRAN

L12.JPG

Testing Screen shots:


9. Loan Info type 0045 processing:


INPUT TABLE


L13.JPG


INTEREST CALCULATION


L14.JPG


LOAN TABLE OUTPUT


L15.JPG

10. CUSTOM PCR ZLOZ (Loan accounting: Posting to several collective accounts (custom))


RT TABLE INPUT


L16.JPG


RT TABLE OUTPUT


L17.JPG


11. Employee Payslip


*In the Remuneration Form remove the standard loan wage types and maintain the custom created loan wage types

L18.JPG


Hope you understand how to carry out the Loan Payments postings to the different G/L Accounts.


Suggestions and Feedback are Welcome


Thanks and Best Regards,

Praneeth kumar



To report this post you need to login first.

20 Comments

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

  1. Bhagyashree Naik

    Thanks Praneeth for the document provided. Can we map the same for Vendors too? I mean to ask is it possible to post different loan type GL’s to vendor Ac? The reason is I had tried doing this scenario, but normal posting it works perfectly fine. But while posting to vendor, it goes to one common clearing account GL.

    Regards,

    Bhagyashree

    (0) 
  2. praneeth kumar m Post author

    Hi,

    @ Bhagyashree Naik, for posting the loan payments of vendor (Employee vendors) same configuration as i stated and in the symbolic a/c assignment AA type use K

    (0) 
  3. praneeth kumar m Post author

    Hi,

    @ vijay for your query please create a thread, and state what exactly system configuration is done and how client want to process the advances and how the repayment.

    (0) 
    1. praneeth kumar m Post author

      yes, all custom loan wage types which are created need to maintain in Remuneration form to shown in the payslip and remove the STD wage types.

      (0) 

Leave a Reply