RE: Shop Order Close

Our manufacturing group had that problem a few years ago. We were told not
to run CST900 since we were using the costing features. They would however
close the shop orders once a year (manually). This was very time consuming.
We had about 2000-3000 shop orders to close. 

        My suggestion to you to save a lot of time. Backup the following
files to tape. (FMA, FOD, FSO). These are your shop order files. Keep the
tape for shop order history (we have never restored the tape). Once these
three files have been backed up run the following SQL statements.

DELETE FROM XXX/FMA WHERE MORD BETWEEN #### AND ####
DELETE FROM XXX/FOD WHERE OORD BETWEEN #### AND ####
DELETE FROM XXX/FSO WHERE SORD BETWEEN #### AND ####

XXX = The library name where FMA,FOD,FSO reside.
#### = The shop order number range you wish to remove from your data files

We keep about 500 days of data on our database. Every January we remove any
shop order that is more than 2 years old.

        Good Luck and keep on BPCS'ing
        
        Marc Lacelle
        Royal Canadian Mint
> ----------
> From:         Lisa Abney[SMTP:abney@iquest.net]
> Reply To:     BPCS-L@midrange.com
> Sent:         Tuesday, April 20, 1999 9:59 PM
> To:   BPCS-L@midrange.com
> Subject:      Shop Order Close
> 
> We're on version 4.0.5, and would sure appreciate some help with the shop
> order close process.  We went up on BPCS in March '95, and were told at
> that
> time by our consultants not to run Shop Order Close (CST900, as we have
> costing installed), as we wouldn't be able to make adjustments to shop
> orders.  Now, I'm sure they meant that to be a temporary thing, as we went
> through the initial learning process, but 4 1/2 years later, we still
> haven't done it!
> 
> The biggest reason we need to do it, we've discovered, is that we would
> like
> to do some clean-up in our item master, but you can't inactivate an item
> master that has a shop order.
> 
> I called the SSA help desk on this, and they warned me this may take in
> the
> neighborhood of days (or weeks?!) to run the first time, as we have
> 220,000
> records in the FSO file.  (He said most people run this process at least
> weekly ... whoops!)
> 
> I've played around with this in a test envionment, and it's going to be a
> real pain, I can tell.  We also have performance measurement installed
> (although we've never used), which apparently means I have to close each
> period for each facility individually before I can even do CST900.
> 
> Does anyone have an easy solution?  All I really care about is cleaning up
> my FSO (and, I suppose, the FMA) so that I will be able to inactivate some
> item numbers ... I don't care about performance measurement, the costing
> stuff, etc.
> 
> Any suggestions would be welcome!
> 
> 
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---