Skip to Content
avatar image
Former Member

Cumulation of Past Months Deductions

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 22, 2015 at 09:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 23, 2015 at 05:07 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded