Please help me out in the following scenario.
1. Configuration has been done for off-cycle payroll run
2. Created wage type for bonus and included in table V_T7INA9 as per the allowance grouping of the employee
3. Wage type mapped for Tax Code SBON in table V_T7INT9.
4. In table V_T511K value for BNTDS maintained as 30%
5. Infotype 0267 maintained with bonus amount.
When running through off-cycle it's working fine and also deducting 30% of tax at source for all the employees grouped under allowance grouping.
Say an employees who is getting bonus Rs 50,000/- and for him the tax is getting deducted in Off cycle Payroll itself as per the requirement. Tax deducted is 15000 which is 30% of bonus amount 50000. Till here its fine.
Now when I run the regular payroll the tax deducted in off cycle run is cumulated in /456 u2013 tax deducted so far. Hence for the current month it is showing Tax Payable u2013 Tax Deducted / Projection factor. This is wrong. I do not want the tax deducted in Off Cycle run to get accumulated in /456 u2013 tax deducted so far wage type.
How can we handle the situation please guide me.
For April Month
/458 Net Tax Payable is 9847
460 Income tax for April is 9847 / 12 = 821
On 15 May Bonus is Paid i.e 50000 via Off Cycle
Value for BNTDS maintained as 30% so tax deducted is 15000
For May Month Regular Run
Bonus Paid is added in Irregular Income u2013 50000
Tax Payable is 14997 as bonus is added to Irregular income
/456 Tax Deducted so 15821 (i.e tax of april 821 + tax on bonus 15000)
Income tax for the month 14997 u2013 15821 / 11 (projection) = - 824
Since it is negative value /460 monthly tax is not generating which is wrong.
Actually /460 for May should be 821.
Please Guide me solve this problem