Hello All,
I need put the Vendor's information about tel, fax, email (primary) in SSRS report.
I just can use AX 2012 AOT Query, please help and thank you.
I use SQL：
select P.PURCHID,P.ORDERACCOUNT,P.PURCHNAME,V.TAXGROUP,V.PAYMTERMID,V.CURRENCY, Max (case when D.PRIMARYCONTACTPHONE = LA.RECID then LA.LOCATOR else '' end) as 'Phone',Max (case when D.PRIMARYCONTACTFAX = LA.RECID then LA.LOCATOR else '' end) as 'Fax',Max(case when D.PRIMARYCONTACTEMAIL = LA.RECID then LA.LOCATOR else '' end) as 'Email'
from PURCHTABLE as P join ( VENDTABLE as V join ( DIRPARTYTABLE as D join LOGISTICSELECTRONICADDRESS as LA on D.RECID = LA.PRIVATEFORPARTY ) on V.PARTY = D.RECID ) on P.ORDERACCOUNT = V.ACCOUNTNUM
Group by P.PURCHID,P.ORDERACCOUNT,P.PURCHNAME,V.TAXGROUP,V.PAYMTERMID,V.CURRENCY
order by P.PURCHID
Br, Jen
*This post is locked for comments
I have the same question (0)
