RE: Cust Orders Completed -- BPCS-L

Mac,

We are running version 6.04 and have just started running the order purge
within the last 3-4 months.

The system parameters allows us to choose a date by which to purge orders:

ORD820D-03                 BPCS System Generation           ENG02A
1/16/02
Revise                  Order Entry System Parameters       BNORRIS
09:08:09






Automatic Close of Orders Supported                1  (1=Yes  0=No)



Rules for Automatic Closing of Orders:

    Ordered vs. Shipped Basis                     01  (01=Amount,
02=Quantity)
    Tolerance                                 100.00  (Percentage)

    Date for Which to Base Closing                01

      01=Enter     03=Request  05=Last Ship

      02=Schedule  04=Book

    Number of Days Order Should Remain Open      365



Rules for Purging of Orders:

    Date for which to Base Purging                01

      01=Enter     03=Request  05=Last Ship

      02=Schedule  04=Book

    Number of Days to Retain Orders              365



Word of caution:  We tried to use the Last Ship Date and had a disaster -
Drop Ship orders do not have a ship date - with this parameter selected we
lost all of our open drop ship orders!!!

So for our application - When we purge the order entry files the system
first looks at what orders should be closed based on the ordered vs. shipped
quantity tolerance that are within the date of our system parameters.

The system then reviews which of those orders should be purged by the Record
ID and the date parameter that we set.

Version 6.04 also has an option to archive the purged records - we run ours
with this parameter and it creates a EHH and EHL file from ECH and ECL
respectively.  We find this to be a great benefit for querying the older
orders.

 ORD900D       The Wittern Group BPCS V6.0.04 **Test**       ENG02A
1/16/02
 S1039WHM                  Order Purge                       BNORRIS
08:53:35




  Orders will be closed based on the criteria:

      Ordered vs. Shipped Amount tolerance more than 100.00 %

      Orders older than 365 days based on Entered Date

  Orders will be purged based on the criteria:

      Orders older than 365 days based on Entered Date





  Run Option           3 (1=Close Only, 2=Purge Only, 3=Close and Purge)

  Run Mode             0 (0=Edit, 1=Update)

  Archive              1 (0=No 1=Yes)

  Run Time Parameter   1 (0=Interactive 1=Batch)



Good luck - I hope this helps.

Beth A. Norris
Production Control Manager
Fawn Engineering
Des Moines, IA
bnorris@wittern.com



-----Original Message-----
From: Mhamilton8685@aol.com [mailto:Mhamilton8685@aol.com]
Sent: Wednesday, January 16, 2002 8:35 AM
To: bpcs-l@midrange.com
Subject: Re: Cust Orders Completed


--
[ Picked text/plain from multipart/alternative ]
Mac,

Generally speaking, your statement is correct.  I have actually used the
AS/400 CPYF command to purge really old ECH/ECL records (by HEDTE and HID)
with no ill effects.  Check also the ESN and ECS files for corresponding
order data.  There are also three clean up programs (ORD990, INV971 and
SYS990) that I would run after such an action.  This same procedure could be
used for RMA and Quote members.  One concern would be to determine how much
history needs to be kept online for customer service reference.

Records with HID CZ and status 8 are complete and invoiced, status E orders
with HID CZ were deleted before any shipment.

Myron Hamilton


In a message dated 1/15/2002 7:20:54 PM Pacific Standard Time,
MacWheel99@aol.com writes:


> 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
>

_______________________________________________
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.