Steve-
We are at r7.8.
It should exist in the AMFLIBx library (not AMALIB where I first thought to look) and the source for it should be in AMXLIB/QFUNCTSRC.
-Tom
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Shurge, Stephen (MTL)
Sent: Tuesday, March 27, 2012 7:53 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Item Revision: finding the latest / currentrevision (w/o using MAPICS current revision calculation routines)
Tom the GETCURRVA must be an internal created command because I have R7 and R9 environments on my system and the is no such command in either R7 or R9.
If it is an internal command I would be interested in seeing what you created.
Steve
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom E Stieger
Sent: Tuesday, March 27, 2012 10:40 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Item Revision: finding the latest / current revision (w/o using MAPICS current revision calculation routines)
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 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.
midrange.com
