Need to set up a numbering system to track your records? Define and add a unique identifier field to any SuiteCRM record. Option rich so that you can define the alphanumeric format that you need. Start tracking your Quote, Cases, Accounts and any other module today.
#3565 - Sequence doesn't work
I have set a sequence for the opportunity name, but the system when I try to create a new opportunity proposes me a different number of the sequence. I have tried to click on "initial fill", but the sequence does not change and remains the same.
My idea is to create a sequence that starts in this way: OP-00001
the system in the field "next sequence draw" proposes me this:
while when I try to create a new opportunity it proposes me this:
I also tried to uninstall and install the plug-in, but the system always proposes me the same sequence How can I reset the sequence to start from 1?
In addition, is it possible to have a complete User guide?
Piero Groppuso
3 years ago
Hello, can you attach a screenshot from the whole sequence setup (detail view)? I will rebuild it and let you know, if I face the same issue.
Just in case: Had the field "name" been used by you before? There might be a conflict for existing data. Initial fill does not overwrite existing data due to security reasons. In that case I could extend the plug-in and provide an "initial fill force" checkbox, which would empty all previous values and rebuild the starting sequence.
3 years ago
Attached screenshots of the sequence in detail.
The "opportunity name" field was managed manually before, so it contains old data.
Can the extension of the plug-in "initial fill force" create problems between the relationships with the various entities and problems with the DB?
If possible I would like to extend "initial fill force" also to the previous records in order to have a unique sequence. Will this extension remain also later?
3 years ago
Then the old data will create that conflict, since the sequence always checks for the maximum value inside that column. There wont be issues with relationships, but think about, if you use the field "name". At relationship fields you will see in future your opportunities sequences instead of your old name values.
That extension will remain for sure for later. If you want to use it at other sequences as well, feel free. But be aware of changing all your existing data in that column!
3 years ago
OK perfect. How long will it be available and where can I download the extension?
3 years ago
Just finished it. Is already uploaded. Can you download version 1.5.0 ?
3 years ago
I can't find the file to download. Does it still need to be uploaded to the purchase section?
3 years ago
please provide me your e-mail. it is right now not possible to upload the package. they have changed the settings...