Is it possible to disable the automatic order number sequencing from quotes? I would prefer they not show up when I write a quote.
You can hide the order number field if you do not want to see it.
If you really want to stop the auto-numbering, then you would need to edit the spORDERS_Update stored procedure and comment-out the logic.
Scratch that last request. Is there a way to just change the number? I'd like to make it higher than 14. Thank you.
Are you asking to make one order (assuming its your current order) a number higher then 14? or you want to have them all from now onward to be higher numbers?
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.
Copyright (c) 2006-2012 SplendidCRM Software, Inc. All Rights Reserved.