Preventing a blank ER Tax ID from being populated across Payroll History files
Here is the situation:
All payroll history files are in error as several records have no Employer Tax ID, which is a show stopper for producing the year-end T4 and T4A process.
The client is processing a monthly Canadian Payroll cycle for retirees so that all benefits they are entitled to are automatically calculated on a monthly basis and therefore all data is ready for producing T4As for them at year end.
Here is the problem: The ER Tax ID populated in all payroll History files (F0618, F0719, F06145, F06146) by the payroll cycle is derived from the EI Rate code (U01-U09) created in the table F06017 for that retired employee when, from the Employee Master Program P0801 >