Incrementing Unit Sales Number

Hi WA,

I know I can change the starting sale # by accessing it via the Database admin.

is there a way to set the starting invoice number or at least the incrementing it?

Thanks, Mark.

I'm not sure what you're getting at with the invoice number. Do you mean the order number?

What is the purpose for increasing the invoice/order number for a certain sale?

Hi Jimmy,

Rather thanthe order number starting at 1, then 2 then 3 etc can you have the first order increment so that the first order is 1 then the second sale/order number 11 the third 21 and the fourth 31?

Mark.

The order id is an autoincremented field in the database, so it will increment the id automatically. You can set the autoincrement increment amount for the database like this:
replication-options-master.html#sysvar_auto_increment_increment

You would need to make the call:
SET @@auto_increment_increment=10;

This will change the auto_increment_increment for all tables though, so other tables that have auto_increment set on a column will also increment by 10.