Aaron... perfect! Thank you... That has solved that part.
As for the other, I tried a for each Customer and a "last" command, and
bingo, problem solved...
Thanks everyone...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Thursday, January 05, 2006 12:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Dashboard Query Help
Ben,
To that question...yes...
It's done like this....
Edit the Query to read more like this:
...each ShipTo OUTER-JOIN Where...
That will give you the join you are looking for.
For the rest of the question... I am still thinking on it. Anyone care
to
stop the pain?
Good luck,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Ben Belzer
Sent: Thursday, January 05, 2006 2:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Dashboard Query Help
This goes along with the same question...
Is there a way to do a Left Outer Join in the progress code of a
Dashboard Query?
I want it to show a field even if nothing exists.
Thanks!
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Thursday, January 05, 2006 11:26 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Dashboard Query Help
Sorry... I think I am looking for (a).
Should I run a "last" command in the query to find the last entry?
Thanks!
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ami_miker
Sent: Thursday, January 05, 2006 11:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Dashboard Query Help
Ben,
You might want to refine your definition of "last time purchased".
Do you want a list of customers who
(a) haven't placed a new order in X days.
(b) haven't been shipped to in X days.
(c) haven't been invoiced in X days.
It looks like you are asking for (c), but payment terms might skew
this. I think (a) would be more useful. Give the group a little
more info.
Michael Randolph
American Magnetics, Inc.
As for the other, I tried a for each Customer and a "last" command, and
bingo, problem solved...
Thanks everyone...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Thursday, January 05, 2006 12:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Dashboard Query Help
Ben,
To that question...yes...
It's done like this....
Edit the Query to read more like this:
...each ShipTo OUTER-JOIN Where...
That will give you the join you are looking for.
For the rest of the question... I am still thinking on it. Anyone care
to
stop the pain?
Good luck,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Ben Belzer
Sent: Thursday, January 05, 2006 2:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Dashboard Query Help
This goes along with the same question...
Is there a way to do a Left Outer Join in the progress code of a
Dashboard Query?
I want it to show a field even if nothing exists.
Thanks!
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Thursday, January 05, 2006 11:26 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Dashboard Query Help
Sorry... I think I am looking for (a).
Should I run a "last" command in the query to find the last entry?
Thanks!
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ami_miker
Sent: Thursday, January 05, 2006 11:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Dashboard Query Help
Ben,
You might want to refine your definition of "last time purchased".
Do you want a list of customers who
(a) haven't placed a new order in X days.
(b) haven't been shipped to in X days.
(c) haven't been invoiced in X days.
It looks like you are asking for (c), but payment terms might skew
this. I think (a) would be more useful. Give the group a little
more info.
Michael Randolph
American Magnetics, Inc.
--- In vantage@yahoogroups.com, "Ben Belzer" <bbelzer@t...> wrote:
>
> I am trying to create a dashboard in 6.1 that shows customer's who
> haven't purchased in x days.
>
> Does anyone have any words of wisdom on this one?
>
> The part I am struggling on is the "last time purchased" part.
How can
> I find the newest invoice?
>
> Thanks!!
>
> Ben Belzer
> IT Manager
>
> TCI Precision Metals
> 800.234.5613.W
> 310.323.1255.F
> bbelzer@t... <mailto:bbelzer@t...>
> www.tciprecision.com <http://www.tciprecision.com/>
>
>
>
>
>
>
>
> [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 Links
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 Links
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 Links
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 Links