Jump to content
  • 0

client ID change


Hi guys

I am wondering is it possible to change the default numbering systems for client ID's as I am looking at moving from autotask to blesta for one of our businesses and we have a current client numbering in place.


We are using the following format XXX000001 etc onwards.


Is it possible even at a database level to change the numbering layout.

Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Yes and no.  You are looking for the "clients_format" setting which is set to {num} by default.  You would run a query something like

UPDATE `company_settings` SET `value` = 'some-prefix-{num}' WHERE `key` = 'clients_format';

This will do ALMOST what you want, however the prefix is not dynamic. So instead of having IDs like 0001, 0010, and 0100.  It would have to be 0001, 00010, and 000100.

A couple things to note.  First, this is only for the display ID, obviously not the internal ID.  Second, when searching for a client you can use partial IDs.  So a search for 0100 would match 0100 and 000100.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...