Skip to main content
Microsoft Dynamics NAV forum
Unanswered

Changing Customer # on Multiple Records (NAV On Premise)

editSubscribe (0) ShareShare
ReportReport
Posted on by 5

We have about 800 customers that we need to change their Customer # to a new Customer#. Was hoping to update based on a list (ie Old# and New# in Excel or even a sql server table) without having to go into each Customer card.

According to threads I've read in this forum, it says "you should uses RENAME while changing the primary key"

I looked at this thread https://community.dynamics.com/nav/f/microsoft-dynamics-nav-forum/215575/changing-customer-number-on-customer-table but wondering if there is a way to do this through SQL Server or anything as we are not C/SIDE developers. We did do a test with a SQL update query (using SQL Server Mgt Studio) but noticed that although the [No_] field changed, it did disconnect that customer record from all of its transactions. That's what I was afraid of.

Does anyone know of a tool or alternate method of doing this without using C/Side or then maybe instructions on writing something? I am a dev but know nothing about getting started writing a simple looping update modules in CSide or where that is done. I do have access to the "Dynamics NAV Development Environment [Object Designer]" but not sure what to do with that. I have used it to play with queries but that's about it.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans