ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> Mass status change to WOs
http://www.istechforum.com/YaBB.pl?num=1098731038

Message started by jwalden on 10/25/04 at 11:03:58

Title: Mass status change to WOs
Post by jwalden on 10/25/04 at 11:03:58

Is there anyway to make a status change to multiple WOs?

If not, I'd like to request a method of making status changes to multiple work orders with filtering on date, WO#, and item number. I'd like a prompt for previous status =? new status =?. That way we could change all the work orders for a given item that had been status "F" to "S" in one step and back to "F" again in a second run to pick up a revision update which changes the bill of material or routing information

Title: Re: Mass status change to WOs
Post by aricon on 10/25/04 at 11:51:50

You could do this with the ISTS Search and replace utility.

http://www.istechsupport.com/addonut.asp

Only $49.95.... ;D

Title: Re: Mass status change to WOs
Post by jwalden on 10/25/04 at 12:07:06

I have the search and replace utility and love it (although I don't use it effectively).
Perhaps I should clarify:

It's not simply changing the status field in the WO table from one value to another that I need, it is the action of erasing the WO bom (and routing) and recreating by going from status F (or R) to S and back to F (or R) that I would like to do en masse.

I don't think changing the status using NZFNR would do that, would it?

Title: Re: Mass status change to WOs
Post by aricon on 10/25/04 at 14:04:33

No it wouldn't. And I would suggest you contact Lynn directly to get a custom program for this, as there would be VERY little call for this to be included in an ISTS package as it is not a widely held requirement. In fact, that is the 1st time I have ever heard of this sort of desire.

Title: Re: Mass status change to WOs
Post by Lynn Pantic on 10/25/04 at 15:38:35

You are right, Jim, NZFNR will change the status but not strip and replace the Routing and BOM. You could use it to also delete records from WOBOM and WOROUT if all the needed filters existed in those files to strip the old BOM and Routing but you would still need to reset the status individually. It would need to be a special program.