Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested answer

ACCOUNT NUMBERS

(0) ShareShare
ReportReport
Posted on by 15

How to set up account numbers for accounts

  • LuHao Profile Picture
    LuHao 40,876 on at
    RE: ACCOUNT NUMBERS

    Hi partner,

    Has your problem been solved? Need more help?

    Please click Yes under "Did this answer your question?" to close this thread.

    pastedimage1596189277814v1.png

    Thanks.

  • Suggested answer
    LuHao Profile Picture
    LuHao 40,876 on at
    RE: ACCOUNT NUMBERS

    Hi partner,

    There is already an Account Number field which type is text in Account Entity, so if you want to achieve auto-number function, just change the type of it from text to Autonumber.

    Here are steps.

    1. Go to Power Apps (https://make.powerapps.com/).

    2. Expand Data and click Entities to select Account entity.

    61661.png

    3. Navigate to fields to edit Account Number field.

    6330.png

    4. Fill in as shown below.

    (1) Change Data type to Autonumber.

    (2) Set Autonumber type to Custom, and select Add random string to format, so that the Format is {SEQNUM:4}-{RANDSTRING:4}, Preview is 1000-YNH6.

    pastedimage1595570820885v4.png

    The purpose of changing Format to {SEQNUM:4}-{RANDSTRING:4} is to prevent duplication of account number when users are using D365 offline, that is, to avoid duplication of its number part, we need to add a random string to make the value of the account number field unique.

    For example, three users are using D365 offline, and they create an account record at the same time, then when they login to D365 online, these three records will be the same value, like 0164, 0164, 0164. If we add a random string to the account number, then these three records will be the different value, like 0164-YNH6, 0164-181K, 0164-Q0P8.

    5. Click Done and Save entity button.

    6. Test

    2772352.png

    75575.png

    58332.png

  • Suggested answer
    meelamri Profile Picture
    meelamri 13,212 User Group Leader on at
    RE: ACCOUNT NUMBERS

    Hi, 

    You can use the New auto-number field. Please refer to this blog: 

    d365goddess.com/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans