Cumulation of Past Months Deductions

[Former Member]

Hi ,

Every Month deducting fixed slab amount from employee for Electricity charges. And getting the electricity consumption details (Quarterly) for that employee, based on that slab will be calculated & recover / adjust next month.

Example:

Electricity Charges Deduction Jan 100

                                             Feb 100

                                             Mar 100

                      Total= 300

Electricity consumption in Units for that employee  400 Units(3 months),  For that Rs.380

Where, Actual consumption  Rs. 380 -

            Fixed slab total         Rs. 300

                     Balance          Rs.  80 (Recovery in april month salary)

Where, Actual consumption   Rs. 400 -

             Fixed slab total         Rs. 300

                     Balance          Rs.  100 (repay in april month salary)

Regards,

Mathi S

[former_member193210]

Is the "Monthly Deduction Amount" the same for all employees, does it vary by Employee Group/Sub-Group, or does it vary by Employee?

How is the Electricity Consumption (number of Units) entered in SAP?  Is it converted into a Deduction Amount before being entered into SAP or during Payroll Calculation?

Is the Electricity Consumption for January/February/March entered in SAP before the calculation of March payroll, or retroactively to March before the calculation of April Payroll?

Have you created a WT for the Electricity Advance Deduction, for the Electricity Consumption Amount, and for the Electricity Balance Payment/Deduction?

[BalaAP]

Hi,

You can achieve this in different ways.

1.You can maintain the monthly deduction in Infotype 14 for all the employees and quarterly calculation part can be achieved by PCR's. You may need to store actual consumption in Infotype 15.

2.You can maintain the deduction amount slab in V_T511K table for employee group/subgroup wise and write PCR's to deduct monthly in payroll run and quarterly calculation can be achieved in same way as step-1.

(But you may need to transfer the monthly amount to next month payroll through table LRT, since you need to cumulate the amount quarterly).

You need to confirm, what to do in case of deduction not happen in a particular month and how to proceed.

Please give some time, so that I can give you PCR structure.

regards,

Bala.