Case numbers and Case types

[roymorock]

Hello,

My name is Roy Morock and this is my first post. I hope someone can help me.

I am using:
Sugar CRM Community Edition
Version 6.0.3 (Build 4339)

• CASE NUMBERS

I would like to know, is there away to make the case number a little bit larger? For example right now the case numbers are two didges (66). Is there away to make them maybe 3 didgets? Example 885. Or is there away to make it a RANDOM four to five diget number?

• CASE TYPES

At this time the only case types that I have is:

1. Administrative
2. User
3. Product

Those Case Types came when I installed the software on my server. Is there away that I can add my own types or some how modify what is there?

Please let me know.

Thank you in advance!
Happy New Year!

[Angel]

The case number is an auto-incremented column. To modify it, change its definition on the backend by executing the following SQL command against your SugarCRM database:

ALTER TABLE cases AUTO_INCREMENT = 885;

That would change the starting sequence to 885.

To change the values in the drop down, within Sugar click Admin > Dropdown Editor and modify case_type_dom.

[roymorock]

This issue has been RESOLVED. Thanks for the reply, Angel!

The case number is an auto-incremented column. To modify it, change its definition on the backend by executing the following SQL command against your SugarCRM database:

ALTER TABLE cases AUTO_INCREMENT = 885;

That would change the starting sequence to 885.

To change the values in the drop down, within Sugar click Admin > Dropdown Editor and modify case_type_dom.