Forums

Is it possible to disable the automatic order number sequencing from quotes? I would prefer they not show up when I write a quote.

Scratch that last request. Is there a way to just change the number? I'd like to make it higher than 14. Thank you.

Without waiting for an answer to my last post;

First If you just really wanted to change the number of one order you can do so in the orders table. I would not recommend this.

If you want to make the number higher for all orders you have, say you would like to start at 1000 or 3332 you can do that in the database.

The way that the numbering works is by incrementing a number, so in the spORDERS_Update you pass it a null order number

which in turn calls the procedure : spNUMBER_SEQUENCES_Formatted

This Procedure reads in the current value for the item you are working with, in this case Order numbers. The table that it reads this from is : dbo.NUMBER_SEQUENCES.

This table is a little Dangerous to mess with as you can throw things in fits of you aren't careful. That said if you would like to increase all Order number numbers from here out you go to the Name Column and look for the value of 'ORDERS.ORDER_NUM and then look at that rows Current_value column. This column value is the value of your latest Order number which then gets incremented each time you create a new Order.

If you would like your numbers to start out higher simply change this value to the number you would like your next Order number to be minus 1.

For example If i wanted my next order number to be order number 3001 I would run this SQL statement:

update NUMBER_SEQUENCES set CURRENT_VALUE ='3000' where NAME='ORDERS.ORDER_NUM'

AGAIN Playing with these tables is not something I would suggest to ANYONE as a solution without thinking about problems could be exposed from do so.

Enjoy!