Skip to Content
avatar image
Former Member

How to calculate basic pay daily rate to be paid monthly

Dear Team,

I have a urgent requirement which is give below.

I have a situation that daily wagers have only one basic pay, which is maintained in IT 0008-Basic Pay as 100 AED/Day but are paid monthly once.

Ex. a record in IT 0008-Basic Pay

01.10.2016 - 31.12.9999

1000-Basic Pay 100 AED/Day

as my client follows calendar year, for Oct 2016, there are 31 days.

hence the employee should be paid 100*31 = 3100 AED salary for Oct month.

and AED 3000 for the month of November and vice versa

if there are any unpaid absences, then deduction should be paid as per unpaid leave/day.

Can anyone guide me on how to achieve this scenario.

Thanks

SAM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Oct 21, 2016 at 07:23 AM

    Create a custom specification for processing class 10, and in the valuation PCR AEAL for the custom specification multiply the amount with ( TKSOLL-TKAU**) or (TASOLL-TAAU**) as per your requirement

    Add comment
    10|10000 characters needed characters exceeded

    • Instead of AEAL there will some rule ( XVAL is the international) there in your schema , you do the changes there.

      create a separate wage type for the Basic pay daily rate and maintain only for those employees, then create a new custom specification for processing class 10, assign it to your wage type.

      And in your valuation PCR ( XVAL international) when query for your custom specification , do the multiplication of the daily rate with ( TKSOLL-TKAU**) or (TASOLL-TAAU**)

  • avatar image
    Former Member
    Oct 21, 2016 at 08:08 AM

    Hi Sujith,

    Could you please elaborate your requirement? what is your scenario.

    Regards

    Mohan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI Mohan,

      My client has a requirement that they pay certain emp grp on daily rate, which is paid on monthly salary.

      For example rate in Basic pay - 100AED/Day, and the system should calculate monthly salary basing on calendar days. Lets suppose for Oct month for 31 calendar days, emp should be paid out AED 3100 as salary if there are not unpiad absences.

      can u help on what all changes are required.

      Thanks

      Sam

  • Oct 21, 2016 at 04:58 PM

    Am I right in assuming that you are working on Payroll for the United Emirates and that your Payrll Periods are Monthly?

    In table view V_T511, what is the Indirect Valuation Module used for the employee's Basic Pay WT?

    If you execute a Payroll Simulation with the "Display log" box checked, for one such employee with at least one absence in the Payroll Period, look at the Partial Period Parameters (processing of Function PARTT) and you will see the parameters that Sujith suggested for use.

    Note that there is a lot of documentation on the subject in help.sap.com and elsewhere on the web.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2016 at 06:43 PM

    Hi Sam,

    I hope you are using standard PCR i.e AEPF

    In AEPF logic is like below

    /810 Partial period factor 10

    RTE=TSDIVI Set (Total working time measured in working hours)

    RTE-TSDIVP Subtraction

    RTE*KGENAU Multiplication

    RTE/TSDIVP Division

    ADDWT * OT Output table

    So above logic is says that calculate employee salary based on employee working hours but as per your scenario you will have to change logic into

    RTE=TKDIVI Set (Total working time measured in calendar days)

    RTE-TSDIVP Subtraction

    RTE*KGENAU Multiplication

    RTE/TSDIVP Division

    ADDWT * OT Output table

    Just cross check and let me know if still any farther clarification is required.

    Regards

    Mohan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 11, 2016 at 10:28 AM

    As i understood it correctly you are maintaining 100 AED per day now you would like to multiply it with number of attendance days for the same what we can do is instead using factoring concept we modify our factoring PCR to get number of attendance days.

    TKSOLL Planned working days

    TKAU** No of absence days(We can differentiate absence using counting class)

    /8**

    RTE=TKSOLL

    RTE-TKSAU**

    ADDWT *

    Now valuating the amount.

    RTE= /8** No of attendance days in the partial period

    MULTI ARA Amount is maintained as 100 AED Multiplied with rate which we are using for number of attendance days

    ADDWT *

    to avoid decimal rounding issues you can use 10,100,1000,10000,100000 as multiplication factor.

    Regards

    Venkatesh

    Add comment
    10|10000 characters needed characters exceeded