Need to set up a numbering system to track your records? Define and add a unique ID identifier field to any SugarCRM record. Many options to define any alphanumeric format you need. Start tracking your Quote, Cases, Accounts and any other module today..
#764 - Sequence add on didn't stay the same number when edited.
Hi,
I bought the sequence add on from you guy a month ago. When I create a new Contact in the Contact Module I have a Contact Number field to be auto generated read only field like CN000001 and save. it's working fine, but I did not realize that until when I go back to the same Contact and edit some information the Contact Number field changing from CN000001 to CN000002 by itself. It did not stay the same only happened when I edit the Contact. Please I am looking forward to your help to resolve this issue. Thanks
Regard, Matoula Senethavong
10 years ago
Addition, I also receive an error message when click on Contact edit tab. This error message regarding to the Sequence Module from sugar.log file
09/04/14 16:14:13 [9044][1][FATAL] Error receiving the max sequence of contacts for field contact_number_c: Query Failed:SELECT MAX( SUBSTRING( contact_number_c, 2 + 1, ( LEN( contact_number_c ) - 2 ) ) ) AS contact_number_c FROM contacts LEFT JOIN contacts_cstm ON contacts_cstm.id_c = contacts.id WHERE contact_number_c IS NOT NULL ORDER BY contact_number_c ::: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid length parameter passed to the LEFT or SUBSTRING function.
10 years ago
This error message originates from line 134 in Sequences.php of the Sequences package.
10 years ago
I will need a session again, because it is a MSSQL issue. It can't handle negative values at the native function. Guess, this is also the reason for your other problem of the changing numbers. You can leave me an E-Mail with the session paramters. However, it is quite late, I can't do it right now.
10 years ago
Sound good. Let schedule on Monday September 8, at 10 am Pacific time and we can go to Team viewer to resolve the problem. I will send the session to you on Monday before we connected. Thanks
10 years ago
Here is the TeamViewer ID. I’m ready and awaiting for your connection at 10 am Pacific time. Thanks
ID: 605 229 116 Password: 4765
10 years ago
Problems got resolved. Thanks for your time!
10 years ago
Hi Roger,
I have a duplicate sequence on my contact number. The sequence should auto-increment from the last number like CN029420 and so on when I initial fill all the contact number. When I start create the new contact the contact number auto-generate this CN000008. Even though this CN000008 is already assign to existing contact. Please can you remote in and take a quick look. I’m available all day. Thanks