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@xxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
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@xxxxxxxxxxxx
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@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Peter_Vidal@xxxxxxxx
Sent: Tuesday, March 27, 2012 5: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.
--------------------------------------------------------------------------------
_______________________________________________
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.
midrange.com
