Company: | Link Technologies | Case No: | L12377 | Logged By: | Sanjay (Link Technologies) on 29 Mar 2011 02:50PM | Priority: | Not Applicable | Product: | Other | Group: | To be assigned | Time Taken: | 0.00 | Assigned To: | Sanjay (Link Technologies) | Circulation: | Sanjay | Resolve By: | Tuesday, 29 March 2011 02:50 PM [4749 days since logged date] | Status: | Closed |
|
Subject: | How do i change the ACCOUNT Number sequence in CRM | Summary: | The next account number in CRM is 61, however this clashes with account numbers from JIWA. How do i change the next numbers so that it is in a different sequence and has a prefix. | Audit Notes: | | 29 Mar 2011 | 02:54PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-08-2021 02:33 PM | | The number sequences are stored in a table called NUMBER_SEQUENCES. Change the values in this table to get a prefix, padding, next number etc.
The script below will add a prefix 'CRM' and will keep the length of the numbers to 6 digits. The result will be numbers like 'CRM000062', 'CRM000063' etc
Update NUMBER_SEQUENCES set ALPHA_PREFIX = 'CRM' ,NUMERIC_PADDING = 6 WHERE NAME = 'ACCOUNTS.ACCOUNT_NUMBER' |
|
|
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12377 in the subject line of all emails regarding this issue.
Document size: 0.6 KB For call complaints, please contact the Managing Director of the company using this form. |