Hi @jbernardo ,
This is possible. It is actually just a SQL sequence.
Normally I use beneath query to reset the sequence. But you can also set the sequence to a specific value.
ALTER SEQUENCE [dbo].[SEQ_CONTSEQ] RESTART WITH 1 MINVALUE 1;
You can find all sequence counters by entering below query.
SELECT * FROM sys.sequences
You can use the first query to update the sequence. The first number in the query should be the value where you would like to start counting from. Try this in your TEST environment first.
The downside of FSM working with SQL sequences is that whenever you try to create a record, but not save the record, then the counter is still adding 1 to the current_value of the sequence. This might happen when your integration ran into errors in the past, or whenever just users tried to create contacts manually. If this happens, your FSM system is running out of sync with NAV. This means that the way you synced is pretty fragile. I would actually advice to use a user_def field for this sequence and then just let NAV being in the lead of whatever value is put in there, if that is possible anyway.
