Re: Inactive Items -- BPCS-L

This solution is like a magic bullet to solve the major BPCS hassle that you are asking about. There are very few real magic bullets out there, but I think this is one of them.

Semi-Vendor Affiliate response ... If you buy this solution from UPI and say you did so because of ME, then I am supposed to get like a commission. But UPI might not be licensed to sell this in Australia. You may need to ask Small Blue in Britain for who sells it in Australia.

UPI calls it Locksmith http://www.unbeatenpathintl.com/locksmith_bpcs.htm It is an archiving product for BPCS in which you specify the criteria for which you want to move to another library the stuff that you no longer want in your BPCS data base, then when it has been moved to the archives, users can still get at it there, but it is also easier to get rid of some archives for good. We will soon be getting a 14 day free trial of this thing. I am really looking forwards to seeing how much of this nonsense it will cure, and how much I can tell people about it. I have some Word documents describing it that I can send to you attached to e-mail if you wish.

There are several reasons someone might want to do this. * BPCS documentation does say that before deleting this or that, you should first delete that other stuff, and occasionally you get error messages that this or that can't be deleted until something else taken care of, but it is kind of hodgepodge incomplete, and very time consuming to do manually. Here is a package where someone has already figured out what is needed to clean up about 50 files, with provision so you can add more files to the collection, and all you have to do is specify the criteria for which you want to get rid of a pile of stuff ... for example, there are various dates in various files ... you select which one to use & say you want to get rid of all records older than that date, and while doing so, keep the data integrity intact on the related files. They have done the research for us, and written the programs for us, to accomplish this. * There seem to be an almost infinity of files for which BPCS has inadequate provision to easily get rid of ancient content, that is connected to various other files. You can write lots of little pieces of software to handle this, or you can get the archiving product with the interfaces already written to get rid of what you not want any more, that also makes sure BPCS runs fine ... consider files that have sequence numbers ... the archiving product not leave gaps ... plus you have the option to later bring back some records if you want. I have in fact written many little pieces of software for this kind of thing, and am still scratching the surface of what is needed. * Locksmith comes pre-supplied with provisions for you to specify criteria that you want to use to get rid of old obsolete stuff in about 50 files, and you can also add files to the collection ... so for example we have added some files in modifications, and like SSA example, never got a round TUIT developing support for the old stuff to go away, until now. * We have deleted customers, like for example one that went so bankrupt they not in business any more, but that customer has records in inventory history, sales history, shipping history, order notes, you name it. * We have deleted items, then discovered that when an item has gone away from IIM that it does not go away from ITH, so that when the item is reassigned to something totally unrelated, guess what, it comes pre-supplied with the ancient unrelated history, messing up INV300 F21. * You must have a more advanced version of BPCS than our 405 CD because we have deleted IIM items that are still in CIC CMF ECL EIL ITH IWI ILI JPH our various modifications and there are files I have not checked yet * We have restarted shop orders, but because we have some orders that remain in the system for a long time, we cannot get rid of labor tickets purely by some date cut-off ... I modified the purge so that it checks each FLT against FSO and not get rid of FLT if FSO still exists. Anyhow, when a shop order is released on some order # whose FLT is still in the history, SFC300 goes totally bonkers. * There are various places in BPCS where you can run out of numbers, want to keep the historical data, but also re-use the numbers, well this archiving product makes that possible. If you have something that fills up a lot, you can have different libraries for different fiscal ranges. * When BPCS has to wade through masses of dead records to get to the ones you really need to keep, there is a productivity hit that can be cured by spending oodles of money on a more powerful AS/400 iSeries, and paying SSA for another license key on the replacement 400, or you can use this archiving product instead. Same benefit. A much faster more responsive BPCS on 400.

Hi All,

We have around 5000 obsolute items to be soft deleted.   Instead of using
INV100  for item by item,,
what is the best way of  marking them deleted , and keeping the data
integrity intact.
I checked the INV100 program and it physically deletes from CIC, CMF and
IIH
Also soft deletes from IIW.

Any one tried some other method?

Thanks in advance

Cheers


Gehan Jayasundera
Hella Australia


The information transmitted in the above message is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material.  If you are not the intended recipient of this
message, you must not disseminate, copy or take any action in reliance on
it.  If you received this in error, please contact the sender (phone: (03)
9581 9333, fax: (03) 9584 1741) and delete the material from any computer.

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

- Al Macintyre http://www.ryze.com/go/Al9Mac Find BPCS Documentation Suppliers http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html BPCS/400 Computer Janitor at http://www.globalwiretechnologies.com/ Part time may get commission from some BPCS vendors for helping them ... I will now say in a post if the product I commenting on is also one potentially involved with this ... not that I have made anything from this yet.