RE: Thoughts RE:COM Order change tracking.

[LDegnon@xxxxxxxxx]

MAPICS can be "fooled" into thinking that MMA is installed via tailoring 
questionnaire.  When this is done, the MTHACT files are populated.  We use 
this information to generate reports on booking changes daily via IWP 
reports, but obviously could use anything to report on the changes...




"Greg Novak, Momentum" <gnovak@xxxxxxxxxx> 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
02/26/2004 11:42 AM

Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
"'MAPICS ERP System Discussion'" <mapics-l@xxxxxxxxxxxx>
cc

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





_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


ForwardSourceID:NT00019E96