bojensen: Getting addresses by type X++ | Microsoft Dynamics AX & CRM | AXPulse

[Blog bot]

Источник: http://blogs.bojensen.eu/2015/01/13/...x-crm-axpulse/
==============

This post shows the code which helps in retrieving the address of Party (Customer, Vendor etc.) by providing the type of addresses. Function which takes Party and LogisticsLocationRoleType (Invoice, Delivery, Shipping etc.)

public static LogisticsPostalAddress getPostalAddressByType(DirPartyRecId _party, LogisticsLocationRoleType _type)
{
    DirPartyLocation        partyLocation;
    DirPartyLocationRole    partyLocationRole;
    LogisticsLocation       location;
    LogisticsLocationRole   locationRole;
    LogisticsPostalAddress  postalAddress;
    ;
    select firstonly postalAddress
    exists join location
        where location.RecId == postalAddress.Location
    exists join locationRole
        where locationRole.Type  == _type
    exists join partyLocation
        where partyLocation.Location == location.RecId 
        && partyLocation.Party == _party
    exists join partyLocationRole
        where partyLocationRole.PartyLocation == partyLocation.RecId 
        && partyLocationRole.LocationRole == locationRole.RecId;

    return postalAddress;
}

Источник: http://blogs.bojensen.eu/2015/01/13/...x-crm-axpulse/