You can join the OrderHed table directly to the ShipTo table, link using the Company, CustNum and ShipToNum fields for the shipto address selected on the sales order.
However, this assumes an shipto is chosen for each order... if you use one-time shipto addresses, you'll need to look in the OrderHed table at the fields like OTSAddress1 etc, and there may not be a valid link to the ShipTo table.
Brian.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jfmartin67
Sent: Tuesday, April 03, 2012 5:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: need field to trigger ONLY sales orders with international ship to addresses
when i try to set up
orderhead --> customer ---> ship to
i only seem to be able to select 'first' for the ship to records, which means that it only selects the original customer's address, not the actual ship to address associated with the order.
when i select 'each' at the ship to records, the baq gets hung and doesn't complete
However, this assumes an shipto is chosen for each order... if you use one-time shipto addresses, you'll need to look in the OrderHed table at the fields like OTSAddress1 etc, and there may not be a valid link to the ShipTo table.
Brian.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jfmartin67
Sent: Tuesday, April 03, 2012 5:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: need field to trigger ONLY sales orders with international ship to addresses
when i try to set up
orderhead --> customer ---> ship to
i only seem to be able to select 'first' for the ship to records, which means that it only selects the original customer's address, not the actual ship to address associated with the order.
when i select 'each' at the ship to records, the baq gets hung and doesn't complete
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jonathan Lang <lsbestinc@...> wrote:
>
> Yes, Karen is correct. Orderhead --> Customer --> ShipTo
>
> Jonathan
>
>
>
> ________________________________
> From: Karen Schoenung <kschoenung@...>
> To: "vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> " <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
> Sent: Tuesday, April 3, 2012 9:15 AM
> Subject: RE: [Vantage] need field to trigger ONLY sales orders with international ship to addresses
>
>
> Â
> 2 - I think you need OrderHed to Customer table to ShipTo table...(company and customer..., company,customer, shipto...)
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of jfmartin67
> Sent: Tuesday, April 03, 2012 8:35 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] need field to trigger ONLY sales orders with international ship to addresses
>
> i've tried to develop a dashboard (and method directive) that needs to show only sales orders that have international ship to addresses (but in many cases the original customer address is not international).
>
> i can't seem to figure how to either:
>
> 1) find a field to use (from OrderHed table) that would designate an international ship to address, or
>
> 2)how to tie the ShipTo table to OrderHed or OrderDtl so i could use a field in ShipTo table.
>
> thoughts?
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]