Skip to main content

Notifications

Announcements

No record found.

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,872 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,872 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,204 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans