Re: Item Revision: finding the latest / current revision (w/o using MAPICS current revision calculation routines)

Peter,

If you're on XAR9, ITMSIT (Item Site) contains the current revision for each item.

HTH,
Matt Qualls
Agility, Inc.



-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter_Vidal@xxxxxxxx
Sent: Tuesday, March 27, 2012 8:30 AM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] Item Revision: finding the latest / current revision (w/o using MAPICS current revision calculation routines)

Good morning / afternoon:

Have the need to determine the latest / current revision for the Item Rev A and also B files. However, these are files from 2007 and 2008. Our user needs to use them in query reports.

There might be a simple solution but is better to ask the question than never asking the question: what can I do to get a file with unique item revision records in a separate file?

TIA,

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.


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