Create Account ID

[brianwg07sugar]

Hi,

For each customer, we need to create a customer Number (account ID), such as CT00025 as a customer reference ID.

Although the system currently generates system ID for each account, for example, c98ed20-32a7-4573-5f26-493bc653f4da, this is not suitable for business purposes, to allow customers to quote their own customer reference number.

also, in the Quotes in the Professional edition, is there any way, we can make the system generate quote number in a patter like INV000220 rather than some simple number like 1, or 2?

Thank you

Brian

[ciph3r]

Brian, the 32-bit number you quoted is a Sugar ID number. It's used for all unique id's, as well as the ID's for all relationships. What I would recommend is that you modify the system so that you generate & store your own account number in the accounts_cstm table and use this to reference the accounts. We do something similar, yielding a number like C12381-000 for an account automatically on save.

If you still wish to have a look at the code that generates the encoded ID's, you can find it in include/utils.php create_guid();

[gibby]

Hey - so this thread is of interest to me also....
I'm happy for the system to generate a record ID, but it must be intelligable to use as a matchkey across systems.

IS there an easy way for the product (using enterprise) to generate a unique ID that is interpreted as something a little more pallatable?

Iam a bit of a novice, so how can I access include/utils.php create_guid()

Appreciate any advise...

[andopes]

Hi,

For each customer, we need to create a customer Number (account ID), such as CT00025 as a customer reference ID.

Although the system currently generates system ID for each account, for example, c98ed20-32a7-4573-5f26-493bc653f4da, this is not suitable for business purposes, to allow customers to quote their own customer reference number.

also, in the Quotes in the Professional edition, is there any way, we can make the system generate quote number in a patter like INV000220 rather than some simple number like 1, or 2?

Thank you

Brian

Hi Brian

Take a look at this thread: http://www.sugarcrm.com/forums/showt...ght=autonumber

[brianwg07sugar]

Thank you very much for your reply. This is very helpful.

regards

Brian