Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Is there an easy way to change Item Descriptions for multiple Items in Dynamics GP 2013?

    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.

    PSTL-Item-Description.png

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is there an easy way to change Item Descriptions for multiple Items in Dynamics GP 2013?

    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.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Is there an easy way to change Item Descriptions for multiple Items in Dynamics GP 2013?

    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

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Is there an easy way to change Item Descriptions for multiple Items in Dynamics GP 2013?

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans