Crystal Question - Customer Ship to address list

This did it. I had all the tables just not the correct links. Thank you all!


Melissa Hietala
UMC, Inc.
melissah@...


________________________________
From: mattcald_73 <matt@...>
To: vantage@yahoogroups.com
Sent: Thursday, June 14, 2012 9:40 AM
Subject: [Vantage] Re: Crystal Question - Customer Ship to address list


Â

That ShipToNum in customer only lists the Primary ship to. Link the ShipTo table to OrderHed, then ShipTo to Customer(if needed)

--Matt

--- In vantage@yahoogroups.com, melissa hietala <kevmel822@...> wrote:
>
> We have some customers that have multiple ship to addresses and I want to print a shipments report that show the order, customer, ship via, ship to code, and the appropriate address that goes with that ship to code. It will only return the main address information not the ship to address information. I have the following tables:
> Â
> OrderHed
> OrderDtl
> OrderRel
> ShipVia
> Customer
> ShipTo
> Â
> I have the first 4 linked together and then OrderHed to Customer to ShipTo
> Â
> I feel like I am just this close but can't get that correct address to populate. Any ideas?
> Â
> Thanks
> Â
> Melissa Hietala
> UMC, Inc.
> melissah@...
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
We have some customers that have multiple ship to addresses and I want to print a shipments report that show the order, customer, ship via, ship to code, and the appropriate address that goes with that ship to code. It will only return the main address information not the ship to address information. I have the following tables:
Â
OrderHed
OrderDtl
OrderRel
ShipVia
Customer
ShipTo
Â
I have the first 4 linked together and then OrderHed to Customer to ShipTo
Â
I feel like I am just this close but can't get that correct address to populate. Any ideas?
Â
Thanks
Â
Melissa Hietala
UMC, Inc.
melissah@...

[Non-text portions of this message have been removed]
You're using OrderHed.ShipToNum, right? That will relate to
ShipHead.ShipToNum also. If I recall correctly the only caveat is: If
there is only ONE ship to for that customer, ShipTo.ShipToNum is null. Bad
design, IMO.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
melissa hietala
Sent: Thursday, June 14, 2012 10:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Question - Customer Ship to address list





We have some customers that have multiple ship to addresses and I want to
print a shipments report that show the order, customer, ship via, ship to
code, and the appropriate address that goes with that ship to code. It will
only return the main address information not the ship to address
information. I have the following tables:

OrderHed
OrderDtl
OrderRel
ShipVia
Customer
ShipTo

I have the first 4 linked together and then OrderHed to Customer to ShipTo

I feel like I am just this close but can't get that correct address to
populate. Any ideas?

Thanks

Melissa Hietala
UMC, Inc.
melissah@... <mailto:melissah%40ultramc.com>

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



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2180 / Virus Database: 2433/5069 - Release Date: 06/14/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2180 / Virus Database: 2433/5069 - Release Date: 06/14/12

[Non-text portions of this message have been removed]
That ShipToNum in customer only lists the Primary ship to. Link the ShipTo table to OrderHed, then ShipTo to Customer(if needed)

--Matt

--- In vantage@yahoogroups.com, melissa hietala <kevmel822@...> wrote:
>
> We have some customers that have multiple ship to addresses and I want to print a shipments report that show the order, customer, ship via, ship to code, and the appropriate address that goes with that ship to code. It will only return the main address information not the ship to address information. I have the following tables:
> Â
> OrderHed
> OrderDtl
> OrderRel
> ShipVia
> Customer
> ShipTo
> Â
> I have the first 4 linked together and then OrderHed to Customer to ShipTo
> Â
> I feel like I am just this close but can't get that correct address to populate. Any ideas?
> Â
> Thanks
> Â
> Melissa Hietala
> UMC, Inc.
> melissah@...
>
> [Non-text portions of this message have been removed]
>