Share
Report
5We 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.
All responses (
Answers (
