Changing Auto-increment Start

[spencermitchell]

Hello,

We are transitioning from Quickbooks to SugarCRM and would like to have our quote numbers begin from where they left off in Quickbooks. By default they start at 1. I have attempted to use this as a reference to update the module, but since we run a newer version I know that its a little different. Any suggestions?

Thanks,

Spencer
Sugar Enterprise Edition
Version 5.2.0i
PHP 5.2.8
MySQL 5.1
Windows 2003

[spencermitchell]

Just checking back to see if anyone had access to an updated version of the link above. Thanks

[mikesolomon]

I would try just doing this bit

Run the following command from the database (the example is if you want your quotes to begin with 1000.

ALTER TABLE quotes
AUTO_INCREMENT=1000;

[spencermitchell]

I tried that, but I was under the impression that I would have to change some things in the file directories as well. As far as I can tell, nothing has happened on the CRM side. Any suggestions?

[spencermitchell]

Nevermind. I got it. Thanks.