We gave up on using MTHACT* files for tracking orders or bookings back in 

We discovered certain transactions did not trigger proper math, I do not 
recall the specifics,
but I think price changes did not get processed properly, nor did 
reductions.  We also had
difficulty determining if a booking was new because sales liked to delete 
releases and
recreate them rather than changing the original - this gives an 'old' 
release a new create date
which is interpreted as a new booking.  So for brief time in the early 
90's our bookings were inflated.

We had to write our own program based upon comparing the previous day's 
MB* files to the current.

"Tom E. Stieger" <TStieger@xxxxxxxxxx> 
Sent by: mapics-l-bounces+leleux=shur-lok.com@xxxxxxxxxxxx
08/31/2006 10:47 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


Re: [MAPICS-L] MAPICS-L Digest, Vol 4, Issue 186


I have noticed some problems with the MTHACTE file.  We have only been 
using it for about 2 years and I haven't had the time or energy to try and 
start diagnosing and testing where and why the problems are.  A few things 
I have noticed that cause problems are below.

1.  When Sales is changing the order after the parts have been shipped but 
before they have been invoiced.  What this seems to be doing is creating 
the negative trasaction for the total quantity and $$ value.  Then, after 
the change it creates a record with positive quantity for the entire 
amount and postive sales value for only the balance remaining.  This is 
creating a net sales booking decrease by the shipped dollar amount.

2.  Sometimes when creating /changing an order in PowerLink it doesn't 
create the correct MTHACTE records (Usually the sales dollars are blank). 
I have no idea why this sometimes occurs.

-Tom Stieger 
CFW/Precision Metal Components 

message: 1
date: Wed, 30 Aug 2006 10:32:31 -0600
from: "Weston Wheat" <wwheat@xxxxxxxxxxxxxx>
subject: [MAPICS-L] Bookings Data problem

We are having problems with our bookings reporting. The MTHACTE 
bad data in it that doesn't make sense and is just wrong. I am having to 
the data in it on a daily basis. I have talked to Mapics support on this
issue numerous times, as recent as two weeks ago. And the response I get
from them, is that it must of been be a price and/or a quantity change. 
then I point out that we haven't changed the pricing or the quantity for 
order, and yet, there is a MTHACTE entry that either de-books or adds the
dollar amount for a order that hasn't been changed!  Sales, claims that 
order can get de-book in the MTHACTE by just running a inquiry on it.
I just install the latest PCM , level 5132, last weekend. In hopes that
Mapics would have new code for the MTHACTE, but it hasn't help.

What are most companies that are on R7 using to get accurate booking

Weston Wheat
Information Systems Manager
Quality Thermistor Inc
208-377-3373 ext 115

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2021 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.