RE: Thoughts RE:COM Order change tracking.

How about the MTHACTE file?  This records a number of fields every time an
order is changed.  It is (was) used by MMA to adjust dimensions for order
changes.  Not sure if this is always built or only if MMA installed.  Can
get lots of records but may be a simple solution if it has the fields you
need to track.

Regards,
-Greg

Gregory Novak
Manager North American Technical Services
Momentum Utilities Pty Ltd
(630) 985-1736
gnovak@xxxxxxxxxx
www.jacana.com
 
Making Information Work for your Business
www.intuator.com


-----Original Message-----
From: Trialabyte@xxxxxxx [mailto:Trialabyte@xxxxxxx] 
Sent: Thursday, February 26, 2004 7:46 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: Thoughts RE:COM Order change tracking.


Dear Meyno
To track customer (COM) order changes this is what I would do....

Use the End Customer Order exit to write all or your required order data to
a 
history file, this takes place when an order is entered and subsequently 
updated. For example if you require to keep a track of the price, quantity
and 
customer due date of the order item lines you write those fields to a record
and 
write the record along with the order number, order type, company and order 
item seq number to the history file.
You then have a copy of the order when it is added and maintained, your 
chosen program can then process the history file to do whatever you need to
do with 
the before image.

Quite straightforward no need to cause headaches with triggers!

Best regards
Rob Cull
Independent (hands on) MAPICS / AS400 / RPG Consultant in the UK.




In a message dated 2/25/04 08:18:11 GMT Standard Time, 
meyno@xxxxxxxxxxxxxxxxxx writes:


> > -----Original Message-----
> > From: meyno [mailto:meyno@xxxxxxxxxxxxxxxxxx]
> > Sent: Wednesday, February 25, 2004 12:05 PM
> > To: MAPICS-L SUBMIT
> > Subject: Thoughts RE:COM Order change tracking.
> >
> >
> > I may have to start drinking again, my sales department is at it again.
> >
> > They want to track 90% of all changes to a customer order, with before &
> > after fields. Some of the changes will need to be printed on the new
> "PICK".
> >
> > I've looked at MAPICS Customer Maintenance tracking, but it does not
have
> > before & after data.
> >
> > I may have to play with triggers.
> >
> > Any thoughts would be appreciated.
> >
> > Thank
>