Auto Generate Account Number?

[bdfoster89]

Setting up a SugarCRM instance for testing. I would like to implement an auto-generated account number. It needs to be unique, alpha-numeric, and be about 10 characters long. Is there any way I can easily do this without going through all sorts of trouble? I see that SugarCRM has a unique ID but it's too long for my tastes to use as a reference to an account. Using 6.0.1 CE.

Thank you for your time,
Brian Foster
Endigo Computer LLC

[cbglobal]

Hi Brian,

to solve this problem I would insert via Studio a new field, e.g. unique_id, into the Detail View of the Accounts module.
Then I would implement a logic hook (before_save) with a new function which generates the desired unique ID.

Best Regards,
Chris

[andopes]

Setting up a SugarCRM instance for testing. I would like to implement an auto-generated account number. It needs to be unique, alpha-numeric, and be about 10 characters long. Is there any way I can easily do this without going through all sorts of trouble? I see that SugarCRM has a unique ID but it's too long for my tastes to use as a reference to an account. Using 6.0.1 CE.

Thank you for your time,
Brian Foster
Endigo Computer LLC

Hi Brian

I hope this thread helps you.

Cheers

[LX Dog]

Hi Brian,

The thread that Andopes pointed to is very useful and helped me to achieve a solution that works well for me and seems similar to your needs. It's based on standard sugar fields rather than custom fields.

Take a look at this thread : http://www.sugarcrm.com/forums/showthread.php?t=68971

Hope this helps a bit. Please bear in mind I am no sugar or php expert.

All the best,

LX Dog.