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 :
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,438 User Group Leader 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

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

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans