My solution to the mysterious mthacte errors:

1. I created a file to populate the daily booking = Current days backlog - Previous days backlog + Shipped items value. This file basically captures all of the info from COM->Inquiry->Daily Status plus some custom stuff for our business.

2. I created a logical file to show net changes per line item per day from MTHACTE. If there were date changes but no quantity or price changes within a day then the SQL view does not show them.

3. I e-mail two text based reports from these two files.

4. I compare the calculated booking (i.e. what it should be) with the total booking from MTHACTE.

5. When there is an error I change the Net sales amount in the MTHACTE file to what it should be. I have integrated these files to make this very easy.

Currently we our main issue is with some orders where we have a remaining quantity in the last release (ie 12500 FT due 12/29/11) that gets changed to the next requested shipment (2500 FT due 12/14/10) and a new release gets created for the balance (10000FT due 12/29/11).

-Tom Stieger
California Fine Wire

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Kevin Mann
Sent: Thursday, December 09, 2010 1:41 PM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] MTHACTE net sales not always correct

I thought I was the only one that had this problem? Infor told me that they couldn't recreate the problem when I created an incident.

I am on 7.7 and it does not occur too often anymore, but still happens occasionally. This has always been an issue. We were using a copy of MTHACTV that would be copied to history before month end. When we moved to rel 7.7 I wrote a report against MTHACTE. We compare the booked dollars and quantities on a daily basis between the 2 reports. It was off quite a bit at the beginning. A lot of the problems were due to older orders that were started on the older release.

I also have sales people who insist on using green screen order maintenance for their inquiries which also causes issues.

I do know that price changes on the blanket orders are a problem with MTHACT. Our users have been instructed to delete the item and re add it to the order if they are going to do a price change. This may be why you are having problems on the blanket orders.


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,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at

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-2022 by 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.