Skip to Content
author's profile photo Former Member
Former Member

Pro-Rata Allowance Calculation based on WSR

Hi,

We need to perform an enhancement for a allowance to be calculated based on their WSR. Could any one please advise what would be the best approach to perform this customisation.

Following are the details:

A calculation needs to be made based on an employee’s 0007 & 2003 records for a given month to determine what percentage of the planned hours for the month that a person has worked and then apply that percentage to the Monthly Staff Supplementary Allowance applicable for the Work Schedule Grouping.

Example A – Employee on Work Schedule for the Whole Month Employee has a 0007 infotype record that has them on Work Schedule SC112 for the whole of April 2008. System pays 100% of the allocated payment of $166.67 per month

Example B – Employee on Work Schedule for part of the Month, Employee has a 0007 infotype record that has them on Work Schedule SC112 for the part of April 2008 as they only started on 14th April 2008. Planned Hours for April for SC112 are 180 hours and this person has worked 108 hours which is 60% (=108/180). System pays 60% of the allocated payment of $166.67 per month which results in a payment of $100.00 for the employee.

Example C – Employee on Work Schedule for part of the Month Employee has a 2003 infotype record that has them on Work Schedule SC112 for the 14th April 2008. Planned Hours for April for SC112 are 180 hours and this person has worked 12 hours on SC112 which is 6.67% (=12/180). System pays 6.67% of the allocated payment of $166.67 per month which results in a payment of $11.11 for the employee.

Example D – Employee on 2 eligible Work Schedules for the Month Employee has a 0007 record for Work Schedule SC112 from 01.04.2008 to 14.04.2008 and then for SC412 from 15.04.2008 to 31.12.9999. This person has spent 100% of the month in an eligible Work Schedule grouping System pays 100% of the allocated payment of $166.67 per month which results in a payment of $166.67 for the employee.

Example E – Employee on 2 eligible Work Schedules for the Month, Employee has a 0007 record for Work Schedule SC112 from 01.04.2008 to 14.04.2008 and then for SC512 from 15.04.2008 to 31.12.9999. This person has spent 100% of the month in eligible Work Schedule groupings The period on SC112 represents 40% of the hours for SC112 for April 2008, 72 of 180 hours. The System calculates 100% of the allocated payment of $166.67 per month which results in a payment of $66.67 for the employee. The period on SC512 represents 50% of the hours for SC5112 for April 2008, 96 of 192 hours. The System calculates 50% of the allocated payment of $0.00 per month which results in a payment of $0.00 for the employee. Overall this employee receives a Staff Supplementary Allowance of $66.67 for April 2008.

Your help would be really appreciated.

Regards

Ranjith Yama

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 02, 2008 at 03:52 AM

    Hi Guys,

    Could you please advise on this,

    I'm trying to build a rule to get the Actual worked hours so that I can use the SSOLL and constant from T511k table to calculate the alowance.

    I'm pretty new in writing rules, your help would be really appreciated.

    Regards

    Ranjith

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.