Newbie BAQ Question

system · August 11, 2009, 3:25pm

Thanks for the feedback!Â I tried this with the PO Master Table with the Buyer ID and Ship Via ID fields but it doesn't link the tables automatically.Â Is this because the fields are in the POHeader Table vs the PODetails Table?Â How do I link the Names in this instance?Â Thanks in advance!!

-Sal

________________________________
From: npbretscher <npbretscher@...>
To: vantage@yahoogroups.com
Sent: Tuesday, August 11, 2009 2:19:55 PM
Subject: [Vantage] Re: Newbie BAQ Question

Â
In the phrase builder, you need two tables:
1. OrderHed
2. Customer

When you click next after adding these two tables in phrase builder, it links them via Company and CustNum.

This then makes all the information available in the customer file (including name) for your BAQ.

--- In vantage@yahoogroups .com, "idiabos" <idiabos@... > wrote:
>
> Hello,
>
> I have a BAQ that pulls from the Order Entry Master. I need to pull the Customer Name but the only thing that is offered is the Customer Number. How does one go about displaying the Customer Name rather than the Customer Number? Thanks!!
>
> -Sal
>

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

system · August 11, 2009, 11:45am

Hello,

I have a BAQ that pulls from the Order Entry Master. I need to pull the Customer Name but the only thing that is offered is the Customer Number. How does one go about displaying the Customer Name rather than the Customer Number? Thanks!!

-Sal

system · August 11, 2009, 11:50am

You will need to connect the CUSTOMER table to the BAQ and link the tables
together on CustNum. Then you can pull the CustID and the Name fields from
the Customer table.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
idiabos
Sent: Tuesday, August 11, 2009 10:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Newbie BAQ Question

Hello,

I have a BAQ that pulls from the Order Entry Master. I need to pull the
Customer Name but the only thing that is offered is the Customer Number.
How does one go about displaying the Customer Name rather than the Customer
Number? Thanks!!

-Sal

------------------------------------

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/linksYahoo! Groups Links

system · August 11, 2009, 11:55am

Thanks Ross - That worked great!

-Sal

________________________________
From: Ross Hughes <ross.hughes@...>
To: vantage@yahoogroups.com
Sent: Tuesday, August 11, 2009 10:50:18 AM
Subject: RE: [Vantage] Newbie BAQ Question

Â
You will need to connect the CUSTOMER table to the BAQ and link the tables
together on CustNum. Then you can pull the CustID and the Name fields from
the Customer table.

Ross

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
idiabos
Sent: Tuesday, August 11, 2009 10:45 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Newbie BAQ Question

Hello,

I have a BAQ that pulls from the Order Entry Master. I need to pull the
Customer Name but the only thing that is offered is the Customer Number.
How does one go about displaying the Customer Name rather than the Customer
Number? Thanks!!

-Sal

------------ --------- --------- ------

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/ linksYahoo! Groups Links

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

system · August 11, 2009, 3:20pm

In the phrase builder, you need two tables:
1. OrderHed
2. Customer

When you click next after adding these two tables in phrase builder, it links them via Company and CustNum.

This then makes all the information available in the customer file (including name) for your BAQ.

--- In vantage@yahoogroups.com, "idiabos" <idiabos@...> wrote:
>
> Hello,
>
> I have a BAQ that pulls from the Order Entry Master. I need to pull the Customer Name but the only thing that is offered is the Customer Number. How does one go about displaying the Customer Name rather than the Customer Number? Thanks!!
>
> -Sal
>