Issue in MP and Orissa Ptax Deduction

[Former Member]

Dear Experts,

   I have got a issue that my client wants to deduct the MP & Orissa Ptax based on the Ptax basis in monthly deduction. Kindly refer the below table of the deduction so far and to be deducted for Feb & Mar'14.

These employees had transferred in the mid of the year. They wanted to be deducted 2500/- at the end of the year.

The slab and the groupings are fine. Return value of 40PTX set to "01" Also tell me the config changes to be done for Orissa.

Please help me out.

Emp	PT Apr.13	PT May.13	PT JUN.13	PT July.13	PT Aug.13	PT Sep.13	PT Oct.13	PT Nov'13	PT Dec.13	PT JAN.14	Total Till JAN'2014	To be deducted in remaining months	PT /month to be deducted in remaining period	PT FEB.14 on simulation	PT MAR.14 on simulation
	M.P.
Emp 1	0	0	0	0	416	208	208	208	208	208	1456	1044	522	208	211
Emp 2	0	0	0	0	832	208	208	208	208	208	1872	628	314	208	211
	Orissa
Emp 3	0	0	0	300	300	300	300	300	300	300	2100	400	200	300	300
Emp 4	0	0	0	300	300	300	300	300	300	300	2100	400	200	300	300

Thanks & Regards

Praveen

[Former Member · Accepted solution]

Dear Praneeth and Rajesh,

  Thanks for your effort.  As praneeth said I will change the slab layout once I get the Confirmed slab notification from the Client and test the same.

Mean while I got the issue that , the Ptax of Maharashtra is not deducting for the Current month(Feb'14) for some employees. when we run the employee for Mar'14 month ,the Deduction Carry Forward of Rs300/- (i.e Feb'14)is showing on Mar'14 where as March'14 month Deduction of Rs 200/- was not deducting.

But for those employees it was working fine in quality server but not in PRD,

Recently I done the Changes in Slab Layout in V_T7inp3 where I Extent them to 2016. Please refer below the same.

Please help me out .

Thanks

Praveen

[Former Member · Accepted solution]

Hi,

check the report for those employees also. have you run live run for  "Feb month" or test run only.

regards,

praneeth kumar

[Former Member · Accepted solution]

Dear Praneeth,

   I have run the Live run for the employee in Quality . It was working fine . It deducted 300/- for this month and 200 for Next Month(Mar'14).

  In PRD the PT is not deducting for some employees. Those employees not having any recent actions also.

Where can I check this issue.

Regards

Praveen

[Former Member · Accepted solution]

Check their Salary is coming under taxable slabs and check the IT 0858 sub-type 0003 PTax Eligibility check mark is their or not and from which date.

regards,

praneeth kumar

[Former Member · Accepted solution]

Dear Praneeth,

      For those employees the Ptax Eligibility are checked in IT0588(003) from the date 01.04.2012.

     Please find enclosed the RT table of Final Process in the Feb'14 Simulation run in PRD.

Here I did not get the wage types /3P2 & /3P3.

Where as for Mar'14 run ,the remuneration statement shows Deduction carry forward of 300(i.e Feb'14) and current month (i.e Mar'14 ) of 200/- was not deducting. Find below the statement

Thanks

Praveen

[Former Member · Accepted solution]

Hi,

have you seen that PF also carry forward is coming. check the master data for changes and check PU03 - Earliest master data check. check the log for INPTX, INEPF

regards,

praneeth kumar

[Former Member · Accepted solution]

Dear Praneeth,

    Please find below the screenshot of INPTX and INEPF.

INEPF:

INPTX:

IT0003:

Kindly suggest.

Regards

Praveen

[Former Member · Accepted solution]

Hi,

while running March month any arrears or payroll running for 2 /3 months. can you give PF and PTax ANN report.

regards,

praneeth kumar

[former_member182306 · Accepted solution]

Hi ,

For March Month Professional Tax Deduction for Mumbai would be Rs 300 and for remaining months it will deduct Rs 200

[Former Member · Accepted solution]

Dear Praneeth,

    Yes, Payroll Running from 01.05.2013. As in the IT0003, the EMD Change 01.05.2013.

   Please find enclosed the Annual report of PF & PT

PT:

Regards

'Praveen

[Former Member · Accepted solution]

Dear Rajesh,

     In Maharashtra , For Feb it is 300/- and rest of the months are Rs 200/-.

    Please correct me if I am wrong.

Regards

Praveen

[former_member182306 · Accepted solution]

Yes It is correct The deduction would be Rs 300 for the month of Feb and for remaining month rs 200

[Former Member · Accepted solution]

Hi,

Are you getting Arrears in the Earnings side. if so ask your client if they change any salary components in It 0008 for salary hike. this will give automatically retro run from the date of master data change. if it is not necessary for run from 01.05.2013 on-wards delete those dates in PU03 and run the payroll. No arrears or carry forward amounts will come.

regards,

praneeth kumar

[Former Member · Accepted solution]

Dear Praneeth,

    Thank for your valuable inputs.As you said, If I deletes the EMD change date in pu03,Will I get the Current month deductions of PT ?

Thanks

Praveen

[Former Member · Accepted solution]

Dear Praneeth,

  Can u explain why the wage type /zp2 shows in Minus(-) .

Regards

Praveen

[Former Member · Accepted solution]

Hi,

/zp2 came before the deletion of dates in pu03 or after ? can you paste ann report here for whole year all wage types not only ptax.

regards,

praneeth kumar

[Former Member · Accepted solution]

Dear Praneeth,

    The Minus is coming after removing the EMD date in Payroll Status.

    Please find enclosed the Annual report for all the wage types.

Please help me out.

export 3.txt.zip

[Former Member · Accepted solution]

Hi,

Run feb and march and check payslips if any deviation in the salary. and PTax and PF carry forward is coming or not ? in your attached file data upto jan month only.

regards,

praneeth kumar

[Former Member · Accepted solution]

Dear Praneeth,

     Please find below the PT related wage types for the FY so far. Could you please explain about th /zpt an /zp2 minus values

		April	May	June	July	August	September	October	November	December	January	February	March
/3P2	Professional Tax Basis	94,094.00	94,094.00	94,094.00	95,681.00	95,681.00	95,681.00	390,746.00	103,271.00	99,731.00	0.00	0.00	0.00	1,163,073.00
/3P1	Prof Tax - split period	200.00	200.00	200.00	200.00	200.00	200.00	200.00	200.00	200.00	200.00	0.00	0.00	2,000.00
/3P3	Prof Tax - Full period	200.00	200.00	200.00	200.00	200.00	200.00	200.00	200.00	200.00	200.00	0.00	0.00	2,000.00
/ZPT	Interm. gross carry fwd	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	104,097.00-	0.00	0.00	104,097.00-
/118	PTax Basis	94,094.00	94,094.00	94,094.00	95,681.00	95,681.00	95,681.00	245,123.00	103,271.00	99,731.00	104,097.00	104,097.00	0.00	1,225,644.00
/119	PTax Basis Nominal	94,094.00	94,094.00	94,094.00	95,681.00	95,681.00	95,681.00	160,236.00	103,271.00	99,731.00	105,047.00	104,097.00	0.00	1,141,707.00
/ZP2	Ptax basis arrears	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	104,097.00-	0.00	104,097.00-

[Former Member · Accepted solution]

Hi,

See it wont give any effect. just run in the testing system for live run and check 2500/- total is deducting or not for whole year ? and it should not give any carry forward amounts.

[Former Member · Accepted solution]

Dear Praneeth,

    The Amount is getting deducted in Quality system. But not in the PRD as I said earlier. Infact the users had run the Live  payroll run for Feb '14 and the same was not deducted. where as in Mar'14 simulation, 200/- is deducting without Deduction carry forward of Rs300(i .e Feb'14).

I discussed with the users,they had not done any master changes for this month.

I am confused about the Wage type /zpt and /zp2 Minus values. I think this will add with the PT nominal Basis and become zero for the PT .

Any Idea ?

Regards

Praveen

[Former Member · Accepted solution]

Praveen,

if any changes in the master and ptax basis changed these WT's will come. and deduct the correct PTax. In production no carry forward means it is deducting only 2500/- and correct only. your quality and production system masters are different and you had done so many R&D. ask your user to give the payslip screen shot for the month of March'14 and check for Ptax total deduction in the form 16 area.

[Former Member · Accepted solution]

Dear Praneeth,

   Please find below the Payslip of Month Mar'14.

I have checked the Form 16 for this employee and IT shows only 2000/- under Employment tax. It means this month PT was not showing and based on this month it takes projection . so it stops to 2000/-

Where as for the other emp(whose PT 300/- Ded) are showing 2600/- under Emp tax in Form 16. i.e its taking projection of current month value 300/- for Mar also. when we run Mar'14 for this emp it come to total 2500/-

But for the error emp ?

Regards

Praveen

[Former Member · Accepted solution]

Praveen,

check the dates once again in Table V_T7INP3 and V_T7INP4 also MH01, MH02 slabs amounts.

check for retro or any master changes with out changing of master projection / retro will not happen.

some thing wrong with the master data only. check the both cases of these employees each and every thing, you can find some difference.

regards,

praneeth kumar

[Former Member]

Dear Praneeth and all experts,

    Problem is solved for Maharashtra Ptax.As praneeth said it was an date specification error.  Thanks For your Valuable inputs.

   But the issue related to the MP Ptax is not yet solved. I have tried all the Return Value - 1,2,3 & 4 in the Feature 40PTX . But the result was same. My client want the employees to be deducted 2500/- /Ann.

Please suggest.

Regards

Praveen

[Former Member]

Hi,

can give the screen shots of table V_T7INP3 AND V_T7INP4 and for which region you MP state is assigned.

regards,

praneeth kumar

[Former Member]

Dear Praneeth,

   Thanks for the reply. Please find below the table screen shots for MP Ptax

V_T7INP4:

V_T7INP3:

Praneeth, As I said about the MH Ptax, it was working on simulation of Feb(300/-) and Mar(200/-) in testing system,

But client had run the payroll without deducting Rs300/- on Feb'14 payroll as this issue was not resolved on that time, Now they want that to be in Deduction Carry forward. The system is not deducting the Feb'14 300/-. It deducting only mar'14 Ptax 200/-.

Please tell me if any Missing Configs?

Regards

Praveen

[Former Member]

Hi,

Try this change the gross carry forward to deduction carry forward and run forced retro in (pc00_m40_calc) from Feb' 14 on wards. first check in quality system and then change in production.

just keep in mind if any master data changed for IT 0008, 0014, 0015 for the feb month those also will come in retro.

regards,

praneeth kumar

[Former Member]

Dear Praneeth,

  As you said, I have changed to Deduction carry forward to the only period Feb'14 ( MH02) which wanted to come in Deduction Carry Forward in Mar'14 Payroll.

I had removed the Eligibility in IT 0588 and live run in Quality system for Feb'14 and Tick the eligibility and ran the live run for Mar'14, the system is considering the Deduction carry forward of Feb 300/-..

But it is not deducting in PRD client as the user already ran payroll without deducting for Feb'14.

I tried put the Forced retro period from 01.02.2014 and 01.04.2013 as well, in simulation run. Result were same.

Please suggest.

Thanks

Praveen

[Former Member]

Dear Praneeth,

    To deduct the Feb'14 month Ptax, Shall I ask my user to create another entry in IT0588(0003) from the date 01.02.2014 and delimit the previous entry to 31.01.2014, and ask to run the retro from Feb?

   Will it works out?

   Please suggest.....

Regards

Praveen

[Former Member]

Hi,

Try but i am not sure. if any changes in the system after Feb'14 run arrears will come check this also.

for how many employee this problem raised.

regards,

praneeth kumar

[Former Member]

Thanks Praneeth,

   I will try. We have this issue for 10 to 15 employees.

Regards

Praveen

[Former Member]

Hi,

Can you give some information regarding the Employee transferred from which state to which state ? and from the which month ? what is the Ptax so far deducted and now what it is deducting.

As per your figures it is deducting correctly. for MP state is yearly once Ptax deduction. have  you change the configuration like Ptax deduction Month wise ?

for your orrisa employee it will deduct 2500/- only test one employee in the testing server like run live run for all the periods and then check.

regards,

praneeth kumar

[Former Member]

Dear Praneeth,

   Thanks for your reply. The MP State Emplyees EMP 1 is transferred from Delhi on the month Jul'13 and EMP 2 transferred from UP on the Month May'13.

  Both the Orissa employees are working there in Orissa since before April'2013. I have ran the Live run for the Orissa Employees in Quality, but it is deducting 300/- in Feb and Mar'14

Please find below the Employees deducted so far and to be deducted on the FY.

Your suggestions will resolve

New P.No.	PT Apr.13	PT May.13	PT JUN.13	PT July.13	PT Aug.13	PT Sep.13	PT Oct.13	PT Nov'13	PT Dec.13	PT JAN.14	Total Till JAN'2014	To be deducted in remaining months	PT /month to be deducted in remaining period	PT FEB.14 on simulation	PT MAR.14 on simulation
M.P.
Emp 1	0	0	0	0	416	208	208	208	208	208	1456	1044	522	208	211
Emp 2	0	0	0	0	832	208	208	208	208	208	1872	628	314	208	211
Orissa
Emp 3	0	0	0	300	300	300	300	300	300	300	2100	400	200	300	300
Emp 4	0	0	0	300	300	300	300	300	300	300	2100	400	200	300	300

Thanks

Praveen

[Former Member]

Hi,

For Delhi no PTax. after transferred to MP it is deducted. PTax is deducted on Monthly Basis 

Employee 1 is transferred in July i.e., 208*8 + 211*1 = 1664 + 211 = 1875 ( System is correct)

Employee 2 same as 208*10 + 211*1 = 2080 + 211 = 2291

for orrisa state send the Slab rates for the current year i will check and suggest you.

regards,

praneeth kumar

[Former Member]

Dear Praneeth,

  Thanks for your inputs.  

  But the users are saying that as per the MP Ptax norms it should be deducted 2500/- though the employee has joined or transferred to MP mid of the Year.

Same for the Orissa Region.

Once I receive the Orissa PT Notification from the Users, I will enclose .

Please suggest

Regards

Praveen

[Former Member]

see, they changes the configuration like month wise deduction. if it is changed month wise it will deduct like this only it is sap standard. actually MP state is deduction is once in a year 2500/- and it will deducted in the month of March. if they want 2500/- deduction at a time only once means again change the configuration for MP state. check the table V_TINP3 which region is assigned to the MP and Orissa.

regards,

praneeth kumar

[Former Member]

Thanks Praneeth,

   But How can I convince the client, since they are following of deducting the MP PT on Monthly basis. They do not want to deduct the 2500/- in a single month where it makes more burden to the Employees on that month.

How can I tackle this issue.

As the Current system PT Configuration of Orissa is

Please suggest.

Regards

Praveen

[Former Member]

Hi,

Simple logic, they want to deduct the Ptax month wise wright. Ask the client if employee is not worked in that particular state how can you deduct the Ptax and deposited in the government account ? in your case Employee from Delhi, no ptax area if employee transfer from Mumbai then they already deducted ptax for those months worked again you want to deduct ptax in MP also for that period ?

For orissa employees some wrong calculations are going can give screen shots of these tables

pc00_m40_ann (from 01.04.2013 to 31.03.2014), v_t7inp3, v_t7inp4

regards,

praneeth kumar

[Former Member]

Dear Praneeth,

  Thanks for your idea. Please find enclosed the Screen shots of the Orissa Employees.

PC00_M40_ANN:

I tried running payroll for Feb & Mar'14 but the value deducted for both the month is 300/-. So the total comes to 2700/-

V_T7INP3:

V_T7INP4:

Please suggest.

Regards

Praveen

[Former Member]

Hi,

In Table V_T7INP3 - OR03 is assigned from 01.03.2013 to 31.12.9999 wrong assignment.

it should be:

OR03 .......................................................... 01.03.2013 31.03.2013

OR02 .......................................................... 01.04.2013 28.02.2014

OR03 .......................................................... 01.03.2014 31.03.2014

OR02 .......................................................... 01.04.2014 28.02.2015

like it has to be their. even they didn't cross check also why it is deducting Ptax 300/- every month.

Now change the assignment and run with force retro from Employee joining month on-wards, system will do corrections.

regards,

praneeth kumar

[former_member182306]

Hi Praveen,

Could you please be more clear How much it has to deduct for Orissa and how much it is getting deduct wrongly?

[Former Member]

Dear All,

   Please throw some light as the client need to run this month payroll.

  Thanks

Regards

Praveen

[Former Member]

Dear Experts,

    Please give some inputs..........       Thanks

Regards

Praveen