Skip to Content
Author's profile photo Former Member

Employee Loan payments Posting to Different G/L Account’s

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



Assigned Tags

      21 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi,

      i don't try vendor postings. if you tell how you are doing then i will check and suggest you.

      Best regards,

      Praneeth kumar

      Author's profile photo Former Member
      Former Member

      Nice document....Keep it up...

      Author's profile photo Former Member
      Former Member

      Hi,

      How to map special GL's for the loans and the advances?

      Regards,

      Vijay Kumar K.B

      Author's profile photo Former Member
      Former Member

      once again..excellent document by SAP Mastechef..!!

      Author's profile photo Former Member
      Former Member
      Blog 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

      Author's profile photo Former Member
      Former Member
      Blog 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.

      Author's profile photo Bhabagrahi Sahu
      Bhabagrahi Sahu

      Very Nice document Praneeth.

      Thanks,

      Bhabagrahi

      Author's profile photo Former Member
      Former Member

      NICE DOCUMENT

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Friends,

      please rate the document if you think it is worthy 🙂

      Best Regards,

      Praneeth kumar

      Author's profile photo Bhabagrahi Sahu
      Bhabagrahi Sahu

      Its a very good reference guide for some one who is doing it for the first time.

      Thanks,

      Bhabagrahi

      Author's profile photo Former Member
      Former Member

      Hi Praneeth,

      I  am very thankful to  u  for sharing such a nice document

      regards,

      ramjan

      Author's profile photo Mamedo Mahmoud
      Mamedo Mahmoud

      How to enter the Remuneration form PF51 (Employee payslip) ??

      Author's profile photo Former Member
      Former Member
      Blog 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.

      Author's profile photo Mamedo Mahmoud
      Mamedo Mahmoud

      How could I maintain in Remuneration form ??

      What t-code I should enter?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      PE51

      Author's profile photo Mamedo Mahmoud
      Mamedo Mahmoud

      in this step

      2. Assignment of Wage types to Payment Types

      Table: V_T506P

      could i put my custom Wagetypes such as m014

      Author's profile photo Mamedo Mahmoud
      Mamedo Mahmoud

      hi praneeth kumar m

      what p005 represent in ZLOZ  schema

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Mr. Mamedo,

      P005 in the schema ZLOZ with function VAKEYLNTYP is loan type.

      Author's profile photo Mamedo Mahmoud
      Mamedo Mahmoud

      thanx mr.praneeth

      Author's profile photo Mays Mahdi
      Mays Mahdi

      Dears,

      I have configured the custom loans as referred to this blog, but I have an issue with the employees who already have a standard loan and it is on going ,it through "no document created" in the posting ,can you please advice?