We gave up on using MTHACT* files for tracking orders or bookings back in '94. 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> To <mapics-l@xxxxxxxxxxxx> cc Subject Re: [MAPICS-L] MAPICS-L Digest, Vol 4, Issue 186 Weston- 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 Estimator/Engineer CFW/Precision Metal Components 805-489-8750 tstieger@xxxxxxxxxx message: 1 date: Wed, 30 Aug 2006 10:32:31 -0600 from: "Weston Wheat" <wwheat@xxxxxxxxxxxxxx> subject: [MAPICS-L] Bookings Data problem ALL We are having problems with our bookings reporting. The MTHACTE continually gets bad data in it that doesn't make sense and is just wrong. I am having to fix 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. But then I point out that we haven't changed the pricing or the quantity for the 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 the 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 numbers? Weston Wheat Information Systems Manager Quality Thermistor Inc 208-377-3373 ext 115 wwheat@xxxxxxxxxxxxxx www.thermistor.com _______________________________________________ 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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.