ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Mass Field Value Change based on Vendor Name
http://www.istechforum.com/YaBB.pl?num=1361307121

Message started by gtladmin on 02/19/13 at 13:52:01

Title: Mass Field Value Change based on Vendor Name
Post by gtladmin on 02/19/13 at 13:52:01

Purchasing is going thru the inventory listing updating the ROHS fields. In many cases, some vendors
have over 1,000 products/parts in our inventory, and we would want to change all those parts for that vendor from N to Y.

Is there any way where if we can say "if Vendor name = ABC, then for ROHS change from N to Y"
easily enough? It would save a lot of time.

Title: Re: Mass Field Value Change based on Vendor Name
Post by gtladmin on 02/21/13 at 09:08:58

Bump...anybody?

Title: Re: Mass Field Value Change based on Vendor Name
Post by Lynn_Pantic on 02/21/13 at 17:10:46

You could do it as a SQL command at the Pervasive Control Center. The RoHS value is position 4 in a 4 character field so I will have to lookup the syntax for updating a substring of a field. I will email it to you.