Cumulation issue for weekly payroll

[Former Member]

Dear Experts,

We have weekly payroll in place for casual employees and we are using international payroll driver for the country Kenya. Now issue is after configuring cumulation process for weekly payroll in table T54C1, T54C2, T54C3, T56C1,T56C2 and T56C3, cumulation is happening for my weekly wage wagetype in CRT table but all other system generated payroll wagetypes are missing in RT table i.e. /101, /110. /550, /551, /552, /553, /559, /560. Not sure the issue behind this and how to correct it.

We needed this cumulation functionality to calculate one statutory deduction based on WTD (week till date) figure.

Can anyone please help me to resolve it urgently

Regards

Tandrima

[former_member193652 · Accepted solution]

Hi tandarima,

Un payroll derive and follow the output log to see where you are loosing RT's wage types. Put following statement end of each sub-schema to check RT. If you find the location you can put the same statement into each rule of sub-schema to control inside PCRs.

PRINT       NP          RT

Regards,

Omid

[Former Member · Accepted solution]

Omid, thanks for the inputs, but it seems its loosing /101 in very beginning of the log, i was trying to find out the processing of /101, but its seems to be processed even before XINO somewhere through COM function in international payroll schema.

So i dont know how to correct it, please help

Regards

Tandrima

[former_member193652 · Accepted solution]

Hi Tandrima,

Why you are looking for /101 at start of schema?

What is the scenario you are running? Are you running retro act. accounting?

Regards,

Omid

[Former Member · Accepted solution]

Nothing like that, i was just comparing regular monthly payroll with weekly payroll of casuals, there i found /101 has been processed in very beginning of the payroll log, whereas its missing in weekly payroll.

Regards

Tandrima

[former_member193652 · Accepted solution]

Hi Tandrim,

In regular payroll run I think the first place you will see /101 is following line

PIT   X023 P20  NOAB        Gross input and storage

at XAL9 sub-schema of X000.

If you see /101 is early section it come from previous payroll period.

Regards,

Omid

[Former Member · Accepted solution]

Ok Omid, i was just studying as per your suggestion and found out that in Gross input and storage sub-schema for my weekly payroll log second IT table where /101 triggers for regular monthly payroll showing empty, can you tell me what may be the reason for it.

[former_member193652 · Accepted solution]

Hi Tandarim,

If the OT is empty try this. Go into V_512W_O and for WTs you would accumulate into /101 set a value in processing class 20. For example put 3 to see what will happen. By this you will have /101 in RT.

Regards,
Omid

[former_member193210 · Accepted solution]

Run t-code PC00_M99_DLGA20 to find out what WTs get transfered into the cumulators (WTs /101 to /199).  Just write in your Country Code, don't specify any WTs, keep today's date for the validity period, and select edition in either Table or Tree Structure.

This report can be used to see what parameters WTs have for a specific Processing Class, or what WTs will cumulate into a specific Cumulator (01 ro 99).

[Former Member · Accepted solution]

Omid, as you can see below, its already there, still i am not getting desired results

Regards

Tandrima

[Former Member · Accepted solution]

Remi, Thanks i checked, but in /101 is not reflecting in cumulation for weekly wage 1900 as i said before in gross input storage sub-schema XAL9, second input table is not fetching /101 only.

Can u help please me to resolve the same ASAP.

Regards

Tandrima

[former_member193210 · Accepted solution]

Your settings for Processing Classes 03, 20 and 41 all say "Write to RT", and that should not be the case; only one of them should.

Compare the values of these PrCl for WT 1900 with those for other similar WTs.

Some WTs should be transfered to RT after Time Data Processing (sub-schema ZT00), while other should be transfered after Gross Processing (sub-schema ZAL0) or after Deductions Processing (sub-schema ZDD0).  Note that the sub-schema code could vary depending on your Country Code and your configuration.

P.S. Try modifying WT 1900 so that PrCl 03 = 0, PrCl 20 = 1 and PrCl 41 = 3       or so that PrCl 03 = 0, PrCl 20 = 3 and PrCl 41 = blank

[former_member193210 · Accepted solution]

I've looked at sub-schema ZAL9 (for International Payroll), and at PCR X023 (the one that processes WTs according to Processing Class 20.

If you do a Payroll Simulation for one employee, with the "Display log" box checked, and drill down into the log until you find PCR X023, double click on it to confirm that WT 1900 exists at that point.

If it does not, it's probably because it was transfered to RT after the end of the "Time Processing" sub-schema, where there is a PCR processing according to Pr.Cl. 03.  If that what happens, change the value of Pr.Cl. 03 of WT 1900 to the value 0.

[Former Member · Accepted solution]

Great Inputs Remi, i was almost losing my hope after failing to resolve the issue even after trying so many options, but finally your suggestion resolved the issue in the anticipated way..

Thanks a lot

Regards

Tandrima

[former_member193210]

Not sure what it would be for International Payroll Schema, but in Canada, Processing Class 03, 04, 20 and 41 define if the WT will be transfered into RT.

You should also be able to identify the transfer points in your Payroll Schema by the second parameter of the function (Par2) where it has values P03, P04, P20 and P41.

[Former Member]

Thanks for the reply Remi, can you please elaborate more on it, like i already maintained p.class 03 as 2, 20 as 3, 41 as 3 for my weekly pay wagetype, still i am getting the above issue, actually cumulation is happening properly it seems in CRT, but all payroll wagteypes starting from /101 to /560 is missing in RT.

Can you please help me to find from which sub-schema or PCR, these wagetypes are processed in payroll and why its being missing here.

Regards

Tandrima

[former_member193210]

Use program RPDASC00 to expand your Payroll Schema, with all it's sub-schemas.

In the result, search for parameters P03, P04, P20 and P41.  You should find at least 2 occurrences of each, once in the Off-Cycle Sub-Schema and once in the "regular pay" sub-schemas.

Note that there are many threads on that transaction (accessible through t-code se38),

as there are many on how to execute a Payroll Simulation with the "Display log" box checked to drill down into the log.

[former_member22386]

Hi,

In which schema you intend to calculate this new deduction wage type.?

To add any wage type to RT use ADDWT * operation

Regards,

Jignya

[former_member22386]

To add into what I said earlier if you maintain processing class 20 with specifation to make sure it is gets added into RT