Re: Retaining Completed Orders In Open Order Database

We at Morris created a summary file for both Order headers & line items,
they contained all information the Sales needed to view at the first look,
including order status.  There were several triggers to keep this
information updated.

We have two buttons at the top, one for open & the other for completed.

These would open MAPICS cards that were appropriate.for the order.

----- Original Message ----- 
From: "Morrison, Doug" <dmorrison@xxxxxxxxxx>
To: <MAPICS-L@xxxxxxxxxxxx>
Sent: Monday, October 13, 2003 8:25 AM
Subject: Retaining Completed Orders In Open Order Database


We have MAPICS XA6 on an AS/400 and our customer service department uses
Browser extensively for their order inquires.  The problem we are facing
is when a customer service rep has a customer on the phone who is asking
about their order, the customer service rep has to first look in the
open order object and if the order isn't there then in the order history
object.  Having to make two system inquires is time consuming for both
our customer service rep as well as the customer.

Has anyone else been faced with this problem and how did you solve it?

We are considering a modification to invoicing that would stop completed
orders from being deleted from the open order database (MBC6REP,
MBCDREP, MBADREP, etc) at the time of invoicing.  We would then have a
batch program that would delete the completed orders over 30 days old
from the open order database.  By keeping the completed orders in the
open order database customer service would then only have to inquire
into the open order object in Browser, thus being able to answer the
customer's questions more quickly.

Has anyone made a similar modification or have a better idea of how to
allow customer service to make a more efficient fully functional order
inquiry via browser?

Thanks for your input and thoughts.

Doug


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