Monthly Archives: May 2016

Getting Vendor addresses based on Address type in AX 2012 R2/R3

The following query gets the vendor addresses  select ROW_NUMBER() over (partition by v.accountNum order by dpl.isprimary desc, lpa.recid) as AddressNumber,v.ACCOUNTNUM,lpa.ADDRESS,llr.NAME from VENDTABLE V  join DIRPARTYLOCATION Dpl on v.party=dpl.party  and dpl.ISPOSTALADDRESS=1  join LOGISTICSPOSTALADDRESS lpa on dpl.LOCATION=lpa.LOCATION    join DIRPARTYLOCATIONROLE dplr on … Continue reading

Posted in Microsoft Dynamics AX | Leave a comment