Re: Closing MOs

Good morning / afternoon to all:

Change the order status code (OSTAT) to "55" on all work orders in the Mfg 
Order Master File (MOMAST), where the LAST ACTIVITY DATE (ASTDT) is less 
than the date that you want.  Then, the MAPICS Order Closeout Selection by 
date option can be used to close the orders and flag them all to be purged 
in the next purge process.

For the sake of the example, if you define that you wants to affect all 
orders where ASTDT is less than 7/11/2008, then we need to update the 
MOMAST file as follows:

UPDATE MOMAST SET OSTAT = ''55'' WHERE ASTDT < 1080711

This will set the order status field to be "55" and the MAPICS Order 
Closeout Selection by date can be used and later the purge process will 
move them all to the history files.


PETER VIDAL
PALL CORPORATION
SR System Analyst | WH Application Development
10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111 
727-844-2414 | Fax: 727-815-3120 | www.pall.com 

"Imagination is more important than knowledge"
Albert Einstein (1879 - 1955)
-- 
--------------------------------------------------------------------------------

Attention:

This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.  
If you are not the intended recipient, please notify the sender 
immediately and delete the original, all attachments, and all 
copies of this communication.


--------------------------------------------------------------------------------

_______________________________________________
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.