Re: Thoughts RE:COM Order change tracking.

[Trialabyte@xxxxxxx]

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
>