Skip to Content
0

PCR to replace technical wage type /s01 amount with WT maintained in IT0014

Dec 22, 2016 at 08:42 AM

288

avatar image

Dear Expert,

How can I change amount of /s01 technical WT from RT table with the amount of Supplemental Wage type maintained in IT0014 using a PCR.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Rabi R Dec 22, 2016 at 09:04 AM
0

Hi,

Which country payroll you are using?

Thanks

Show 4 Share
10 |10000 characters needed characters left characters exceeded

It is for USA Payroll

0
Mohammed Ziaulah Hashimi Rehan

Hi,

Write a PCR in subschema UAP0 under Function P0014

*

****

WGTYP?

****

ADDWT *

XXXX (Wage type of IT14)

OPIND

ELIMI A

ADDWT /S01

Use function PIT GEN

Thanks

0

Hi Rabi,

Thanks for your response..

I tried using above PCR

but it is stopping XCM0 PCR

/s01 is coming from BSI post tax calculation... so how can I change value of if?

Regards,

Rehan

ptu67.png (9.3 kB)
09jjk.png (7.1 kB)
0
Mohammed Ziaulah Hashimi Rehan

Hi,

Please copy same PCR in ESG 3 just like * . Because XCM0 not getting any value for ESG grouping 3.

Thanks

0
Rémi Corriveau Dec 22, 2016 at 01:00 PM
0

I'm not familiar with Payroll for USA, but at what point in your Payroll Schema does the value of WT /S01 become final before being transfered from the Input Table (IT) to the Results Table (RT)?

My suggestion would be to process the Information WT from IT0014 through Function P0014 so that it would end up in the IT and also in the Temporary Variables Table (VAR), using Operation ADDWT&XXXX. Then, at the point in your schema before WT /S01 is transfered to RT, add a pcr to process WT /S01 and use Operation AMT=& XXXX to replace the Amount of WT /S01 with the Amount from the Temporary Variable XXXX.

Share
10 |10000 characters needed characters left characters exceeded
Rémi Corriveau Dec 22, 2016 at 05:49 PM
0

What Function are you using to call pcr ZS01, and what have you used in Par2 and Par3 ?

In my system, pcr XCM0 for ESG * and WT **** will first query the WT's value for Processing Class 31, and if the return value is other than 0 it will give an ERROR.

Should WT /S01 be associated to ESG * or to a specific ESG? Check the ESG of WT /S01 in your Production environment.

In pcr ZS01, you are processing WT 2MEL to create WT /S01. What is the ESG of WT 2MEL?


xcm0.png (19.9 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

I am using PIT ZS01(Custom Rule) in Par2 and GEN.

As suggested by Rabi I will try to copy same PCR for ESG Grping 3 and share the results

ESG for WT 2 MEL is "1"

0

ESG for /S01 is 1 ... /s01 is automatically gets created after tax calculation from BSI.. the amount which is coming in /S01 is not matching with business requirement. they want total gross instead of taxable earning if there is only supplemental payments to an employee.. ESG for WT 2MEL is "1"

0
Rémi Corriveau Dec 23, 2016 at 01:23 PM
0

In your PRoDuction environment, if WT /S01 is created with ESG 1, it should follow the ESG 1 WT **** path in pcr XCM0. Please confirm that.

In your DEVelopment environment, if WT 2MEL also has ESG 1 when it is being processed by pcr ZS01, then the ESG split for WT /S01 that is created should also have ESG 1 since you eliminated split A (WPBP Split) but not split R (ESG Split). In your Payroll Log, please confirm that this is the case since from your error message, it seems that WT /S01 has ESG 3.

Look at pcr XCM0 for ESG 3 to see what values for Processing Class 31 are processed without error, and compare them to what happens to a WT with ESG 1. In my system, only value 0 is allowed if the WT has ESG 1, and only values 0, 1, 2 and 3 are allowed if the WT has ESG 1, 2 or 3.

Double check the value for PrCl 31 of WT /S01 and correct if required. Otherwise, copy XCM0 into ZCM0 and make the appropriate changes to process the PrCl 31 value of WT /S01 in ESG 3.


xcm0.png (19.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
Sikindar T
Dec 27, 2016 at 07:45 AM
0

You should not leave PRCL 31 for wage type 2MEL as blank it should have some value based on your Business Requirement.

Share
10 |10000 characters needed characters left characters exceeded
Mohammed Ziaulah Hashimi Rehan Dec 27, 2016 at 02:40 PM
0

First of all I would like to thank Rabi, Rémi Corriveau and Sikindar T all for your responses..

Please see below screenshots for little more details.

Below is screenshot is from RT Table when post US -Tax Calculation from BSI. In this we can see * /s01 is having only 34.85$ and WTs 2MEL and 2TPI are supplemental wages, Hence the amount in * /s01 should be Accumulation of Supplemental wage types .i.e., it should be 70$

I have written below PCR

With the above PCR I can achieve below result but with some issues.

Issue #1 : * /S01 is still having value 34.85$ instead of 70$ (2mel and 2tpi)

Issue #2: 3 /s01 got created with correct value 70$

Now my concern is I have to have 70$ amount displayed in * /S01 instead of creating it in 3 /s01. What changes do I need to make in my PCR to achieve above solution?


bwwuk.png (19.9 kB)
ghh3k.png (18.7 kB)
qqqul.png (17.7 kB)
oleuo.png (17.5 kB)
Share
10 |10000 characters needed characters left characters exceeded
Rabi R Dec 28, 2016 at 06:17 AM
0

Hi,

You are using PRT function which can not delete entry in table RT or not replace by OT. Therefore, within function PRT, do not write anything to the table OT (for example, with ADDWT*). Furthermore, we recommend that you do not change table RT (for example, with ADDWTE*) within the function PRT. It is better if you perform the calculations before the wage type is place in the table RT.

You should use any other function Eg. ACTIO

Thanks

Share
10 |10000 characters needed characters left characters exceeded