Report Builder - Job Material

Yahoo Archive
1
Do you generate purchasing suggestions from your job material requirements?

Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.504

-----Original Message-----
From: John Meier [mailto:jmeier@...]
Sent: Wednesday, April 14, 2004 4:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Builder - Job Material

We have looked at this, but we have a couple of VB fields we would
like to display. Still looking at other ways to list these materials.

--- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
> Fyi: Have you tried using the 'mtl status' report form within job
tracker -
> it gives you all of this information and is printable.
>
>
> -----Original Message-----
> From: John Meier [mailto:jmeier@n...]
> Sent: Wednesday, April 14, 2004 2:45 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Report Builder - Job Material
>
> I thought I had this covered with the jobmatl.ordered fiels, but
this
> is for future implementation. All I really need to see is material
> that has not been ordered. Any help is appreciated.
>
> John
>
>
> --- In vantage@yahoogroups.com, "John Meier" <jmeier@n...> wrote:
> > Looking for some input on a RB question - I am trying to list all
> job
> > material not received complete, but also material that has not
been
> > ordered. I have a report addressing the first issue, but the
links
> > needed appear to only list parts that have a PO.
> >
> > TIA,
> > John



[Non-text portions of this message have been removed]
2
Looking for some input on a RB question - I am trying to list all job
material not received complete, but also material that has not been
ordered. I have a report addressing the first issue, but the links
needed appear to only list parts that have a PO.

TIA,
John
3
sounds like a left or or outer join is needed on the job material table.



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: John Meier [mailto:jmeier@...]
Sent: Wednesday, April 14, 2004 8:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - Job Material


Looking for some input on a RB question - I am trying to list all job
material not received complete, but also material that has not been
ordered. I have a report addressing the first issue, but the links
needed appear to only list parts that have a PO.

TIA,
John



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


* 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]
4
I thought I had this covered with the jobmatl.ordered fiels, but this
is for future implementation. All I really need to see is material
that has not been ordered. Any help is appreciated.

John



--- In vantage@yahoogroups.com, "John Meier" <jmeier@n...> wrote:
> Looking for some input on a RB question - I am trying to list all
job
> material not received complete, but also material that has not been
> ordered. I have a report addressing the first issue, but the links
> needed appear to only list parts that have a PO.
>
> TIA,
> John
5
Fyi: Have you tried using the 'mtl status' report form within job tracker -
it gives you all of this information and is printable.



-----Original Message-----
From: John Meier [mailto:jmeier@...]
Sent: Wednesday, April 14, 2004 2:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Builder - Job Material

I thought I had this covered with the jobmatl.ordered fiels, but this
is for future implementation. All I really need to see is material
that has not been ordered. Any help is appreciated.

John



--- In vantage@yahoogroups.com, "John Meier" <jmeier@n...> wrote:
> Looking for some input on a RB question - I am trying to list all
job
> material not received complete, but also material that has not been
> ordered. I have a report addressing the first issue, but the links
> needed appear to only list parts that have a PO.
>
> TIA,
> John




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
6
We have looked at this, but we have a couple of VB fields we would
like to display. Still looking at other ways to list these materials.

--- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
> Fyi: Have you tried using the 'mtl status' report form within job
tracker -
> it gives you all of this information and is printable.
>
>
>
> -----Original Message-----
> From: John Meier [mailto:jmeier@n...]
> Sent: Wednesday, April 14, 2004 2:45 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Report Builder - Job Material
>
> I thought I had this covered with the jobmatl.ordered fiels, but
this
> is for future implementation. All I really need to see is material
> that has not been ordered. Any help is appreciated.
>
> John
>
>
>
> --- In vantage@yahoogroups.com, "John Meier" <jmeier@n...> wrote:
> > Looking for some input on a RB question - I am trying to list all
> job
> > material not received complete, but also material that has not
been
> > ordered. I have a report addressing the first issue, but the
links
> > needed appear to only list parts that have a PO.
> >
> > TIA,
> > John
>
>
>
>
> 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