updated items in SOP

[jymm]

we have some items in the SOP module that our Customer Service department updated the names on (so instead of it being a '50 lb bag' it is now a '25kg bag') - problem is that most of our customers have quotes in the system and the new description did not get down to the quotes

aside from me writing some SQL to update all this stuff - is there something in GP (we are on v8) that would push the new descriptions down to the quotes?

 

[barbola]

If you only want to update the description on the existing quotes then SQL, in my opinion, would be the easiest way.

But wouldn't that description change also have caused a UofM change affecting the quantity and pricing?

Just to show Customer Service how this affects things, I would make them update each and every quote!

b.

 

[jymm]

thanks for the laugh Barb - I doubt that having CS do all that work would be a strong career move for me.

it only took a minute to write the SQL - I just wanted to make sure we were not missing something

Update SOp10200
Set Sop10200.itemdesc = iv00101.itemdesc
from SOP10200 inner join iv00101 on SOP10200.itemnmbr = iv00101.itemnmbr
where sop10200.soptype = 1 and Sop10200.itemdesc <> iv00101.itemdesc