by CM & Sugar

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.

Includes a 30 day guarantee
Try it Now

#3565 - Sequence doesn't work

Closed Bug? created by Piero Groppuso Verified Purchase a year ago

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: photo 01.png

while when I try to create a new opportunity it proposes me this: photo 02.png

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?

  1. cm_sugar member avatar

    CM & Sugar Provider Affiliate

    a year 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.

  2. sarapuleo member avatar

    Piero Groppuso Verified Purchase

    a year ago

    Attached screenshots of the sequence in detail. photo03.png photo04.png 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?

    • cm_sugar member avatar

      CM & Sugar Provider Affiliate

      a year 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. sarapuleo member avatar

    Piero Groppuso Verified Purchase

    a year ago

    OK perfect. How long will it be available and where can I download the extension?

    • cm_sugar member avatar

      CM & Sugar Provider Affiliate

      a year ago

      Just finished it. Is already uploaded. Can you download version 1.5.0 ?

  4. sarapuleo member avatar

    Piero Groppuso Verified Purchase

    a year ago

    I can't find the file to download. Does it still need to be uploaded to the purchase section?

    • cm_sugar member avatar

      CM & Sugar Provider Affiliate

      a year ago

      please provide me your e-mail. it is right now not possible to upload the package. they have changed the settings...

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...