How do I troubleshoot discrepancies in CTX910AU.SQR?
Our Payroll group has discovered that the values reported on CTX910AU (specifically for boxes 16, 18, and 22) does not match data being pulled via various queries that look at PS_TAX_CAN and PS_CAN_TAX_BALANCE for equivalent criteria.
We are currently using the version of the SQR that was delivered in Tax Update 18-E (December 2018). We have not yet applied the file delivered in Tax Update 20-E.
We are struggling to troubleshoot the issue and account for the discrepancies. Anyone have any ideas on where to begin?