Customer Engagement & Dynamics CRM Forum

 View Only
  • 1.  Auto Assign Case numbers

    Posted Jan 05, 2021 01:14 PM
    Since we started with CRM, we have had the case # auto generate for us.  19-######, 20-######, 21-######.  Our original consultant supposedly set up us so that the Prefix changed on 1/1 of each year to be the last 2 digits of the year, and that the suffix would reset back to 000000, to make sure that we didn't run out of numbers.  Our prefix is changing correctly, but our suffix is not.  I looked in Advanced Settings > Settings > Administration > Auto-Numbering, but the information on the Cases tab does not match what we are doing.

    ​In order to achieve what we want, do we need to build something custom, or is there a way to do it in the system?

    Tina Silver
    Sr BSA, CSM®
    SR Smith, LLC
    Canby OR

  • 2.  RE: Auto Assign Case numbers

    Posted Jan 06, 2021 08:42 AM

    An option to manage numbering sequences is the Auto Number Manager tool that is available in XrmToolBox.  I have not written any scripts to automatically reset the sequence back to "1" at the start of the year but the steps can be accomplished manually very quickly.  We are using Auto Number Manager to reset a sequence for a client at the start of the year and the format is the same as yours, 19-#####, 20-######, 21-######, etc.  This approach did entail creating a separate table (entity), specifying a number format such as "{DATETIMEUTC.yy}-{SEQNUM:6}, writing some traditional workflows, and then each year we manually enter the "seed" value of "000001".  

    I am not recommending this as the approach for you but stating that there is an available option to handle this.  If at all possible, the recommended approach is finding out how your original consultant accomplished the customization and continue to use that method as there could be other configuration related to it. 

    I hope this helps!


    Jim Lorrig
    Senior Business Solutions Consultant
    Heartland Business Systems
    Little Chute

  • 3.  RE: Auto Assign Case numbers

    Posted Feb 24, 2021 03:52 PM
    hi Tina,
    you need to register a simple plugin for this.
    good luck.

    Mehran Ahmadifar
    Senior Microsoft CRM/Dynamics Developer
    KIT Group

If you've found this thread useful, dive deeper into User Group community content by role