mark nelson 9/1/2016 9:49:17 AM

Needing to update company address name

We are renaming our company, changing the company name was pretty easy, however we have over 500 location names. (Company Setup/ Company Address/ lookup) I need to change the name from X to Y so to speak.

I am looking for a way to change location name X to location name Y ( new location name) using SQL , would anyone be able to assist me?

 

Even if thats just the correct table name/ names

 

Thank you

 

Mark

Version: GP 2010
Section: Dynamics GP


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3