Enterprise & Sell

Enterprise & Sell Answers & Best Practices changing format of unique opportunity id

Click here to join this group and curate your SugarClub experience.

changing format of unique opportunity id

Nikhil Kunnathully over 1 year ago

Is there a way to change the unique opportunity ID for all new opportunities moving forward? we wanted it to be numeric and short for our reporting.

Parents

0 Enrico Simonetti over 1 year ago
Hey Nikhil Kunnathully ,

While technically it is possible, I strongly advise against it.

The system is built to work with a 36 digits guids and changing that could create many unexpected behaviours. I've seen it done and nothing good comes of it.

If you need something for reporting, I would create a new field, and if it is suitable for you, create an auto increment field
--

Enrico Simonetti

Sugar veteran (from 2007)

www.naonis.tech

Feel free to reach out for consulting regarding:

API Integration and Automation Services

Sugar Architecture

Sugar Performance Optimisation

Sugar Consulting, Best Practices and Technical Training

AWS and Sugar Technical Help

CTO-as-a-service

Solutions-as-a-service

and more!

All active SugarCRM certifications

Actively working remotely with customers based in APAC and in the United States
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Reply

0 Enrico Simonetti over 1 year ago
Hey Nikhil Kunnathully ,

While technically it is possible, I strongly advise against it.

The system is built to work with a 36 digits guids and changing that could create many unexpected behaviours. I've seen it done and nothing good comes of it.

If you need something for reporting, I would create a new field, and if it is suitable for you, create an auto increment field
--

Enrico Simonetti

Sugar veteran (from 2007)

www.naonis.tech

Feel free to reach out for consulting regarding:

API Integration and Automation Services

Sugar Architecture

Sugar Performance Optimisation

Sugar Consulting, Best Practices and Technical Training

AWS and Sugar Technical Help

CTO-as-a-service

Solutions-as-a-service

and more!

All active SugarCRM certifications

Actively working remotely with customers based in APAC and in the United States
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Children

0 Michelle Plutto over 1 year ago in reply to Enrico Simonetti

would this work with importing from Oracle into Sugar meaning would this be an identifier we could count on?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel