Dear Al,

As long as the orders are entirely completed and old enough (i.e. probably not a good idea to remove orders from the current annual accounting period), our Locksmith software product will 1) archive them in separate folder that has the same database structure as your production library, 2) look up and take along any conceivable orphan from something like 13 related files, 3) reorganize the files to recapture disk space. You then have to option to save the archive folder off to tape or let it sit on the hard drive for historical research projects.

www.unbeatenpath.com/software/locksmith/archiving.pdf

Recently, a user on v6.x told us a story about buying a generic archiving product and trying to configure it to handle BPCS. After more than two years of practice, they are now interested in Locksmith because they found hundreds of thousands of orphan BPCS records the generic tool didn't know about. Locksmith can clean up that historical mess too.

Peace,
Milt
Unbeaten Path
+262-681-3151
888-874-8008




----- Original Message -----
From: Al
To: 'BPCS ERP System'
Sent: Sunday, December 06, 2009 4:06 PM
Subject: [BPCS-L] Dead Customer Orders cluttering 405CD disk space

Before I write a program to delete from AS/400 the customer orders that I
believe are soft coded for deletion, I am asking if there might be some
existing BPCS program, that I may be overlooking, that is supposed to take
care of this. We are 405CD on AS/400 model 170 V5R1.

Main candidates for deletion: ECH.HID is no longer 'CH', there's nothing
left to do with the order in shipping or billing, and last action was many
dates ago.

We have approx 16 k (count) orders in this boat.

Al Macintyre


As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2021 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.