Reset tax amount on Pay Run

Modified on Wed, 24 May, 2023 at 1:36 PM

This works well for new customers starting after Jan 1 of a taxation year.

TO prevent the system from taking into account YTD totals for taxes, this script can be run on the YTD records to reset taxes.

update ec_employee_ytd_entity
set entity_code = 'MANUAL', coverage_code= 'MANUAL'
where employee_id in ( '28643' )
and year = 2023
and entity_type in ('REG_TAX_GROSS',
'OTHER_TAX_GROSS',
'TAX',
'PAY_COUNT',
'OTHER_TAX',
'EXTRA_TAX',
'TAX_ADJ')
and entity_code is null;