I currently do this by calling a line of SQL each night, just to change the batch status to C if it is S, or A (not current date). It works fine and I have had no problems. David. -----Original Message----- From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Marc.Rohde@xxxxxxxxxxxxxxxx Sent: 26 July 2006 18:12 To: MAPICS-L@xxxxxxxxxxxx Subject: [MAPICS-L] Programmatically closing inventory batches Every night we have an operator go through suspended batches and close them through the Mapics interface and DFU active batches that are hung to suspend them to allow them to be manually closed. What problems would I face if I wrote a program to change the batch status on all suspended or "hung active" batches to closed? Following the change I would run the transaction register as usual to get the to finished status. Your feedback is appreciated, Marc Rohde IT Manager Pentair Filtration, Inc. & Everpure, LLC Confidentiality Note: This e-mail message and all attachments to it are intended only for the named recipients and may contain confidential information. If you are not one of the intended recipients, please do not duplicate or forward this e-mail message and immediately delete it from your computer. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________ 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.