Re: BPCS 405 CD goodbye facility

I use embedded SQL heavily for SELECT info, read in. I have no experience
using it for mass updates. I recognize the value, but am nervous about
going that route. I am more comfortable using familiar coding approaches,
which I have used countless times in other programming.

I will probably do that kind of program solution for dead records dating
back many years in facilities we no longer use, where the volume is in the
thousands. We need to be careful not to mess up BPCS files in the process.
For example IIM count # records in ITH, how total $ and quantity updated in
various master files.

With low volume (judgment call), and one time deals, we do manual deletions.
With repeating scenarios, high volume, we have multiple fix-it programs.

One I would like to have is for spool file ... key in some user name, some
OUTQ, and either a cut-off date, or some time-ago ... please delete all
spool file reports in the name of user-X in OUTQ-Y which are 2 or more
months old. Reason, I have not been able to get the company to include in
the training of new employees, CLEAN UP YOUR spool file, to only include
what you need to keep, such as reports since last backup, and monthly
reference what totals were. So guess who gets to delete them manually by
the thousands.

-
Al Mac

-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of rkhbit@xxxxxxx
Sent: Wednesday, January 04, 2012 6:21 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: Re: [BPCS-L] BPCS 405 CD goodbye facility

Have you considered SQL? Its great for mas changes and mas physical deletes.



-----Original Message-----
From: Al <macwheel99@xxxxxxxxxx>
To: 'BPCS ERP System' <bpcs-l@xxxxxxxxxxxx>
Sent: Tue, Jan 3, 2012 10:56 pm
Subject: [BPCS-L] BPCS 405 CD goodbye facility



Does anyone have a check list on what is involved in closing out a facility,
and optimal sequence for doing so?
I know from closing out other stuff, that we need to locate and destroy any
records hung with customer orders, purchase orders etc. involving that
facility.
UPI Locksmith has an option to archive all cost records on combinations of
acility and cost set of choice.
* This evening BPCS let me:
blank out RA01 default receiving location from warehouse 39;
Then delete location RA01 in warehouse 39;
Then delete warehouse 39.
However, warehouse 37 in same facility has 90 location records, which are
now empty of inventory. I was hoping I do not have to manually delete each
and every one.
There are engineering records. We got a modification from one of our
consulting friends, where engineering records can be mass copied to another
facility. But the company wants to keep records on selected customers,
here parts we last made 10 years ago, that business might come back.
fortunately I have a modification which identifies which customers
associated with which engineering data.

-Al Mac-