Re: Order changes

["Chick Doe" <Cdoe@xxxxxxxxxxxxxxxxxxxxx>]

you might want to consider using triggers on the ECL. we do it and we
record any time an order is entered , maintained, or deleted whenever
the order qty or selling price changes. (ie whenever the backlog value
is affected) the trigger program logs any such changes to a transaction
file. each evening we then use this file to produce order input value
reports.

i think you could use the same technique to capture any changes that
would cause an order to be reprinted and then use the batch program at
night to read the file and reprint the orders.

>>> THarteau@xxxxxxxxxxxxxxxxxx 09/12/03 05:52AM >>>

Hi,
      I am on V6.02. We have a program that prints any new orders taken
out
the previous day and also any changes made to existing orders. It is a
batch program that compares entry date and last maintained date to a
record
in a work file. If it is different, there has been a change (in item
number, quantity, price, salesperson or customer). The programs were
written when we first got BPCS many, many years ago. It was maintained
to
keep working, but has some serious holes.  I need to rewrite it without
the
holes.  Some of the problems are: the work file is keyed by order #,
line #
(the item number can and does change), but we have had users resequence
the
order, We have had lines deleted, and L01 was used, so it was never
reduced, and several unexplained things where it just did not update
correctly.
      Does anyone have any ideas on how to track the changes? I'm not
looking for any product to purchase, it is home grown and needs to
stay
that way. I am just starting to look at different ways to do it, and
thought I would see if anyone else is already doing something similar.

<===================================================>

Terri Harteau
****************
"There's no point in being grown up if you can't be childish
sometimes."
- Dr. Who
****************






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