I agree with Bill's comments.

We remove Customer Orders from our Live files on a regular basis (weekly). We don't completely delete them, we move them
to a set of archive files that mirror the layout of the live files, in a separate "archive" library.

We use criteria : HID = "CZ" and Date Shipped or Date Cancelled is over 40 days ago. You may have different requirements, but
this seems to work for us.

Additionally, for DRP orders (HDTYP = 9) all lines on the order must be fully received (LRQTY >= LQSHP)

We have enquiries that allow view of archived orders. You can bet your bottom dollar an hour after deleting an order
someone will need to know what was on it !

This obviously doesn't reduce disk usage, but it does reduce the amount of "Live" data that BPCS is working with.
You may also be bound by industry standards, traceability requirements etc to keep orders visible for a certain time.

Along with ECH we archive ECL, ECS, ECT and ESN. In a similar thread some time ago someone told me that we are missing a number of
other files that should be archived as well. We don't have any known problems, but we may have orphan records around the system that
we don't know about. Looking at the files open when in Order Entry/Maintenance I checked and there are some other files that BPCS
could populate but which we don't make use of so it doesn't seem to be an issue for us.

There are 3rd party products on the market that do a more formal (and better!) archiving job, no doubt they will be mentioned in other replies.

We also archive other files (Shop Orders, Purchase Orders etc) on a regular basis. If doing any archiving you have to ensure you do it before any
Month-end BPCS jobs get in first and simply blitz the data off the files, based on the archive/delete criteria set up in system parameters.

Tom Molyneux

NOV Mono
MIS Department

Tel. +44 (161) 214 2142
Fax. +44 (161) 214 2344
E:mail Tom.Molyneux@xxxxxxx

-----Original Message-----
From: bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx] On Behalf Of Bill
Sent: 08 December 2009 17:53
To: bpcs-l@xxxxxxxxxxxx
Subject: Re: [BPCS-L] Dead Customer Orders cluttering 405CD disk space

Al wrote:
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.

The only problem you might have with this is if you have DRP orders.
IIRC, DRP's once fully shipped are no longer CH, but should not be
removed until all of the detail lines have been fully received.

The way I do it is to just go by HEDTE's that are over x number of years
old. Where x is usually at least 5.

This is the 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.

Delivered-To: Tom.Molyneux@xxxxxxx

Mono Pumps Limited
Registered in England No. 300721.
Registered Office : Martin Street, Audenshaw, Manchester. M34 5JA

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.