Share your Success!

[TRIXIE]

We need to find customers with ship to's in CT, while the main bill to is a different state.  I can not find the database for all the information you enter under customer maintenance, click the drop down for Ship to Address.  We want to do a mailing/faxing to all the CT customers. I did find the SO_ShipToAddress database..Does this have all the info that was entered under the customer maintenance module or is it just sales oders that have been processed with a ship to.  Example under customer maintenance there is a ship to, but customer has not placed a sales order with us yet.

Thank you,

Trixie

[SPyle]

You probably won't get the answer here either.   You should post this in the distribution discussion board.

You can check if the SO_ShipToAddress has what you are looking for by opening the file through Excel Data/Data/Import and reviewing the records.  (Add a ship to to a customer you know didn't get a SO and it should help you find the answer.

Message Edited by SPyle on 02-03-2010 02:24 PM

[TRIXIE · Accepted solution]

Thank you I did repost this and received a response that helped me obtain the information I needed.

Again thank you for your help in the matter.

Trixie