Ship-to Address Relation to Sales Order

DigitP
DigitP Member Posts: 38
in NAV Three Tier
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

Answers

  • logger
    logger Member Posts: 126
    edited 2017-11-27
    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.
    Let's go!
  • DigitP
    DigitP Member Posts: 38
    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
    logger Member Posts: 126
    @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.
    Let's go!
  • DigitP
    DigitP Member Posts: 38
    Thnx m8. Will try that one

Categories