Are looking to create an auto generated field which will work same as case Reference number?<\/p>\n
Yes it\u2019s possible, we can create auto generated field for custom entity or any standard entity. What you need to do is:<\/p>\n
1. Create your fields as stored procedure type within CRM.<\/p>\n
2. Add a new entry into the \u201ccustom_sysparams\u201d table as per the Sage CRM standard.
For example, Param Name = \u2018CustomEntityNameCuEn_referenceid\u2019 and Param Value= \u20181000\u2019 \/\/ here 1000 is the initial value for this auto generated number field <\/p>\n
3. We need add few scripts to auto increase the number for your custom field in the stored procedure named \u201ceware_default_value\u201d.<\/p>\n
4. You can use this field on any screen.<\/p>\n","protected":false},"excerpt":{"rendered":"