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

Peter,

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.






From:   "Tom E Stieger" <testieger-7y5+ka1ulstWk0Htik3J/[email protected]>
To:     "MAPICS ERP System Discussion" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]>
Date:   03/27/2012 09:40 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-Zwy7GipZuJhWk0Htik3J/[email protected]



Peter-

Can you use the GETCURRVA function (I'm not sure if that is available in 
r6)?  If you need to get the current revision as it was in 2007 - 2008 
then it shouldn't be that hard to use System I Navigator's "explain SQL" 
on the function to get the source then modify it with a date parameter and 
rename it something useful.  This could then be used in your query tool if 
allowed or used to create the desire temporary table or view as applicable 
to your needs.


-Tom Stieger
IT Manager
California Fine Wire




-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] 
On Behalf Of Peter_Vidal-/[email protected]
Sent: Tuesday, March 27, 2012 5:30 AM
To: mapics-l-Zwy7GipZuJhWk0Htik3J/[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: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.