web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    48,813 User Group Leader on at
    RE: Dynamics AX 2012 Update / Modify CustTable.AccountNum

    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
    RE: Modify Customer Account Number

    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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans