Re: MTHACTE net sales not always correct

Update to the problem (first reported in Dec.):   After seeing the info from Ed Kandel in March (thanks Ed!) we turned on the API UMBCOD5R to automatically update order qty  to match the sum of the blanket releases. We found there were fewer booking errors, but there is still a significant number of errors, particularly for one customer's blanket orders. The customer's orders are updated via offline load. Infor tech support at first could not recreate the problem. Last week they confirmed that there is a problem when adding additional releases to existing blanket orders (that have shipped qtys against previous releases) via offline load. Our internal audits discovered that the shipped qty is removed from the order total (CDACQT) . However, Tech Support says that because there is a work aro
 und they are not issuing an APAR. The work around is use  System-Link, as apparently it  works correctly in this situation. However, we do not have System Link, so that helps me not at all.!
  I am going to implement a fix-the-bad-data program that will run immediately after the off-line load. Not the cure I was hoping for, but at least we can now put an end to the incorrect MTHACTE bookings records.
This electronic message transmission is intended only for the use of the party to which it is addressed, including any attachments and contains information from AeroControlex Group Inc., which may be privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this e-mail or its contents is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ITAR Notice: This email may contain technical data which may be controlled by the US International Traffic in Arms Regulation (ITAR) 22 CFR part 120-130. If this data is determined to be ITAR controlled, such data may not be transmitted, sha
 red or provided to any foreign party or entity either verbally or visually without proper licenses from the State Department. It is your responsibility to assure this item can be legally sh!
 ared with another party.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.