Scenario Overview

In this business scenario the requirement is to generate an Auto-Number on the Account entity. The specific requirement is that the first 3 characters of the account name is used as a prefix and that when generating the AutoNumber we need to count the number of existing prefix records & increment by one. 

Below is an example of what we require,   

                                                   Account Names
                                                   Microsoft - Ireland
                                                   Microsoft - UK
                                                   Microsoft - USA
                                                   Microsoft - Canada

                                                   Account Numbers

As always whenever we are using the North52 Auto-Number formula type we are guaranteed consistency when generating Auto-Numbers so no duplicates will be created even with multiple application servers for any of CRM Online, OnPremise or Partner Hosted.

It is assumed that the 'Account Number' field is read-only, accounts are never deleted (only deactivated)  & users cannot change the field.

North52 Decision Suite Solution

The North52 Decision Suite solution works like this,

  • Execute on the create of Accounts within the system
  • Have a formula that generates the auto number requirements
  • This formula executes a fetch-xml query passing in the prefix to get the existing count & adds one
  • Have the formula place the result of the formula into the Account Number field of the Account entity 

North52 Decision Suite Steps

Formula Steps

  • Create a new formula of type 'AutoNumber'
  • Set the Source & Target entities to 'Account'
  • Set the Source & Target Property fields to 'Account Number'
  • Copy & paste the formula description below into the formula description field & click save 

Formula Detail Steps

  • Scroll half way down the formula & click to add a new formula detail record (i.e. add the fetch-xml query)
  • Set the Name to 'GetCurrentAutoValue'
  • Copy & paste the fetchxml below into the query field & click save
  • You are now ready to test


 Upper(Left([] ,3)) + '-' +

                                      SetParams( Upper(Left([] ,3)) + '%' ))

Fetch-Xml Description

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="account">
      <attribute name="accountid" />
      <attribute name="accountnumber" />
        <filter type="and">
            <condition attribute="accountnumber" operator="like" value="{0}" />


Did you know?

You can create customized buttons to trigger complex business rules

North52's Decision Suite has functionality that we call Quick Buttons that allows you to place buttons on a form which when clicked will trigger a North52 Formula.  The business rule logic could be as simple as triggering a workflow or a much more complex process which involves many actions - the full power of the North52 business rules engine for Dynamics 365 can be used. 

The button's themselves can be subject to business rules, that show/hide, activate/deactivate or and/or change labels. This is configured using Decision Tables allowing complex decision logic to drive the button options that are presented to users.

Learn more about Quick Buttons