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

Announcements

No record found.

News and Announcements icon
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 172

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.

  • huijij Profile Picture
    19,813 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,573 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
    172 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
    172 on at

    Can I have any suggestions or help on this?

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,633 Moderator 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 495 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 432 Super User 2026 Season 2

#3
CU10121822-0 Profile Picture

CU10121822-0 366

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans