Amount should be calculate based on percentage given in IT0014

[Former Member]

Hi Team,

We have one requirement where Client want's to enter Percentage (Ex 10% ) in IT0014 for WT1234 and system should calculate the amount 10% of /101 and display the amount in WT 1234 in RT table as well as in pay slip.

For EX: If User enters 10% for WT 1234 then system should calculate 10% of /101and store the  generated amount in WT 1234.

Request you to please help me on this requirement how to write PCR.

Many Thanks

Regards,

Reddy.

[Former Member]

Dear Reddy,

Please find the pcr below.

Regards,

Dora

[Former Member]

Hi Dora,

Thank you for the below.

I did the PCR as per above screen shot. However still facing the same problem.

In WT characterizes for 1234,I have used PRZNT and Units differently, No luck. I have maintained 10% or units in IT0014 for WT 1234.

The written PCR has been added in ZGT0 (GT00in Standard) schema immediate under P0014 function.

I am explaining Query again. When I Maintained % (or number) in IT0014 for WT 1234 that % calculate from /101.

If Input % or number is 10.

My /101 is 1000

Then My input in WT 1234 should be 10% of /101 which should 100.

However in RT table I can able to see only Number Unit column, no Amount in front of the value.

Please help me on this.Thank you once Again.

Regards,

[Former Member]

Dear Reddy,

Hope you are working on UK payroll. First of all you need to configure wage type 1234 hours or percentage which means user can maintain only with number in info type 14.

coming to pcr when you are reading wage type /101 you need to place your pcr end of the factoring why because /101 will be populated only after standard pcr X023 which is end of sub schema GAL0(GB). or else you can write small pcr to add all the wage types which are required for this type of calculations to one custom wage type place it in Initialization block so that instead of /101 you can use that wage type for calculation, if you follow like this your pcr placing is works fine.

Hope you got the clarity.

Regards,

Dora

[Former Member]

Hi Dora,

Thank you above.

Yes I am working on UK payroll and created WT1234 to enter number/units in IT0014.Its working fine.

Actually My requirement is for /111 not for /101 which I Maintained under P0014 function. Due to security reason I have given /101,hope you understand.

Regards,

[Former Member]

Hi Dora,

Sorry for the above to give WT as /101 instead of /111.

Could you please help me please.

Regards,

[Former Member]

Dear Reddy,

Instead of querying the /111( EE's Pensionable pay) you might be aware about what are wage types which are considered for pension basis, better you add all the wage types into one custom wage type or in the pcr it self modify as below.

*

****

WGTYP?     Query wage type

****

Addwt *

1234 your wage type

Amt=     /101 (instead of /101 you can read amt=1000) 1000 is your basic as example.

Amt+1010 ( hra or DA) like that you read all the employee pension basis wage types.

amt/ 100

num= 1234

multi   ANA

addwt *

Regards,

Dora

[Former Member]

Thank you Dora,

I will try and let you know.

Regards,

Reddy.

[Former Member]

Hi Experts,

I have tried with what Dora suggested, but no luck.

Can any body help me on this who worked on UK payroll.

Requirement: If input enters in IT0014( lets assume 5%,this will change depends on Inputs enters ) for a WT 1234,then that value should calculate 5% of /111 pensionable pay and reflects the value in WT 1234.

EX: /111=10000

Input enters in IT0014 for WT 1234=5% ,

Then expected value in RT table for WT 1234 is 500.

Can anybody advise how to write PCR on this.

Thanks.

[Former Member]

Dear Reddy,

Hope you are confused, please write the pcr as below and change the wage type instead of /101 your wage type /111 it will works.

KZCPER - constant from T511K which is 100.

Place your pcr in schema after /111 is populated.

Regards,

Dora

[Former Member]

Hi Dora,

Thank you for your help.

Now my PCR working perfectly,

Thank you once again

[Former Member]

Hi Reddy,

Welcome and good to know that pcr is working, please close the thread if your issue is solved.

Regards,

Dora

[Former Member]

Dear Reddy,

Please write the pcr as below and insert the pcr after the function pa0014 in your schema.

*

****

WGTYP?     Query wage type

****

Addwt *

1234 your wage type

Amt=     /101

amt/ 100

num= 1234

multi   ANA

addwt *

Regards,

Dora

[Former Member]

Hi Dora,

I have written in the below.

*

  ****

    WGTYP?  Query Wage type

    *****

     ADDWT 1234 OT Out put table

    AMT=/101 set

    AMT/100  Division

    NUM=1234

   MULTI ANA  Multi pl.Amt/no/rate

  ADDWT 1234 OT Output table

But amount is not reflecting in RT table .I can able to see only enumber which I have maintained in IT0014.

Please advise.

[Former Member]

Dear Reddy,

Please find the corrections below to your pcr.

*

  ****

    WGTYP?  Query Wage type

    *****

addwt *  (Insert new hear)

1234

     ADDWT 1234 OT Out put table (remove this)

    AMT=/101 set

    AMT/100  Division

    NUM=1234

   MULTI ANA  Multi pl.Amt/no/rate

  ADDWT 1234 OT Output table

please modify as above and let me know.

Regards,

Dora

[Former Member]

Hi Reddy

If Percentage 10% standard check the attachment PCR will helps to you.

[Former Member]

Hi Vara Prasad,

10% is not standard..it will depends input given in IT0014.

Please help me.

Regards,

Reddy.