Below is the piece of code to get customer address by type in AX/D365 X++
select firstonly postalAddress
return postalAddress;
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;
}
Thanks for sharing this helpful code snippet! Getting customer addresses by type in D365 is often tricky, but this method simplifies it nicely. For anyone working with controllers on Windows, don’t forget to check out the betterjoy download tool it’s great for seamless Nintendo Switch controller support. Keep the great content coming!
ReplyDelete