IT0015 Allowance WT - Need assistance in Payroll calculation

[Former Member]

Dear SAP Team,

I would need your advice on the below scenario and how to handle this:

If an employee completes 6 months of service, he is eligible for an allowance in his 7th month payroll. The actual earning for the last 6 months (only basic salary taken into consideration and not any other wagetypes. Also retro changes to be considered for Basic salary) divide by 6 would be his allowance.

For eg: His basic salary is 1000 (Jan-June). In March, he was on LOP for half month. Hence, his actual earning for 6 months is 5500/6=916.66 is the allowance paid in July Payroll.

Please let me know the best possible way to handle this.

Thanks!

Swetha

[sikindar_a · Accepted solution]

The allowance should get calculated from the date of Joining
of employee within six months

So for this let us go with a PCR with If and Else conditions

X

XXXX

NUM=FXX1M_ 

Num?06

*

Scond=T IF

<

Scond=F IF

Use this PCR in schema as below

DATES

PIT   XXXX     

Now Second one

AMT=CUXXXX  (you basic
pay is XXXX)

AMT/6

ADDWT  YYYY

Now place this PCR as below

DATES

IF   PCR1

SORT   CRT

PIT   YYYY     NOAB

ENDIF

  This Requires Extensive testing (what in case if there is delay in paying the amount to the employee means if payment is made in 7th month then how do you process)

[Sanky · Accepted solution]

Hi,

Go with Sikinder's reply.

Any query ask me.

Regards,

Sankarsan

[Former Member · Accepted solution]

Hi Sankarsan,

This is not only for new joiners. For all employees (including new joiners) after completion of EVERY 6 months, they get this allowance. All employees (From their Date of joining), Every 6 months completion say 6 months/12 months/18 months/24 months so on.

Thanks

Swetha

[Sanky · Accepted solution]

You can do it through PCR.

Every month you will pass your basic value to One dummy wage type and it will cumulate for monthly basis and at the same time create one monthly counter wage type for count the month.

Now through your pcr you will cumulate basic value and no of month.

Once month will be reach to 6 then wahetever value has been sored to monthly cumulate wage type you will pay to your allowance wage type.

And will make counter wage type reset from zero and dummy wage type too.

Check and tell me.

Regards,

Sankarsan

[Former Member · Accepted solution]

Thanks Sikindar, Sankarsan, Venkatesh for looking into this.

I am not so well-versed with PCRs. Could you please help me to write one.

Thanks

Swetha

[Sanky · Accepted solution]

Hi Swetha,

Venkatesh has given you the link. You can go through it and do accordingly.

If after that you need help please let me know.

Regards,

Sankarsan

[venkateshorusu]

If your query is answered you can close the thread.

Regards

Venkatesh

[Former Member]

Hi Venkat,

I am still working on it. I am following the links which you provided. I surely close it once it is resolved.

Regards

Swetha

[venkateshorusu]

Can you clarify one thing whether you have written the PCR to calculate the average of basic or went for Program.

Regards

Venkatesh

[venkateshorusu]

Please find the below links.

Once you are having the average of 6 months you can Query the no of years based on date specification or entry date of 0000 by using NUM=F01J_A 06 F01Y_A or FA_J__.

Regards

Venkatesh

[Sanky]

Hi Swetha,

You can control it through PCR.

I want to know that it will be case of new joinees and will be getting allowance on 7th month and will not begetting this allowance in the future service period in the organization.

Am i correct?

Regards,

Sankarsan