Changes to description field in IV00101

(0) Share

Report

Posted on by Community Member

We have to change the wording in a our description field for about 2000 of our products via sql. If we change the description via a script on IV00101, will any other tables that has the description field need to be change?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: Changes to description field in IV00101

If you need to change Item Vendor Description, you'll need to hit IV00103 as well.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Changes to description field in IV00101

It's not a vendor description on the item card so I don't think this table needs to be changed

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

RE: Changes to description field in IV00101

I would agree with Frank, that if it affects the Vendor that would be the only other place to address.

All the places that the Item Description is displayed and presented on reports look back at the IV00101 table - and the IV00103 when showing the Vendor name for the item.

So, unless you have any 3rd parties that store the data outside of the IV00101 you should be pretty well ready to go.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: Changes to description field in IV00101

Just a note that it won't change the description on any transactions that have already been posted - like SOP and POP (or invoicing) transactioins.

Was this reply helpful? Yes No
Suggested answer

Victoria Yudin 22,768 on at

Like (0)

Report

RE: Changes to description field in IV00101

To add to what Leslie said - this will also not update any unposted transactions that have already been saved. So if there are 2000 quotes out there that may be turned into orders and then invoices, you might need to do the same update on the item descriptions in the SOP10200 table.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (1)

Report

RE: Changes to description field in IV00101

You could also use the Change Item Description tool in the PSTL collection.

Kind regards,

Leslie

Was this reply helpful? Yes No