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 :
Microsoft Dynamics AX (Archived)

Modify Customer Account Number

(0) ShareShare
ReportReport
Posted on by

Hello everyone,

I am working in an environment that is utilizing both Dynamics CRM 365 on-premise along with Dynamics AX 2012. Our workflow generally revolves around entering and maintaining accounts within Dynamics CRM with an integration that will create / modify the account in Dynamics AX.

An account was created in Dynamics CRM with the wrong account number, but working as expected, the account was created in AX with the same account number. I've noticed that the Account Num field in Dynamics AX is grayed out and cannot be modified from the UI. My question: Is there a way to update / change the custtable.accountnum field for an existing record, and if so, how would I do that?

I am willing to perform development work such as creating a job and calling an X++ function if necessary.My fear is that a lot of tables reference that account number field such as CustInvoiceJour.InvoiceAccount ...etc and those will all have to be updated as well I'm guessing.

Thanks for your time and I appreciate any and all help!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Sohaib Cheema Profile Picture
    49,677 Super User 2026 Season 1 on at

    In AX you can make use of Rename Primary key feature.

    This will also update your financial dimension (If you have customer as FD), in case if you are one of the recent version of Dynamics AX. I remember this used to be problem on AX2012-R2-CU7

    Please test it on TEST system first, by year end closing.

    I still remember that thread when André and Brandon were helpful at discussion.

    https://community.dynamics.com/ax/f/33/t/188294

  • Community Member Profile Picture
    on at

    Hello,

    Thank you for taking the time to respond to me and ultimately helping me out with this problem.

    I cannot believe the team and myself all missed that if you right-click on a customer record and choose 'Record Info' there is a rename primary key button right there.

    I tested it out in our test environment and it didn't error out at all.

    Everything looks great moving forward!

    Thanks again!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans