Antonio,
Yes, MTHACTE is the file. We also added a logical file over MTHACTE to
make query by order # faster.

See DDS below that can be used in a CRTLF command:
*************** Beginning of data
****************************************
A R MTHACT PFILE(MTHACTE)

A TEXT('BOOKING DETAIL')

A K JQCVNB

A K ITNBR

A K TDATE

****************** End of data
*******************************************

I've used this to investigate many questions about who and when changes
were made to Customer Orders.

It's not an easy read, there's lots of data! But a query summarizing by
the key fields above helps to answer questions regarding adding,
deleting items and orders. Also changes to pricing!

Hope this helps,
Ed


-----Original Message-----
From: ARojas@xxxxxxxxxxx [mailto:ARojas@xxxxxxxxxxx]
Sent: Friday, August 22, 2008 12:09 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Who deleted an order?

Ed,

Do you know if the data (booking) is in MTHACTE ?


Antonio Rojas
Manager Applications Development
Semtech Corp.
Cell. (805) 216-4651
Office (805) 480-2135




From:
"Kandel, Ed" <EKandel@xxxxxxxxxxxxxxxxxxxxx>
To:
"MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
Date:
08/22/2008 09:07 AM
Subject:
Re: [MAPICS-L] Who deleted an order?



If you have the booking records option turned on you'll see the negative
values when the order is deleted. A query report by CO# would find out
who deleted.

Ed Kandel

-----Original Message-----
From: Morrison, Doug [mailto:dmorrison@xxxxxxxxxxxxxx]
Sent: Friday, August 22, 2008 11:47 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Who deleted an order?

If you have maintenance logging turned on file MBCICPP will give you the
last person who affected any type of change/delete/add to the order.
You can't really tell what the action was but at least that an action
took place. If you don't have maintenance logging turned on then there
is not audit trail. Maintenance logging is turned on or off by company.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Wyatt
Sent: Friday, August 22, 2008 11:34 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Who deleted an order?

Oops. Never mind me then. Was there any shipping against the order? If
not, then I believe you're out of luck.

Christopher Wyatt
Agility, Inc.
cwyatt@xxxxxxxxxxxxxxx
(216) 403-2837


-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of
Nick_Radich@xxxxxxxxxxxxxx
Sent: Friday, August 22, 2008 10:19 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Who deleted an order?

One of our Customer Service people deleted an order this AM, after she
deleted the Pick, and it does not show up in the Order Header nor the
History file (MBBWCPP).



Thanx,

Nick



Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct (320) 679-6683
Toll free (800) 388-2155 ext. 6683
Fax (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



"Greg Wenzloff" <GWenzloff@xxxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
08/22/2008 10:10 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


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

Subject
Re: [MAPICS-L] Who deleted an order?






If an order is deleted it is no longer in MBC6REP
All is the data is in the historical files. Are any of them reliable
to determine who touched the order last?

Greg

-----Original Message-----
From: Nick_Radich@xxxxxxxxxxxxxx [mailto:Nick_Radich@xxxxxxxxxxxxxx]
Sent: Friday, August 22, 2008 10:58 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Who deleted an order?

Hi Greg,

We are at XAR6, but there are changed date/time/user/program fields in
the header file, MBC6REP.



Thanx,

Nick



Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct (320) 679-6683
Toll free (800) 388-2155 ext. 6683
Fax (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



"Greg Wenzloff" <GWenzloff@xxxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
08/22/2008 09:43 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


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

Subject
[MAPICS-L] Who deleted an order?






Is there a way to determine who deleted a customer order before it was
shipped complete?

COM
XA R4

Thanks,
Greg
_______________________________________________

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

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





This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].