Order / Ship BAQ

Which display column would you use to get the total value shipped from OrderDtl?






--- In vantage@yahoogroups.com, "bpbuechler" <pbuechler@...> wrote:
>
> Your key two tables will be OrderRel and ShipDtl
>
> Then link the following tables:
> * ShipDtl to ShipHead - You will need ShipHead to get the Ship Date
>
> * OrderRel to OrderDtl - You may need OrderDtl if you want to
> associate a $ value to the shipment
>
> * OrderDtl to OrderHed - You will need OrderHed to get the CustNum
>
> * OrderHed to Customer - You will need Customer to get the Customer Name
>
> Thanks
> Patty Buechler
>
>
>
> --- In vantage@yahoogroups.com, "Joel Kolling" <jkolling@> wrote:
> >
> > I'm trying to write a BAQ to give me order information and shipping
> > information if the order has shipped. I'm having problems linking the
> > Order and Shipping tables as I can't the Shipping details to come over.
> > Anyone have insight on how to link these together?
> >
> >
> >
> >
> >
> > Joel Kolling
> > IT Manager
> > ITC Manufacturing, Inc.
> > Phone: 602-648-0021
> > Cell: 480-861-2009
> > Fax: 602-415-1444
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
I'm trying to write a BAQ to give me order information and shipping
information if the order has shipped. I'm having problems linking the
Order and Shipping tables as I can't the Shipping details to come over.
Anyone have insight on how to link these together?





Joel Kolling
IT Manager
ITC Manufacturing, Inc.
Phone: 602-648-0021
Cell: 480-861-2009
Fax: 602-415-1444



[Non-text portions of this message have been removed]
(8.03.403) The ShipDtl table has fields for OrderNum, OrderLine, and OrderRelNum. Is that what you are looking for, or is it more complicated than that?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joel Kolling
Sent: Friday, June 26, 2009 7:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Order / Ship BAQ





I'm trying to write a BAQ to give me order information and shipping
information if the order has shipped. I'm having problems linking the
Order and Shipping tables as I can't the Shipping details to come over.
Anyone have insight on how to link these together?

Joel Kolling
IT Manager
ITC Manufacturing, Inc.
Phone: 602-648-0021
Cell: 480-861-2009
Fax: 602-415-1444

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



[Non-text portions of this message have been removed]
Your key two tables will be OrderRel and ShipDtl

Then link the following tables:
* ShipDtl to ShipHead - You will need ShipHead to get the Ship Date

* OrderRel to OrderDtl - You may need OrderDtl if you want to
associate a $ value to the shipment

* OrderDtl to OrderHed - You will need OrderHed to get the CustNum

* OrderHed to Customer - You will need Customer to get the Customer Name

Thanks
Patty Buechler



--- In vantage@yahoogroups.com, "Joel Kolling" <jkolling@...> wrote:
>
> I'm trying to write a BAQ to give me order information and shipping
> information if the order has shipped. I'm having problems linking the
> Order and Shipping tables as I can't the Shipping details to come over.
> Anyone have insight on how to link these together?
>
>
>
>
>
> Joel Kolling
> IT Manager
> ITC Manufacturing, Inc.
> Phone: 602-648-0021
> Cell: 480-861-2009
> Fax: 602-415-1444
>
>
>
> [Non-text portions of this message have been removed]
>