Altering the Batch Instance Folder Naming Sequence
Applies to: All versions of Ephesoft Transact
The following steps describe how to edit the batch instance folder naming sequence. By default, new batch instances start with “BI1” and cycle numerically and alphabetically.
The steps for this article vary based on your selected database:
MySQL or MariaDB
Use the following query to set the naming value.
ALTER TABLE batch_instance AUTO_INCREMENT = 20481
Note: The batch instance identifier is in hexadecimal format, but the above query uses decimal format. As such you will need to enter the seed in decimal. In the example above, the seed is changed to 20481, which will set the next batch instance number to be BI5001 (5001 hexadecimal = 20481 decimal).
MSSQL
Use the following query to set the naming value.
Note: You must be the system administrator (sa) in Microsoft SQL Server Management Studio (SSMS) to run this query.
DBCC CHECKIDENT ("batch_instance", RESEED, 20481);
Note: The batch instance identifier is in hexadecimal format, but the above query uses decimal format. As such you will need to enter the seed in decimal. In the example above, the seed is changed to 20481, which will set the next batch instance number to be BI5001 (5001 hexadecimal = 20481 decimal).