Rules_Payroll India

[Former Member]

Experts

I have a requirement in Payroll India which i can't fill in Standard.

For Super annuation 15% is the calculation as per standard and Processed through /Wage types upto Rs 55,0000 of Basic Pay in RT table.

But the Constraint here is if the Wt1000 Basic in RT table is Greater than 55,000 for Example 60,000 maximum Amount of 8250 is processed as superannuation of that month and remaining 750 paid as Custom taxable Wage type

55,000 - 15% = 8250 (Super Annuation)

60,000-15% = 9000 (Total) i.e 8250 (Super annuation), 750 (taxable custom WT 3001)

Please help me in doing this through Rules.

Edited by: HRSAP2011 on Jul 20, 2011 8:00 AM

[Former Member · Accepted solution]

Have you written PCR for this.. if yes and you are facing some problem then put ur PCR here to analyze. If no, then try to implement the following logic -

1. Store the 55000 constant in V_T511P.

2. In PCR read the BASIC WT, compare it with constant stored in table. IF less then i feel you are already processing. If more than 55000, get the delta and apply the percentage. Store it into a custom wage type.

[Former Member]

.

[Former Member]

Try it

*

your custom wage type

AMT?55000 Comparison

*

ADDWT /3S1 OT Output table

>

AMT=55000 Set

AMT%15 Percent calculation

ADDWT /3S1 OT Output table

AMT>* Form maximum

AMT-55000 Subtraction

AMT%15 Percent calculation

ADDWT (your custom wage type , taxable part) OT Output table

[Former Member]

Hi SAP HR,

I have written rule as u guided and inserted it in Schema INN1 under function INSAN as below

000280 INSAN Superannuation calculations

000290 PIT ZSUP Sup Exceeding 8250

But seems rule is not working and 15% of Superannuation is Simply calculating eventhough i am maintaining 1,00,000 as Basic and 15,000 is generated in /3S1.

Kindly let me know if i need to insert some where else .

[Former Member]

Assign after line 000650, IN71 and test

pit (your pcr) noab

[Former Member]

Hi SAP

As you mentioned i have inserted under the line 650 in Schema ZNN1(From INN1)

00640 PIT INPX * Modify monthly Profession Tax

000650 INS24 * Section 24 Deductions

000660 PIT ZSUP NOAB Super Exess

But still Getting that Flat 15% is contributed in /3S1

[Former Member]

Revert back me with rule that you have modified, so that I can analyise

[Former Member]

Hi SAP HR

The rule i have written is

ZSUP Super Annuation Excess amount Payout

*

3012 Superannuation

AMT?55000 Comparison

*

ADDWT /3S1 OT Output table

>

AMT=55000 Set

AMT%15 Percent calculation

ADDWT /3S1 OT Output table

AMT>* Form maximum

AMT-55000 Subtraction

AMT%15 Percent calculation

ADDWT 3012 OT Output table

And i have inserted in Schema ZNN1 (line 660)

000640 PIT INPX * Modify monthly Profession Tax

000650 INS24 * Section 24 Deductions

000660 PIT ZSUP NOAB Super Exess

000670 PIT IN71 P71 NOAB * Customer specific taxabilities

000680 PIT IN70 P70 NOAB Cumulate wage types for tax calculation

Kindly let me know how to rectify this

[Former Member]

If Im not wrong, your requirement is, suppose, you have paid to an employee of Rs. 9000 towards Supernauation, so following should be calculations

a) payment = 90,000/-

b) exemption (/3s1) = 55,000/0 * 15% = 8,250/-

c) taxable part (90,000- 55000) = 45,000 * 15% = 6,750/-

right.

write a rule like this and insert in INN1 after IN71

3012

ADDWT 3012 OT Output table

AMT?55000 Comparison

*

ADDWT /3S1 OT Output table

>

AMT=55000 Set

AMT%15 Percent calculation

ADDWT /3S1 OT Output table

AMT>* Form maximum

AMT-55000 Subtraction

AMT%15 Percent calculation

ADDWT (taxable wage type) OT Output table

[Former Member]

Dear SAP HR

I have writte rule

ZSUP Super Annuation Excess amount Payout

*

3012 Superannuation

ADDWT 3012 OT Output table

AMT?55000 Comparison

*

ADDWT /3S1 OT Output table

>

AMT=55000 Set

AMT%15 Percent calculation

ADDWT /3S1 OT Output table

AMT>* Form maximum

AMT-55000 Subtraction

AMT%15 Percent calculation

ADDWT 3012 OT Output table

and Insereted in INN1

00660 PIT IN71 P71 NOAB * Customer specific taxabilities

00670 PIT ZSUP Superannuation

00680 PIT IN70 P70 NOAB Cumulate wage types for tax calculation

As you mentioned But still /3S1 is calculating 15,000 for 1,00,000 Basic Pay

But As per my Requirement only 8250 (Basic 55,000) shpould be Processed in /3S1 and remaining amount (15,000-8250) should be Processed in 3012 WT.

And From the rule i understood that it is compared 55,000 (Which is basic).

Kindly let me know how to rectify this.

[Former Member]

Really surprise, might be you have copied wage type with other model model type, try to copy MB10 (PC1,3,4,5,6,10,20,30,31 assign as 3,0,6,0,0,0,8,0,0 respecitvely) and test.