• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

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

pbare

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.
 
Top