How to Change the Starting Number for Produmex Documents

By default, all Produmex internal document numbers start at 1. It is possible to change the starting number with a command, but the method is different for MSSQL and HANA.

In the example we change the starting number of the pick list waves for 1000001 therefore the table name is PMX_WAVE and the new starting number value is 1000000.

For MSSQL databases in the SQL management studio select the database and open a new window.
Adjust the following query by replacing the table name and the starting number value, then execute the query.

Note: Run the query for the header tables only.

DBCC CHECKIDENT(’dbo.tablename’, RESEED, newSequence)

Example: DBCC CHECKIDENT('dbo.PMX_WAVE', RESEED, 1000000)

For SAP HANA databases in the SAP Hana studio select the catalog and open a new console.
Adjust the following query by replacing the table name and the starting number value then run the query. 

Note: Run the query for the header tables only.

ALTER SEQUENCE tablename_S RESTART WITH newSequence

Example: ALTER SEQUENCE PMX_WAVE_S RESTART WITH 1000000

Internal document types and the corresponding header tables