Reset tax amount on Pay Run

Modified on Wed, 24 May, 2023 at 1:34 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;

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article