Peter.
We had the same problem here.   I wrote a program that runs nightly to 
check the revision file against the release file and list any possible 
errors for engineering to check,
If you are relying on the old item master files, the file ITMREL is used 
by Mapics.  I know it affects the costing.  I had to get it corrected 
because of costing. 
I don't know if you own the source, but looking at the knowledge base 
AMDFEIOR retrieves the current item revision and AMDFEP0R retrieves the 
current item process record.
Diane
From:   Peter_Vidal@xxxxxxxx
To:     MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Date:   03/27/2012 10:15 AM
Subject:        Re: [MAPICS-L] Item Revision: finding the latest / current 
revision        (w/o using MAPICS current revision calculation routines)
Sent by:        mapics-l-bounces@xxxxxxxxxxxx
"We are at release 6 and release items to PDM, therefore I use ITMREL to 
get the current item released, then get the item process for that item to 
look up BOM's or routings."
I also thought about using that table but I already found out that during 
these years, people were learning about the "release to PDM" function and 
sometimes they released revisions to PDM that they should not have.  In 
many cases, revisions that were not the current ones.
They have better discipline today but due to the historical facts, taking 
that route will not inspire me too many hopes to have accurate info.
Thank you for the tip though! 
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 
"When a man's knowledge is not in order, the more of it he has the greater 
will be his confusion." 
Herbert Spencer (1820 ? 1903) 
--------------------------------------------------------------------------------
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@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.
This message and any files transmitted with it contain privileged and confidential information. This message is intended only for the use of the individual or entity to whom it is addressed. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, copying, or exploitation of, or taking any action in reliance on the contents of this message is strictly prohibited. If you have received this message in error, please notify the sender by email reply and delete this message from your system. Thank you. 
As an Amazon Associate we earn from qualifying purchases.