Skip to Content

YTD on Payslip

May 30, 2017 at 12:57 PM


avatar image
Former Member

Hi Gurus

I want to add YTD Amount for each wage type in both Earnings and Deductions.

Earnings and Deductions ( 3 Columns) should be shown like....

Sal Amount YTD Amount

Sal Amount YTD Amount

can any one suggest me how to do it?

I been trying by giving all wagetypes from CRT in window1 for Earnings and Window 2 for Deductions, also suggest me whether i did right or wrong?

but Amount and ytd amount showing same values. and let me know what config must be done?


capture2.png (18.5 kB)
capture3.png (28.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Rémi Corriveau May 31, 2017 at 05:10 PM

In your screen capture od a Window, we can see that the RT values and the CRT values will both use PTyp B2 and CTy. X.

Please look at the Line Layouts you have, and see if one of them is set-up to show the Amount in a different column than PTyp B2 and CTy. X.

In the following example, Column Type 03 is set-up to show the CRT to the left of the Rate/Number/Amount of the RT (CTy. 02), and the Retroactive Amount would appear on the far left through C.Ty.01

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Remi

It displays same values in both Earnings & Deductions YTD Amount columns as below.

it seems as YTD Deduction values coming from YTD Earnings Coloumn

I set PCL 30 Specification as '1' AMT & NUM may be cumulated in the current year and Cumulation as Monthly in table V_T54C3. still not coming right values.

also plz let me know what is the Period parameter should be maintained in Table V_T54C1, and what config should be done besides this?



Table V_T54C3



capture8.png (6.5 kB)
capture10.png (1.1 kB)
capture9.png (6.8 kB)
capture7.png (6.6 kB)
capture7.png (6.7 kB)
capture9.png (2.3 kB)
capture11.png (18.2 kB)
capture11.png (18.2 kB)
Rémi Corriveau Jun 01, 2017 at 04:56 PM

On the "Change Lane Layout" tab of your Remuneration Statement, for Line Type B2 and Column Type X, click on a BETRG field and activate the magnifying glass icon (F2) to see it's details, and then do the same for the second one. Are they identical?

I In order to debug your problem, I would suggest that you copy Type B2 and Column Type X twice, to create Type B2 and Column Type C (Current) and Type B2 and Column Type Y (YTD), each having field LGTXT but only one field BETRG in a distinc position ...

... and then in the "Change Window" tab, modify the Line Layout of some of your WTs so that the RT table uses Column Type C and that the CRT table uses Column Type Y.

And as for Identifyers INR and INR1, perhaps there is someone familiar with Payroll for India who could help you.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Remi

I set up with B2 C & B2 Y, still giving wrong values. Now I put it back as B2 X and run. The values in Amount & YTD Amount are same as below, I run payroll for one month to that EE. some of YTD values picking from Income window.

plz let me know any thing needs to change PCR/PCL?




capture17.png (8.8 kB)
capture18.png (8.2 kB)

Is it possible that you are using Evaluation Classes (from V_512W_D) to assign the WTs to the Remuneration Statement?

Seems like you have some problems with your Identifiers (ID). Please double check all WTs that they contain, and also check what WTs are in each Evaluation Class (using t-code PC00_M99_DLGA20).

In the first screen capture that you posted, you show part of the Structure of a Group from a Window. Have you tried to create 2 lines for a single SGr, the first one reading Table RT, ID **01 with Line Type B2 and Column Type C and a second line (same SGr) reading table CRT, ID **01 with Line Type B2 and Column Type Y ?