Ship-to Address Relation to Sales Order

DigitP

Hi there,

Im trying to get an XML output (working fine) but only got 1 problem.
When an Sales order has an Alternative address i want the phonenumber and Email given in this field to export in my XML.
As far as i can see, de Sales header has ship-to some stuff ... but no email / phone number. When i make a link with the table 222 (ship-to address) i only
can make a link field with customerno and not with Sales Header DocumentNo.

Any body knows what im doing wrong ?
Thnx

logger

Hi @DigitP ,
You do everything right. Ship-To Addresses is only addresses e.g. if customer has wide shop network. To save contact info (phone, e-mail) you should use Contacts, and you can use them on sales header as well.
Also you can easily add appropriate fields (phone, e-mail) in table 222 if you wish to use it in xml output.

DigitP

Hi Logger,

Thnx for your awnser, but Alternative shipping adres gives me the option to give a 1 time email and phone number ? so its weard you cant get to it !

logger

@DigitP ,
sorry but that's will of Microsoft. But again you can use Contacts, and create as many related alternative contact addresses (it is table 5051) as you wish. Hope, it will help.

DigitP

Thnx m8. Will try that one