PCR for service tax calculation

[Former Member]

Dear Experts,

I have a requirement to deduct service tax from basic salary if employee does not serve full notice period in the organization. The requirement is as below in detail:

1. The amount(Y) for shortfall will calculated as: (Basic salary*No. of days of notice period shortfall)/30.

This will give amount(Y) of notice period recovery and can be put in IT15.

2. Apart from this there will be three other types of service taxes applicable:

A) Service Tax payable Basic- This will be calculated as Y/1.14

B) Service Tax Payable K Cess - This will be calculated as Y*0.005

C) Service Tax payable Swach Bharat Cess - This will be calculated as Y*0.005

D) The total of A, B & C will be added and subtract from Y. Result will be say X

These above four A, B, C & D different amounts will be posted to four different G/L accounts in posting.

I want to write a PCR through which I can get amount for all Y, A, B, C & D.

Pls help as my Go-Live is next week and I got this reqt. now from FI department.

Thanks

Megha

[Sujith_EM]

Hi,

Please create two date types in IT0041 one for start of notice period and one for separation date.

1. Find out the days between Joining date and start of notice period 

2. Find out the days between Joining date and separation date.

3. Find the difference between 2 and 1 ( 2-1)   and compare that with notice period days

[Former Member]

Hi Sujith,

How will I create a PCR using dates?

Thanks,

Megha

[Former Member]

Hi Megha,

1. you have to create date types in the IT 0041

ex. Q2 - Notice period last date

      Q4 - Last working date

2. you have to maintain these dates in the Employee masters either manually or through Dynamic action while running Resignation action we can do dynamic action for Q2 - notice period last date and you have to maintain Q4 - last working date manually. if you want Q4 also dynamic action we can do according to the Action & Action for reason type.

3. Create a custom PCR

ZQ72  IT 41

    3

      2005 Travel Advance Recovery

        NUM=FQ2TB  Set

        NUM-FQ4TB  Subtraction

        AMT=  1000 Set

        AMT/30     Division

        MULTI ANA  Multipl.amt/no/rate

        ADDWT 2005 OT   Output table

4. Insert in the Schema ZNAP (copy of INAP) after the Function P0015.

Best Regards

[Former Member]

Hi Praneeth,

Thank you so much, I am trying to create this. Shall get back once done.

Thanks,

Megha

[Sujith_EM]

Hi,

Please include the step of comparing notice period days  with the difference between notice period start and separation date

[Former Member]

Hi,

we don't know exact the notice period days, may be these notice period will vary from one level to another. that's why i given option to maintain the Notice period last day in IT 0041 and i am comparing with Employee last working day.

[venkateshorusu]

Please confirm using time evaluation or not this can be handled with the help of time schema and we should maintain details notice period end date then accordingly we can place the logic in the system.

Regards

Venkatesh

[Former Member]

Hi Venkatesh,

We are not using positive time management.

Can anyone help me writing PCR for calculating (Basic salary*No. of days of short notice pd served)/12

Thanks in advance

Megha