Cumulation of CRT wagetypes in one wagetype

[Tarun]

Hi Experts,

I have a requirement where i need to cumulate the 4wage types which i have in CRT table in one wagetype.

Eg: I have the below 4wagetypes in CRT table:

1. 1000 - Car Reimbursement

2. 2000 - Petrol Reimbursment

3. 3000 - Telephone Reimbursement

4. 4000 - Driver Salary Reimbursement

I want the total amount which is appearing in CRT table in one wage type. Is this possible? If yes, then how? Please help me.

regards

TS

[Former Member · Accepted solution]

Hi TS,

There could be two ways of doing this. I am assuming that the new wage type that you want the amount to be cumulated is 9000.

1) Before the ADDCU function call in your schema, include a new PCR that will add the amounts in the wage types that you have mentioned and create an entry in the RT table with the final amount.

2) After the ADDCU function call, the system updates the CRT table. You can include a custom PCR that will refer to the amounts in the CRT table against each of the wage types that you have mentioned using the AMT=C nnnn command and then once all the amounts are added up, use the ADDWTC9000 to include the total amount in CRT.

Hope this helps.

-Akshay

[Tarun · Accepted solution]

Hi Akshay,

Happy new year to you and your family.

Akshay, i have written few PCRs but i am not very much comfortable in this. i have understood what you have told but one thing which is not clear is where to insert this PCR. Can you please tell me the same in an exact way...like in which Schema and after which rule and all...then i will write the PCR as told by you and will try.

Regards

TS

[Former Member · Accepted solution]

Hi TS,

As mentioned earlier, for option 1, you will need to insert the PCR just before the ADDCU function call in your schema and for option 2, you will need to insert the PCR immediately after ADDCU function call.

The function ADDCU is normally in the End Processing of your schema.

Hope this helps.

-Akshay

[Tarun · Accepted solution]

Hi Akshay,

Thanks for the reply, Which means the custom PCR is to be inserted in the INE0 (Final Processing) schema.

Akshay, sorry to say but till now whatever PCRs i have written are based on the values stored in the infotypes.

Just give some hints like how to refer values in CRT. you can also contact me at the below id.

tarun.saphr@gmail.com.

Please help.

regards

TS

[Former Member · Accepted solution]

Hi TS,

As mentioned in my first response, you can refer to the CRT figures using the operation AMT=C nnnn, where nnnn is the wage type that you want to refer to. Please refer to the dcoumentation on PE04 for the opearation AMT and you will find many examples to explain the functionality.

Also, to add the final amount back to CRT table, you can use operation ADDWTCnnnn, where nnnn is the wage type that holds the final amount. Again, refer to the documentation on PE04 for ADDWT to know more about the functionality.

-Akshay

[Tarun · Accepted solution]

Thanks Akshay. But when i am using the command ADDWTC9995, where 9995 is the final wage type, then system is showing the message...."No entry in T52BO for these parameters of the operation".

what could be the reasons? the problem is with the command ADDWTC i think.

regards

TS

[Tarun · Accepted solution]

Hi Akshay,

Secondly, the result wagetype which is 9995, i dont want to save this wage type in any infotype. I mean i want to backend processing. i dont want to enter this wagetype in any infotype. i just want the total of other wagetypes in this wagetype.

plz guide.

regards

TS

[Tarun · Accepted solution]

Hi,

Any furthur help on this please?

regards

TS

[Former Member · Accepted solution]

Hi TS,

Since you are using Indian Payroll, I think this operation is not supported. I would suggest using option 1 for your solution.

You need not save the final amount in any infotype. You can use the PCR to generate the final amount automatically during payroll in WT 9550.

You might try building the PCR as follows:

ZTEST

*

|---1000

|------ADDWT *

|------ADDWT 9500

|---2000

|------ADDWT *

|------ADDWT 9500

|---3000

|------ADDWT *

|------ADDWT 9500

|---4000

|------ADDWT *

|------ADDWT 9500

|---****

|------ADDWT *

[Tarun · Accepted solution]

Hi Akshay,

Thanks a lot once again.

Rule is working absolutely fine.

regards

TS

[Tarun · Accepted solution]

Hi Akshay,

This rule is working fine in regular payroll. But the wagetypes that i want to add are to be processed in off-cycle. But the same rule is not being processed in off-cycle. I am unable to understand the reason. The cumulated wage type which is in our case is 9500 is not being generated.

Any idea abt this problem?

regards

TS