Re: Item Revision: finding the latest / current revision (w/o using MAPICS current revision calculation routines)
Matthew Qualls <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
Peter, If you're on XAR9, ITMSIT (Item Site) contains the current revision for each item. HTH, Matt Qualls Agility, Inc. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, March 27, 2012 8:30 AM To: [email protected] 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. -------------------------------------------------------------------------------- _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: [email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.