Min/Max values in report

cool, your welcome.



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Tyira Eric [mailto:eric.tyira@...]
Sent: Monday, July 19, 2004 9:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Min/Max values in report


You are so 'da man!

I was using the partwhse table. When I switched to the partplant table, all
the quantities are showing up.

Thanks!

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Monday, July 19, 2004 9:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Min/Max values in report

what tables are you using?
sounds to me like possibly a linking issue.

are you using the part.plant table?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Tyira Eric [mailto:eric.tyira@...]
Sent: Monday, July 19, 2004 9:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Min/Max values in report


Hey all. Running Vantage 6.0; also running Corvu 4.2.

I'm trying to write a report that gives me a list of parts that are stock
with "Min on hand" and "Max on hand" both equal to 0. Sounds easy enough,
so I tap into the part wharehouse table. Grab the minimumqty and maximumqty
and I'm good. But I'm not. All parts come through with min and max equal
to zero regardless of the min/max setting in part master. The reason I know
this is not a Corvu issue is because I get the same result when I run a
Business Activity Query from within vantage.

Has anyone else had this same problem?
Is there a different location for the min/max value I should be looking at?
Is this a technical issue I'm dealing with?

Any help would be appreciated.

Thanks.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://us.ard.yahoo.com/SIG=129a4nbdm/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1090329555/A=2128215/R=0/SIG=10se96mf6/*
http://comp
anion.yahoo.com> click here

<
http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=174277041>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/> .



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views
of the sender and not necessarily the views of the company. The email and
any files transmitted with it are confidential to the intended recipient at
the e-mail address to which it has been addressed. It may not be disclosed
or used by any other than that addressee, nor may it be copied in any way.
If received in error, please delete and notify the sender via e-mail or
sales@... quoting the name of the sender. Messages sent via this
medium may be subject to delays, non-delivery and unauthorized alteration.
This e-mail has been prepared using information believed by the author to be
reliable and accurate. Unless expressly stated otherwise, this e-mail does
not form part of a legally binding contract or agreement between recipient
and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links





Yahoo! Groups Sponsor


ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129vu3js5/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1090330115/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=795379448>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=1298jv2ak/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1090331207/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=585575309>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



[Non-text portions of this message have been removed]
Hey all. Running Vantage 6.0; also running Corvu 4.2.

I'm trying to write a report that gives me a list of parts that are stock with "Min on hand" and "Max on hand" both equal to 0. Sounds easy enough, so I tap into the part wharehouse table. Grab the minimumqty and maximumqty and I'm good. But I'm not. All parts come through with min and max equal to zero regardless of the min/max setting in part master. The reason I know this is not a Corvu issue is because I get the same result when I run a Business Activity Query from within vantage.

Has anyone else had this same problem?
Is there a different location for the min/max value I should be looking at?
Is this a technical issue I'm dealing with?

Any help would be appreciated.

Thanks.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...



[Non-text portions of this message have been removed]
what tables are you using?
sounds to me like possibly a linking issue.

are you using the part.plant table?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Tyira Eric [mailto:eric.tyira@...]
Sent: Monday, July 19, 2004 9:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Min/Max values in report


Hey all. Running Vantage 6.0; also running Corvu 4.2.

I'm trying to write a report that gives me a list of parts that are stock
with "Min on hand" and "Max on hand" both equal to 0. Sounds easy enough,
so I tap into the part wharehouse table. Grab the minimumqty and maximumqty
and I'm good. But I'm not. All parts come through with min and max equal
to zero regardless of the min/max setting in part master. The reason I know
this is not a Corvu issue is because I get the same result when I run a
Business Activity Query from within vantage.

Has anyone else had this same problem?
Is there a different location for the min/max value I should be looking at?
Is this a technical issue I'm dealing with?

Any help would be appreciated.

Thanks.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129a4nbdm/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1090329555/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=174277041>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



[Non-text portions of this message have been removed]
You are so 'da man!

I was using the partwhse table. When I switched to the partplant table, all the quantities are showing up.

Thanks!

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Monday, July 19, 2004 9:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Min/Max values in report

what tables are you using?
sounds to me like possibly a linking issue.

are you using the part.plant table?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Tyira Eric [mailto:eric.tyira@...]
Sent: Monday, July 19, 2004 9:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Min/Max values in report


Hey all. Running Vantage 6.0; also running Corvu 4.2.

I'm trying to write a report that gives me a list of parts that are stock
with "Min on hand" and "Max on hand" both equal to 0. Sounds easy enough,
so I tap into the part wharehouse table. Grab the minimumqty and maximumqty
and I'm good. But I'm not. All parts come through with min and max equal
to zero regardless of the min/max setting in part master. The reason I know
this is not a Corvu issue is because I get the same result when I run a
Business Activity Query from within vantage.

Has anyone else had this same problem?
Is there a different location for the min/max value I should be looking at?
Is this a technical issue I'm dealing with?

Any help would be appreciated.

Thanks.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

< http://us.ard.yahoo.com/SIG=129a4nbdm/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1090329555/A=2128215/R=0/SIG=10se96mf6/* http://comp
anion.yahoo.com> click here

< http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=174277041>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/> .



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links





Yahoo! Groups Sponsor


ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129vu3js5/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1090330115/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=795379448>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service.


[Non-text portions of this message have been removed]