 | 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 [5373 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 Support@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. |