Hello, I'm trying to write a sql query which shows payroll distributions including employee, department, job title, payroll code, amount and G/L account.
I started linking the UPR30300 and UPR40500 tables for gross paycodes but it does not appear all transactions are necessarily stored on the UPR30300 table.
Thanks.