We have BPCS files that contain records that have no matching Item in the
Item Master (IIM) file.  Is it safe to delete these items from other BPCS
files without any kind of verification?  Thanks for the advice in advance!
This is something I been working on, and not just IIM file.
You need to be familiar enough with BPCS of your version to see what is
going on, like notes files with pointers to originals that aint there any more.
In my case, cleaning out IIM file is the LAST file I hit after cleaning out
stuff that affects costs and planning for example, then the actual cost
planning files.
I not clean out the records if there been ANY activity on them recently.
You also have to be careful with new records ... a new record can show date
of last activity being NONE, so different dates used to eliminate from

BPCS is good at adding records for a growing business.
It is not good for handling turn-over of business where there are
engineering changes, model line changes, turn over of customers.
Some files purge themselves more or less automatically within the course of
monthly and annual operations, while others accumulate data to infinity.
I wrote a program to take an IBM dump of 400 file statistics then look at
each file with SQL to get the oldest date there, and put the whole thing in
chart format so we could see .... Ok if we eliminate all the records more
than 2 years old from this file we will save X disk space, so now I have a
bunch of tiny programs we run annual or more often to do that with various
This was after I had a chat with each department ... how long do you need
to keep shipping history ESH ESL records anyway, or whatever the case may be.
My analysis found there was more disk space wasted from duplicate software
than from dead records in the files.
You can get the whole package written for you from some consultant.
Go to the UPI web site and check out BPCS LITE

Al Macintyre (macwheel99@sigecom.net via Eudora)
Al's diary http://radio.weblogs.com/0107846/
Cure cancer. http://members.ud.com/about/

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].