how do I set the quote number to start at say 3000 ?

[rtetlow]

when I enter a quote (or case or anything) the sequence starts at 1. I also need to import quotes and cases from another system that have already a pre-defined number. But in each case its <3000. So ideally I want to be able to import these and set the number fields so that I can still maintain an audit between our old and new system. I also need to start the sequences from 3000.

wondering how to do that - since I cannot find it in the UI and when I try to import - it seems to use its own sequence.

I am running the on-demand version 5.1.0 - sugar prof. thanks in advance.

[andopes]

Hi rtetlow


I searched in the sugarcrm code and it seems there is no way to set an auto_increment default value other than 1, but you can do this directly in database table:

For MySQL: ALTER TABLE tbl AUTO_INCREMENT = 100;
I just filed a new bug requesting this feature.

Bug # 25332

Best regards

[rtetlow]

Hi rtetlow


I searched in the sugarcrm code and it seems there is no way to set an auto_increment default value other than 1, but you can do this directly in database table:

For MySQL: ALTER TABLE tbl AUTO_INCREMENT = 100;
I just filed a new bug requesting this feature.

Bug # 25332

Best regards

thanks for your help here - but remember I do not have the community version. I have the on-demand version and there seems to be no way to access the tables - at least from what I can see. Specifically, I have sugarcrm professional (commercial on-demand) version.

[andopes]

thanks for your help here - but remember I do not have the community version. I have the on-demand version and there seems to be no way to access the tables - at least from what I can see. Specifically, I have sugarcrm professional (commercial on-demand) version.

Hi rtetlow

So I believe you can ask Sugar to set it for you.

cheers

[rtetlow]

Hi rtetlow

So I believe you can ask Sugar to set it for you.

cheers

good point - never thought of that. Im so used to being able to do it in the interface. But that only resolves one of the issues - it still doesnt resolve my data migration issue since I already have case numbers in my old system. The only workaround I can think is to import into a text field or something the old case number - but thats very messy IMO. Especially when I have to do it for customer numbers, lead numbers and a host of other things.

Thanks.