Skip to main content

Notifications

Microsoft Dynamics CRM forum
Suggested answer

Auto Generate an Account Number?

editSubscribe (0) ShareShare
ReportReport
Posted on by

Is there a way to add a field on the Account Form to auto generate a new number whenever a record is created?  Similar to how Case has this out of the box?

  • Auto Generate an Account Number?
    Hello,
     
    I beleive I have followed all these steps. And if I upload a list of accounts all of then gets a unique accounID. Example below of an account that was uploaded from a file:
    But when Iclick on NEW (Create a New Account record) the AccountID field in there remains empty and furthermore I cannot save the new record unless I enter a value in the AccountID field. Trouble is it is very hard to know what ID-number to enter. Example below when clicking on NEW:
     
    How can I get the AccountID field to be automatically populated with a new unique ID when I click the NEW-button?
     
    /Mikael Helmers
  • Suggested answer
    Thomas Goehrig Profile Picture
    Thomas Goehrig 20 on at
    RE: Auto Generate an Account Number?

    You will need to open Power Apps (make.powerapps.com)

    Select the solution "account" and click edit

    pastedimage1665006387172v1.png

    pastedimage1665006422987v2.png

    Click "New Column" on the top ribbon

    Enter Display Name "Account ID" or "Account #"

    Select "Autonumber" for data type

    pastedimage1665006543327v3.png

    Complete the following fields:

    1. Autonumbering type: String prefixed number, Date prefixed number and Custom.
    2. Prefix: See preview below
    3. Minimum number of digits for Account ID
    4. Seed value: Where Account ID value starts

    pastedimage1665006792029v6.png

    Click "Save"

    Add "Autonumber" field to "Account Form"

    Return to "Account" Solution and click the drop down next to "Table" on the site map on the left hand side. Click the drop down next to "account" and select "Forms". Choose the form you would like to update and click "Edit"

    pastedimage1665007249720v7.png

    Once the form loads choose the new field and place field within the "Account" form and publish changes. 

    Thanks,

    Tom

  • necsa Profile Picture
    necsa 3,455 on at
    RE: Auto Generate an Account Number?

    Try following links

    jukkaniiranen.com/.../

    arunpotti.com/.../

    thattechiegirlroma.wordpress.com/.../

  • RE: Auto Generate an Account Number?

    Wow I think that would work great!  Only problem is it says its not available in the classic interface.  How do I get to that area from the classic interface?  

  • empath-e CRM Profile Picture
    empath-e CRM 1,132 on at
    RE: Auto Generate an Account Number?

    Would creating an Auto Number field on the Account entity work for you? Here is an example:

    d365goddess.com/.../

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,375 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,308 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans