How to calculate basic pay daily rate to be paid monthly

[Former Member]

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

[venkateshorusu]

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

[leelamohan_kavali]

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

[Former Member]

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.

[leelamohan_kavali]

Hi Sujith,

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

Regards

Mohan

[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

[Sujith_EM]

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

[Former Member]

HI Sujith,

my client is been using customized X000 - Intrnl Schema since 8 yrs. so i dont think we have PCR AEAL.

my requirement is that they put rate in Basic pay, ex Basic Pay - 100AED/Day, and the system should calculate monthly salary basing on calendar days.

can u help on what all changes are required.

Thanks

Sam

[Sujith_EM]

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**)