Skip to Content

Report need for retro time hours.

Oct 24, 2017 at 04:45 PM


avatar image

Need a report that provides:

1. What hours are coming through as retroactive and for what date.
2. The actual date and time the entries were pulled through. So we can determine what impact it has on the period being audited.

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

1 Answer

Rémi Corriveau Oct 24, 2017 at 07:46 PM

In our Payroll Schema (Canada), Function ZLIT is used to call a pcr that will generate an Information WT for certain WTs and mark them with a Date Stamp.

Example in processing

In the Payroll Results Cluster, the Results Table will have the Information WT with the D Split with a code, and in the

V0 Table will have the D Split and code linked to a Date.

This solution may not work for your Country.

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

Hi Remi,

Thank you for your quick response. However, I do not think that our system is configured the same was yours.

Below is a screen shot of the Remuneration Statement for PP1 2017

As you can see we have 8 retro hours that were paid at overtime and an additional shift premium OT rate was paid as well. This is what the V0 table looks like:



qock1.png (21.9 kB)
il43f.png (40.1 kB)

I expected your system to be configured differently than ours, even if you have Payroll for Canada.

The Remuneration Statement is only a Report that is based on the Employee's Payroll Results Cluster, mainly using tables RT and CRT.

You have to look at the source such as the Results Table (RT) to see the WT number and all the Splits each one has.

Furthermore, in our Payroll Schema, we added a pcr (ZCAT) that processes the Wage Types comming from Time Evaluation Table ZL (through Function ZLIT), and for some of them such as WT 9204, it creates Information WT 9104 with a Date Stamp (KST ZDATE KSETI D=ST). You do not have that pcr, and I'm not even sure that you could use Payroll Operations KST or KSETI in your Country. For the US, I'm aware that Operations UST and USETI exist, but I've never used them.