Re: How to mass delete ITMPRC records

Peter-

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.


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