cancel
Showing results for 
Search instead for 
Did you mean: 

Payroll requirment

Former Member
0 Kudos

Hello All

We want to have an Loan deduction in W2 of Deduction column but the amount should be minus the amount of Payments and reduce that amount.Below is the example of the requirement

Regular Scenario

W1

Basic 10000

HRA    2500

Conve   800

Oth All3000 

Total Earnings 16300

W2

IT 200

Professional Tax 100

Total Deduction 300

Net Pay 16000

Our Requirement

W1

Basic   10000

HRA      2500

Conve     800

Oth All  3000 

Total Earnings 15800

W2

IT 200

Professional Tax 100

Study Loan 500

Total Deduction 300

Net Pay=15500

Regards

SK

Accepted Solutions (0)

Answers (2)

Answers (2)

jagan_gunja
Active Contributor
0 Kudos

What is study loan - is it a loan deduction or the loan amt received from the company?

If it is a loan amt / loan deduction, are you entering these in IT 45?

Loan deduction should be in W2 added to total deductions.

Loan amt balance is for employee's information only, whereas the other amt's in W2 or deductions..

venkat_polisetty
Active Contributor
0 Kudos

Hi S K,

You can achieve this with using "CUMULATION ID's" in pe51 transaction.

You need add this study loan wage type in payments(Earnings) side and no need to add this study loan wage type in deductions side.

Please check and let me know if in case you need any further clarification.

Regards,

Venkat Polisetty.

Former Member
0 Kudos

Hello All

Our users dont want in W1 section and they want in W2 section.

Also the deduction mount (T511) should be reduced from the total payment and not from the Total Deduction.

I am not looking for a solution in Payslip but in RT table also.

Because just adjusting in PE51 will lead to failing in Posting.

Regards

SK

venkat_polisetty
Active Contributor
0 Kudos

Hi S K,

Here we will not change W1 & W2 configuration in PE51, we need to change cumulation Id's configuration as per my previous reply.

It you will do like this it will not lead any postings as per my knowledge. Kindly check this and let me know.

Regards,

Venkat Polisetty.

Former Member
0 Kudos

Hello Experts

Any other information on this.

Regards

SK

suhas_lembarkar
Active Participant
0 Kudos

Hi ,

You have to develop custom PCR to meet this requirement.

Regards,

Suhas Lembarkar.