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
2. Assignment of Wage types to Payment Types
Table: V_T506P
3. Create New Loan Wage Types
T-code: OH11
4. Create Symbolic Accounts
*Assign Symbolic Account to Wage Type
5. Assign G/L Account to the newly created Symbolic Accounts
T-code: OBYG
*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))
7. Custom Schema – ZNLN (Loan accounting (Custom – Pran))
*Custom PCR has to replace with standard schema INLN in the Payroll Schema IN00
8. Loan Infotype Maintenance in the Master Data:
8.1 Loan Type: P005
8.2 Loan Type: PRAN
Testing Screen shots:
9. Loan Info type 0045 processing:
INPUT TABLE
INTEREST CALCULATION
LOAN TABLE OUTPUT
10. CUSTOM PCR ZLOZ (Loan accounting: Posting to several collective accounts (custom))
RT TABLE INPUT
RT TABLE OUTPUT
11. Employee Payslip
*In the Remuneration Form remove the standard loan wage types and maintain the custom created loan wage types
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
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
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
Nice document....Keep it up...
Hi,
How to map special GL's for the loans and the advances?
Regards,
Vijay Kumar K.B
once again..excellent document by SAP Mastechef..!!
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
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.
Very Nice document Praneeth.
Thanks,
Bhabagrahi
NICE DOCUMENT
Thank you Friends,
please rate the document if you think it is worthy 🙂
Best Regards,
Praneeth kumar
Its a very good reference guide for some one who is doing it for the first time.
Thanks,
Bhabagrahi
Hi Praneeth,
I am very thankful to u for sharing such a nice document
regards,
ramjan
How to enter the Remuneration form PF51 (Employee payslip) ??
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.
How could I maintain in Remuneration form ??
What t-code I should enter?
PE51
in this step
2. Assignment of Wage types to Payment Types
Table: V_T506P
could i put my custom Wagetypes such as m014
hi praneeth kumar m
what p005 represent in ZLOZ schema
Mr. Mamedo,
P005 in the schema ZLOZ with function VAKEYLNTYP is loan type.
thanx mr.praneeth
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?