Re: MTHACTE: How to detect if record is due to a cancellation?

We have a custom booking analysis program that runs nightly comparing 
MTHACTE against
yesterday's version.

It's a very complex program, it tracks new bookings, versus changes and 
deletes.
It doesn't get fooled when sales deletes a release and re-enters - instead 
of just
changing the date!  It won't get fooled by combining releases, or 
staggering them.

Really, all the things MAPICS should do out of the box - included with 
COM!






"Peter Vidal" <Peter_Vidal@xxxxxxxx> 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
03/10/2004 06:11 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
mapics-l@xxxxxxxxxxxx
cc

Subject
MTHACTE: How to detect if record is due to a cancellation?






Team, this is the challenge:

I was in a brief IT Meeting this morning and we discussed a specific task, 

part of a big project.  They have a trigger in MTHACTE that creates 
history records in an in-house booking history file.  The opportunity here 

is to be able to identify when the incoming MTHACTE record is a 
cancellation or not.

How you handle this?

TIA, 
Peter Vidal
Pall Aeropower Corp. 
SR Programmer Analyst
WWW.Pall.com  
"My religion consists of a humble admiration of the illimitable superior
spirit who reveals himself in the slight details we are able to perceive 
with our frail and feeble mind."
Albert Einstein
 
_______________________________________________
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.