Scenario: Looking for a way to easily update insurance tax state for a specific phase code across all jobs.
It is a good idea to test this in a test database before impacting your live database.
- Create a backup of your database.
- Create Stored Procedure, see link PRPhaseTaxUpdate.
- In Vista UD Module, add a Custom Button to the PRBTCHUP form with the following parameters settings, changing the @Phase, @state & @inscode default values to your desired settings.
- Move the Custom Button on PR Batch Update form
- Test the stored procedure in your test company/database before using it live.