Tom,
You are dead on w/ regards to bookings not reflected accurately in
MTHACT.. I've found for shipping and invoicing it is pertty accurate. But
never found this useful for bookings. The complexity of this is the fact a
booking could be a change to an existing order, price, quantity, or
cancellation. Just too many variables not reflected in here. You can
look at the CSM Open order files as far as create dates, at line item and
the order level but this does not reflect changes as well. Also, if an
order is entered and shipped the same day it could be "lost" so you need
to look at the respective shipping order files to identify these to
include in your metrics (so not in one nice place).
In theory one could use the MNHDTL if maintenance history if turned on to
see changes to existing orders and reflect this in your booking numbers on
top of looking at create dates on order/line items. But obviously messy.
I'd love to hear any other ideas people have here. It has always been an
issue. No good way to tap into this w/o some complex rules and
programming.
-------------------------------------------
Kevin Gerard, Senior Technical Consultant
TriMin Systems, Inc. - Infor Channel Partner
[1]kevin.gerard@xxxxxxxxxxxxx
Direct 309-932-3103
Mobile 309-883-1689
[2]www.triminmfg.com
"We are committed to helping manufacturing companies improve their
Visibility, Productivity, Growth and Profitability"
-----mapics-l-bounces@xxxxxxxxxxxx wrote: -----
To: "mapics-l@xxxxxxxxxxxx" <mapics-l@xxxxxxxxxxxx>
From: Tom E Stieger <TEStieger@xxxxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
Date: 09/01/2009 09:59AM
Subject: [MAPICS-L] MTHACTE
In a follow up to a posting a few weeks ago, I was wondering who out
there is using the MTHACT files to track sales activity.
We are attempting to use MTHACTE to track are sales booking activity on
the date of the transaction and keep finding errors in the data.
There seems to be a lot of bugs lately with the updating of these files
through CSM maintenance activities that don't show up when you are doing
the same activity through COM.
What are other people doing to make sure the data is accurate?
Thanks for you input.
-Tom Stieger
Engineer
California Fine Wire
_______________________________________________
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: [3]
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 [4]
http://archive.midrange.com/mapics-l.
References
Visible links
1. mailto:kevin.gerard@xxxxxxxxxxxxx
2.
http://www.triminmfg.com/
3.
http://lists.midrange.com/mailman/listinfo/mapics-l
4.
http://archive.midrange.com/mapics-l
midrange.com
