web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

How to make customer account number follow it's number sequence when a new record is created in CE when mapped through dual write

(0) ShareShare
ReportReport
Posted on by 170

Hi there, 

I have mapped the Customers V3(accounts) entity in F&O with the customer's entity in CE and everything is working fine but I want to know one thing when a customer is created in CE simultaneously a new customer is created in F&O with the same customer account number that has given in CE(auto number), so I want to know is it possible in F&O to create a customer with its own number sequence when a customer got created in CE using dual write.

I have the same question (0)
  • huijij Profile Picture
    19,811 on at

    Hi Ax Trainee,

    If the mapping doesn't meet your business needs, you can try the Delete actions on each entity map field.

  • Suggested answer
    Mohit Rampal Profile Picture
    12,565 Moderator on at

    Hi, Have you checked this MS article.

    Number sequences for finance and operations apps and customer engagement apps aren't connected. In a scenario that involves a multi-mastered table, you must either plan for separate number sequence formats or create a range for each app. Here are some examples:

    In the finance and operations app, use F0001, F0002, F0003. In the customer engagement app, use C0001, C0002, C0003.

    In the finance and operations app, use US0001 to US4999. In the customer engagement app, use US5000 to US9999.

    learn.microsoft.com/.../dual-write-faq

  • Ganesh Potnuru Profile Picture
    170 on at

    Hi Mohit,

    Thanks for the information but here I have mapped the Customer account in F&O field account number field in CE. So, when they have created a customer account the CE account number is imported and reflected in F&O instead of account number created using number sequence in F&O. Kindly, suggest to me how to make a customer account in F&O follow its own number sequence instead of taking CE account number.

  • Ganesh Potnuru Profile Picture
    170 on at

    Can I have any suggestions or help on this?

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,623 Super User 2025 Season 2 on at

    Logically, one of the purposes of Dual Write is to maintain synchronization between CE & F&O, so it may not be possible to accomplish what you want.  You might want to open a Microsoft case for assistance.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans