Well, what we do for this at FFT is a long time ago, I purchased the
OEGLI/MTHACT add-on ($500? Not sure anymore). The MTHACTX (invoice
header), MTHACTY (invoice line item detail), and MTHACTX (special charge
detail) files are all loaded at invoicing time. I use that data daily to
feed out sales force information databases, that we pump out to the
Regional Sales Managers using Lotus Notes databases (and Lotus Enterprise
Integrator). I have found that to be a VERY effective methodology. And
it's simple and relatively inexpensive.
And you don't need triggers.... which I don't particularly like (and let's
NOT get that thread started again!!! LOL!!! The LAST time was my fault
for asking!)
Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA 15501
Chris.Neely@matsc
i.com
Sent by: To
mapics-l-bounces@ mapics-l@xxxxxxxxxxxx
midrange.com cc
Subject
12/10/2007 01:26 [MAPICS-L] Capturing sales data to
PM feed data warehouse
Please respond to
MAPICS ERP System
Discussion
<mapics-l@midrang
e.com>
Can anyone tell me where is the best place in the process/system to
capture sales data that we will then feed into a data warehouse? Should I
capture the data when it hits OEITXN using the user exit or trigger? I am
sure others have done this already. I would appreciate it if someone could
point me in the right direction to using the best method to accomplish
this.
Thanks for any assistance.
Note: I am at release 7.7 of XA using IFM.
_______________________________________________
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.
midrange.com
