Is there an easy way to change Item Descriptions for multiple Items in Dynamics GP 2013?

(0) Share

Report

Posted on by Community Member

My company is re-branding a few of our products. Our current descriptions use the branded item name as part of the description in all configurations of that product as well as all major components used in the manufacture of those items. Is there any way to do a "Find and replace" within the item description on a mass level? My first item name update will need to be changed on 803 different part numbers and I really don't want to do that manually. I am interested in any routines, addons or SQL scripts that would help with this

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (3)

Verified answer

Richard Wheeler 75,850 Moderator on at

Like (1)

Report

I would create a list using Excel with the item number and new description and then import this into SQL. If you have some common theme to your description convention you could use the SQL REPLACE function in an update query. If you could provide a concrete example I could send over a sample script.

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (1)

Report

Hi,

Like John mentioned, I think the SQL Replace with the Update statement would be the way to go. For instance, if my brand was 'Cellular One' and I wanted to change it to 'Cingular', the script would look something like this:

Update dbo.IV00101

Set ITEMDESC= replace(ITEMDESC, 'Cellular One', 'Cingular');

This example would change the words 'Cellular One' with the word 'Cingular' anywhere it existed in the ITEMDESC column of the IV00101 table. If 'Cellular One' didn't appear in the column, the ITEMDESC would not be changed.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Leslie. This seems to be the way to go. I will try this in my test company first just to make sure. I had one question though. Will changing the description in the Inventory Master table conflict with any other tables? The Bill of materials table comes to mind.

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

If the actual description is part of the table, and not just a reference to the master file, then you would also need to change that table. Specifically speaking about the Bill of Materials tables, the description is not included, only the item number. The description comes from the Item master. Any tables containing the item description such as a PO or SOP document will not change unless you specifically change those tables.

If you can get the old name/new name in a spreadsheet you can use the item description modifier.

Leslie

Was this reply helpful? Yes No