Tuesday, 27 January 2015

Reconcile Dynamics GP Canadian Payroll :
T4 Summary doesn't equal to the receiver general report:
I have seen that at a client site and basically the main issue here is that there are a couple of employees have the TD1 option window under employee cards T4 marked as no printed.
So do the following query on the SQL to check which employee have this option unmarked.
On the CPY10100 and CPY50100
Tables that are updated in YE Tax updates
  • CPY10103 P_CPY_Employee_T4_MSTR
  • CPY50103 P_CPY_Employee_T4_MSTR_LY
  • CPY30250 P_CPY_Calc_MSTR
  • CPY30150 P_CPY_Calc_WORK
  • CPY50250 P_CPY_Calc_MSTR_LY
  • CPY30151 P_CPY_Employee_T4_WORK
  • CPY40105 P_CPY_R1
  • CPY70105 P_CPY_R1_LY
  • CPY40115 P_CPY_SETP_R1_Summary
  • CPY70115 P_CPY_SETP_R1_Summary_LY
  • CPY10100 P_CPY_MSTR
  • CPY50100 P_CPY_MSTR_LY

No comments:

Post a Comment