×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
How about the following:
DELETE FROM AMFLIB.ITMPRC WHERE *Insert your logic here*
Or migrate to release 7.8 and you can do a mass delete on ITMPRC within PowerLink.
I know this really isn't what your looking for, but I thought I'd try anyway.
-Tom Stieger
California Fine Wire
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter_Vidal@xxxxxxxx
Sent: Friday, April 15, 2011 8:30 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] How to mass delete ITMPRC records
"Item process records are part of the historical record. they are date effective. If Item Revision or BOM or Routing exists, there will be a record. Deleting them can cause problems with COM, MRP, IM and PCC."
Thanks Kevin for your response: I am aware of your important point as well.
I already have plans of deleting the routers and bills of these items too and I have a routine ready to do these things but I need to delete the item process records as well. If I do not do it, I cannot delete anything else.
(Embedded image moved to file: pic13966.gif) PETER VIDAL PALL CORPORATION SR System Analyst | WH Application Development 10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111
UC#: 262-2414 | Direct: 727-844-2414 | Fax: 727-815-3120 | www.pall.com
"Think like a wise man but communicate in the language of the people."
William Butler Yeats (1865 - 1939)
--------------------------------------------------------------------------------
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 mailing list archive is Copyright 1997-2025 by midrange.com 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
copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.