Report on taxes by PDBA code for each employee (Canadian)


Well Known Member
Hi all,

I have been asked to produce a report that shows the Employee number, YTD by Pay Code, Federal Tax Paid for each pay code, CPP, EI

1) Is this even possible?
2) any thoughts on how to retrieve the data

I have been trying to combine F07186 (Stub Information History Table) and F06156 (Pay Check History summary)

I am trying to create a SQL query but sadly it is making my brain hurt so early in the morning

Any help would be greatly appreciated.