Re: Cust Orders Completed

[Roger.Henady@xxxxxxxxxx]

When deleting orders you should consider not only the 'CZ' but also a date.
The customer service may want to refer to the completed orders for a year.
The ECH, ECL, ESN,  and ECS all have the ORDER number as the key.        If
you delete any be sure to clean up all files.
ORD990 ---- will delete headers with no lines.  and clean up lines.


Roger Henady
Thorco Industries
(417) 682-1340



                    MacWheel99@aol.
                    com                    To:     BPCS-L@midrange.com (BPCS 
Users Discussion Group)
                    Sent by:               cc:
                    bpcs-l-admin@MI        Subject:     Cust Orders Completed
                    DRANGE.COM


                    01/15/2002
                    09:18 PM
                    Please respond
                    to bpcs-l






I am aware that BPCS 405 CD has no customer order purge program like ORD
has
in V6 & BIL had in BPCS/36.  I need to write our own purge program because
for every one good open customer order now operational, there are approx 25
that have delivered to the customers everything that we are going to be
sending.

There are files all over creation with soft deleted records that are not
going away.

Does ECH.HID = 'CZ' mean order is purgeable
or does ECH.HSTAT or other field(s) also need some specific value to
consider
them purgeable?

Of our approx 8,000 'CZ' in member ECH
most are type 1 status 8
we have about 600 with type 1 status E
and 2-3 each of 1-4 7-E and 7-8

We have 623 RMA 'CZ' (member RETURN) including 1-E 1-8 7-E 7-8 9-E 9-8

We have 8 member QUOTE 'CZ' all 1-E

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
BPCS 405 CD Manager / Programmer @ Global Wire Technologies Incorporated
http://www.globalwiretechnologies.com = new name same quality wire
engineering company: fax # 812-424-6838
_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.