Software (include version): Ancora, DocStar IDC, Epicor IDC    

Use Case: Needed to set the batches that fall between this date range to deleted. The following can be modified to set the batch state to 9 (deleted)

Customer: N/A

Prerequisites: Determine date range by using Admin / batches


  1. Run the following SQL statement to update the batches in the defined date range (dates listed below are examples, please adjust to your desired range

    1. UPDATE [docstarIdcServerDb].[dbo].[Batch] set state = 9 where createdon BETWEEN cast('01/01/2021' as datetime) AND cast ('04/20/2021' as datetime)

Helpful Links: