Mass Update Blank Title 55394

Yahoo Archive
1
bpm



Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jplehr
Sent: Wednesday, June 08, 2011 8:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Mass Update





Vantage 8.03.409C

I am looking to do a mass update to parts and looking for a possible way
to do this without going into each.

I have approximately 1,700 part numbers where I would like to mark the
'Backflush' as true. My common variables are... 1) all Purchased Parts
and 2) all contained to 2 warehouses.

Any options?

Jeff





[Non-text portions of this message have been removed]
2
I am looking to perfrom a mass update on some of our Part Classes to change them all to "stock" items. We are running Vantage 6.1 on a Progress DB and I know that this is possible however, I have no experience with this DB. If anyone can offer any assistance I would greatly appreciate it.

Thank you,

Dave Miller
Prince Industries, Inc.

[Non-text portions of this message have been removed]
3
Vantage 8.03.409C

I am looking to do a mass update to parts and looking for a possible way to do this without going into each.

I have approximately 1,700 part numbers where I would like to mark the 'Backflush' as true. My common variables are... 1) all Purchased Parts and 2) all contained to 2 warehouses.

Any options?

Jeff
4
Normally I wouldn't suggest going straight to the DB, but this is simple
enough that you'll probably be ok.

Disclaimer: I'm not familiar with the intricacies/requirements of
backflushing. But as long as it's something that can just be checked on
every part with no issues, you should be ok. For example, you can pretty
much always change the description whenever you want; but UOMs can't be
changed as they are referenced in other places. If changing the backflush
status on a part ever gives you an exception like 'can't change backflush
because of X' you'll need a more complex method. (Which I can help you with,
if it comes to that.)

Assuming it's a simple field to change; a bit of 4gl like the following
should do the trick:

FOR EACH Part WHERE Part.Field = "SomeValue" AND Part.OtherField <>
"SomeOtherValue".
ASSIGN Part.BackFlush = true.
END.

I'm not sure if Part.BackFlush is the actual field name, but I'm sure you
know/can find out for yourself.

On Wed, Jun 8, 2011 at 9:45 AM, jplehr <jlehr@...> wrote:

>
>
> Vantage 8.03.409C
>
> I am looking to do a mass update to parts and looking for a possible way to
> do this without going into each.
>
> I have approximately 1,700 part numbers where I would like to mark the
> 'Backflush' as true. My common variables are... 1) all Purchased Parts and
> 2) all contained to 2 warehouses.
>
> Any options?
>
> Jeff
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]