× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.