cancel
Showing results for 
Search instead for 
Did you mean: 

Maintain Recovery of Arrears with Balances and Totals

Former Member
0 Kudos

Hi Gurus,

I have two wage type WTAAAA and WTBBBB

In IMG Maintain Recovery of Arrears with Balances and Totals

WTAAAA is maked as deduction wage type IT0014 gave as £ 50

WTBBBB is marked as balance wage type £IT0015 gave as £ 1800

but when I run payroll the balance WTBBBB remains same £ 1800 and not showing as £ 1750

what may be the cause

Accepted Solutions (0)

Answers (1)

Answers (1)

sikindar_a
Active Contributor
0 Kudos

Elobarate

with some more information

Edited by: Sikindar on Oct 1, 2009 11:03 AM

Former Member
0 Kudos

I am working for GP Payroll.

For share save they want to create two wage types one for deduction and other for reducing the balance

for example

Employee opts for share save scheme for £ 50 for 36 months (3 years)

then his pay will be deducted by £ 50 for 36 months thru IT0014 WTAAAA

and simultaneously in RT the value of WTBBBB which is 36 months of WTAAAA will be reduced

for first month = deduction WTAAAA £50 WTBBBB £3750

for 2nd month = deduction WTAAAA £50 WTBBBB £3700

likewise for 36 months it will happen and the WTBBBB will become zero

This was done by thru IMG

Payroll: Great Britain -->Deductions -->Priorities and Arrears -->Maintain Recovery of Arrears with Balances and Totals

I have linked WTAAAA ie deduction wage type to WTBBBB ie balance wage type

after running payroll in RT the value of WTAAAA is showing correct £ 50 but WTBBBB is not showing £ 3750 but £3800

sikindar_a
Active Contributor
0 Kudos

Seems

in infotype 14 your passing deduction amount that is 50

and in the IT15 you want the balance right ????

say

you are haveing a additional Wage type in IT 0015 for 100 Rs

and when ever if u give the deduction with 50 Rs the balance wage type shd show 50 Rs in IT0015 Right

Former Member
0 Kudos

No sikandar,

the IT value will remain same as it is original

only thing is the RT should affect, as IT0015 WT is not processed its just to show the baalnce value in RT

IT0015 value for WT remain same

but RT value for WT will diminish

I am trying to write a PCR for that but finding dificult to deduct the value

I have set PC93 for WTAAAA to 1

ZZS1 Personnel Calculation Rule ZZS1

" *

" ****

" VWTCL 93 Processing class

" 1

AMT=4302 Set

AMT- 5302 Subtraction

ADDWTE5302 RT Results table

" *

ADDWT * OT Output table

sikindar_a
Active Contributor
0 Kudos

so , you want to the caluculation Should happen at Process level in RT right

it means

AMT=4302 Set this is the wage type in IT0015

AMT- 5302 Subtraction this is the wage tyoe in IT0014

ADDWTE5302 RT Results table and the result will be form after subraction right

Please confirm

Former Member
0 Kudos

Yes process in RT

4032 is IT0014 WT

5032 is IT0015 WT

I want to call WT 4032

and then deduct WT4032 from WT5032

and store the amount to RT of 5032

sikindar_a
Active Contributor
0 Kudos

have used the opration SUBWT

before going to that read the Opertiaon SUBWT in PE04 and use that one in ur PCR

4032

SUBWT5032

Addwt5032

Former Member
0 Kudos

I did as below

ZZS1 Personnel Calculation Rule ZZS1

" *

" ****

" VWTCL 93 Processing class

" *

ADDWT * OT Output table

" 4302 Sharesave 2009B 3YR

" VWTCL 93 Processing class

" 1

AMT= 4032 Set

SUBWT 5032 OT Output table

ADDWT 5032 OT Output table

but dint get result in RT

I changed last line to

ADDWTE5032 RT Result Table

but still invain

sikindar_a
Active Contributor
0 Kudos

Where you have kept the PCR in your Schema chan you let us know that one

it should be processed in INAP

Former Member
0 Kudos

in line 200 below custom PCR ZZS1 is inserted

in UK Payroll

Schema G000 - sub schema GBD0 -

000010 COM ************************************

000020 COM Basic data required for Great Britai

000030 COM ************************************

000040 BLOCK BEG Processing of basic data

000050 PITAB D AIT Refresh Alternative IT

000060 ENAME Determine Employee name (Infotyp 000

000070 WPBP Read Work place Basic pay

000080 GBIT8 Summarize pay wt of infotype 8

000090 P0071 Read Pension infotype

000100 P0065 Read Tax infotype

000110 P0070 Read Court Orders infotype

000120 IF J02 Tax year 2002 or later

000130 ELSE

000140 P0222 Read Company Cars (mileage based)

000150 ENDIF

000160 GON * Continue if data complete

000170 PRINT NP NAM Print Name

000180 PRINT NP BBEN * Basic benefits print needed here

000190 P0014 GW14 GEN NOAB PCRL47 processing

000200 P0014 ZZS1 NOAB REDUCE BALANCE 5302

000210 BLOCK END Processing of basic data

sikindar_a
Active Contributor
0 Kudos

000010 COM ************************************

000020 COM Basic data required for Great Britai

000030 COM ************************************

000040 BLOCK BEG Processing of basic data

000050 PITAB D AIT Refresh Alternative IT

000060 ENAME Determine Employee name (Infotyp 000

000070 WPBP Read Work place Basic pay

000080 GBIT8 Summarize pay wt of infotype 8

000090 P0071 Read Pension infotype

000100 P0065 Read Tax infotype

000110 P0070 Read Court Orders infotype

000120 IF J02 Tax year 2002 or later

000130 ELSE

000140 P0222 Read Company Cars (mileage based)

000150 ENDIF

000160 GON * Continue if data complete

000170 PRINT NP NAM Print Name

000180 PRINT NP BBEN * Basic benefits print needed here

000190 P0014 GW14 GEN NOAB PCRL47 processing

000200 PIT ZZS1 NOAB REDUCE BALANCE 5302 Try this

000210 BLOCK END Processing of basic data

Former Member
0 Kudos

schema changed in line 200 as said and

tried combinations of PCRs as below and RT no effect

ZZS1 Personnel Calculation Rule ZZS1

(1)

AMT= 4302 Set

AMT- 5302 Subtraction

ADDWTE5302 RT Results table

(2)

ADDWTI *

AMT- 5302

ADDWTE5302

(3)

SUBWT 5302

ADDWTE5302

Due to a minor mistake I am still facing the problem

couldnt

sikindar_a
Active Contributor
0 Kudos

see

you have given a deduction wage in IT0014 Right

that is 4302 ..........50 RS

and you have another wage type in IT0015

that is 5302 ...........100 RS

while pay roll get processed the Amount in 4302 should get deducted and processed in 5302 right

*

5032

Amt = 4302

SUBWTD 5032

ADDWTE 5032

Try this and let us know

Former Member
0 Kudos

sikandar,

as said changed

ZZS1 Personnel Calculation Rule ZZS1

" *

" ****

" VWTCL 93 Processing class

" *

ADDWT * OT Output table

" 5302 SSave 2009B Initial Bal

" VWTCL 93 Processing class

" 0

ADDWT OT Output table

" 1

AMT= 4302 Set

SUBWTD5302 DT Difference tab.

ADDWTE5302 RT Results table

mmm........ invain

sikindar_a
Active Contributor
0 Kudos

Why you are quering VWTCL that means Processing class 93

is there any specific reason

Former Member
0 Kudos

there are many wage types in IT0015

hence thought using 93 with value 1 assigned to this wage type

so that only this wage type get quering

Former Member
0 Kudos

thanks all for valuable comments

resolved by writing two rules for each wage type

as below

ZZS3 Personnel Calculation Rule ZZS1

" *

" ****

" VWTCL 93 Processing class

" *

ADDWT * OT Output table

" 4302 Sharesave 2009B 3YR

" VWTCL 93 Processing class

" 0

ADDWT OT Output table

" 1

ADDWT&YYYY VAR Variable table

ADDWT * OT Output table

" 5302 SSave 2009B Initial Bal

" VWTCL 93 Processing class

" 0

ADDWT OT Output table

" 1

AMT= 5302 Set

AMT-& YYYY Subtraction

ADDWTE RT Results table