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 201102: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