Gross Pay Modification

[Former Member]

Hi Gurus,

I need help again.

For certain group of employees, there is a condition where in 12% of the gross pay for THAT pay-period is added and this is the total gross (upon which taxes will be calculated). For e.g.: Say $200 is the gross earning (because he worked 10 hours for $20/hour). Now, 12% of 200 which is 24, is added and the total gross for that pay-period becomes $224. This $224 is then taxed. Can you please help writing a rule for this condition and where will you insert the same in the schema.

Thanks for the help,

[sikindar_a · Accepted solution]

How you are paying this Amount it should be thru Additional Payment if yes

here is the rule

*

XXXX the wage type which you want to pay that 12%

AMT=o

AMT+ Basic Wage type (Give Double Space) after AMT+ like this include all the wage types of the Gross Payments

AMT*12

AMT/100

ADDWT *

and insert the PCR in below line where the P0015 Will get reads in the Schema

[Former Member · Accepted solution]

Thanks for the answer!

This amount is not paid separately anywhere. Just that the 12% is multiplied by the gross pay for that pay-period and this new amount will now be the total gross pay of the employee.

So I guess there is no need for a new wagetype.

Just slightly modifying your rule, can I write something like this????

AMT = 0

AMT = /101*12

AMT/100

/101 = AMT+/101

I guess the wagetype /101 will have the total gross pay for the employee for that pay-period. I am just taking that amount and multiplying the 12% and creating a new total gross pay value and putting the same onto the /101 wagetype again.

Will this work? But how do I call this rule and where to insert?

Please help,

Thanks,

[sikindar_a · Accepted solution]

If the amt is 12% on gross right so it shd included directly in gross

Does it mean that are u not maintaining any Inputs in any of the infotypes

No i dont think the above rule will work

either u can use the Valuation basis V_512W_B to valuate the wage type on total Gross

you have to maintain the wage type and pass the AMT into /101 Iam sure of this one

[Former Member · Accepted solution]

Thanks. ok.

If I use IT0015, but in this infotype, I can enter only an amount or a number for a wagetype. How can I get the 12% of the total gross added to the total gross.

Please help,

[sikindar_a · Accepted solution]

Copy a Wage type from the Wage type group IT0015

in wage Type Characterstics give Time / Measure Unit as Percent

and in Input combination Amount feild give "." and Number/ Unit +

and try to maintain the wage type in IT0015

and in table V_512w_B give /01 /101 12% for this wage type and test

and let us know

[sikindar_a · Accepted solution]

Just now tested from my side

Try with the help of the PCR instead of Valuation basis

in the PCR instead of * give 3 and continue the PCR with rest

it will work

[Former Member · Accepted solution]

Thanks for your quick response! I really appreciate your help.

So you are saying there are 2 ways of solving this issue:

1. I will create a new wagetype (I mean copy and create) and make the characteristics as you have mentioned. Also I would maintain the valuation basis too. But what will I enter on IT0015, using this wagetype? Will I enter any value?

2. In the second way, I will again create a new wagetype and make the charactersitics as you have mentioned. Then write the PCR. Again what value will I enter on IT0015 using this wagetype? Will I entere 12? And the PCR should be as follows as you had mentioned:

AMT=o

AMT+ Basic Wage type (Give Double Space) after AMT+ like this include all the wage types of the Gross Payments

AMT*12

AMT/100

ADDWT *

Sorry, I could not understand the first and second line of the PCR?

Please reply at your convenience.

Thanks,

[sikindar_a · Accepted solution]

I tired the first way but it has not woked so went with PCR

For this we have to write the PCR and in infotype just maintain the Percentage as input and go with PCR

3

XXXX (your Wage type)

AMT=0

AMT+ XXXXX

AMT*12

AMT/100

ADDWT *

this is the PCR

[Former Member · Accepted solution]

Thanks!. I will definitely try out the PCR. Just a few more questions:

1. Why the 3 for the PCR?

2. I won't enter any value on IT0015 using this XXXX wagetype, right?

3. How would I call this rule in the schema? Using ACTIO?

Please do let me know,

Thanks,

[sikindar_a · Accepted solution]

1. Why the 3 for the PCR?

3 represents Salaried employee i kept * that time i did not get any Amount

2. I won't enter any value on IT0015 using this XXXX wagetype, right?

you wont enter any any Amount you will give Inputs as 12 % in IT15

3. How would I call this rule in the schema? Using ACTIO?

Use PIT

[Former Member · Accepted solution]

Thanks a lot, Sikander.

I will certainly try it out and let you know my results. Just to write the complete process again:

1. A new wage type for IT0015 (say for e.g: 9915)

2. In table V_T511, "Time unit/meas." field as "Percent".

3. Input combination: Amount: '.' and Number/unit: '+'

4. Create a new entry on IT0015 with wagetype 9915, Number/unit as 12/Percent.

5. Create a PCR (say for e.g: ZZ15) as you had suggested. I need this PCR only for Hourly Union employees. So, I would put "1", right?

6. Call this rule in the schema as PIT ZZ15 below the line P0015 U010

Is that all?

Warm Regards,

[sikindar_a · Accepted solution]

yes

for US UAP0 Sub Schema in U000 Schema

Let us know in case of any issue

[Former Member · Accepted solution]

Thanks Sikindar. I will try this out today or tomorrow and let you know my results.

I was also wondering incase the number 12 changes, do I have to make the change at 2 places:

1. In the IT0015 record?

2. Also in the rule?

Is that correct?

I also need the amount value of 12% (which is $24 in our example) as a separate line item on the rem statement for each pay-period. How is this possible?

Please help,

Thanks,

[Former Member · Accepted solution]

I have one more question in addition to my earlier ones:

The user does not want to enter the 12 on IT0015. Can we just do it with the PCR itself without entering anything on IT0015?

Something like this:

1

****

AMT = 0

AMT = /101*12

AMT = AMT/100

/101 = /101 + AMT

Please do let me know,

Thanks,

Edited by: SAP HR on Mar 25, 2010 8:18 PM

[sikindar_a · Accepted solution]

I was also wondering incase the number 12 changes, do I have to make the change at 2 places:

In this case please try to have a Constant in V_T511P and Maintain the Rate* for the constant so when ever there is a change in the Percent we can change the constant value

No need to change the rule just change the Constant value from 12 % to 15 % like that

The user does not want to enter the 12 on IT0015. Can we just do it with the PCR itself without entering anything on IT0015?

Something like this:

1

****

AMT = 0

AMT = /101*12

AMT = AMT/100

/101 = /101 + AMT

Please Change the PCR like this

1

AMT=0

AMT+ MB10 (note like this u have to include all the wage components which are in part of Gross just giving /101 will not serve

AMT*KZCON (this is the constant which we defined in V_T511P )

AMT/100

ADDWT *

Yes there is a way without maintaining in Inofytpe we can make a Wage type generate in the RT

Instead of useing PIT use ACTIO keep it in Sub Schema UAL0

I also need the amount value of 12% (which is $24 in our example) as a separate line item on the rem statement for each pay-period. How is this possible?

Will let u know abt this

[Former Member · Accepted solution]

Thanks for your response, Sikindar!

So when I am not maintaining IT0015, then I don't need to create any custom wagetype, right? or do I still have to create the wagetype and perform the steps in T511 which you had mentioned earlier?

So are these my complete steps:

1. Maintain a constant in T511K table say for eg. ZZZ111, with a value of 12.

2. Write the PCR (call it as ZZZZ) as you have mentioned. I have a question: What is MB10? Is the equivalent of the basic pay wagetype of the employee?

3. Call this rule as ACTIO ZZZZ in the last line under the UAL0 sub-schema.

Are these the complete steps?

Please take your time and let me know the solution to my other issue in my last reply.

Thanks a lot for your help,

[sikindar_a · Accepted solution]

So when I am not maintaining IT0015, then I don't need to create any custom wagetype, right? or do I still have to create the wagetype and perform the steps in T511 which you had mentioned earlier?

No , You have maintain the wage type but as per the standrad without any changes in Wage type Characterstics

1. Maintain a constant in T511K table say for eg. ZZZ111, with a value of 12.

yes , As you mentioned in case of any change in Percent in future this is required

2. Write the PCR (call it as ZZZZ) as you have mentioned. I have a question: What is MB10? Is the equivalent of the basic pay wagetype of the employee?

yes , i have taken it as sample one in ur case they would Client Specific

3. Call this rule as ACTIO ZZZZ in the last line under the UAL0 sub-schema.

If you are useing ACTIO u have to give in UALO

Are these the complete steps?

These are complete steps

[Former Member · Accepted solution]

Thanks for the response, Sikindar.

If you don't mind, can I please have your phone number and/or your email ID so that I talk to you regarding this issue? If not, then no problem, I can continue asking my queries here.

I reckon talking over the phone would clear the doubts more effectively.

Thanks and Regards,

[sikindar_a · Accepted solution]

You can Check my B Card