Customer Address Query

(0) Share

Report

Posted on by Cole Pearson

I'm new to AX2012 and don't know how to create a report that lists every address associated with a customer, including the address mailing or delivery. Currently, I have only been able to pull in a list of the customer’s primary address, but I also need to know their delivery address. Thanks for any suggestions.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

nunomaia 25 Moderator on at

Like (0)

Report
Use a similar query to get all addresses

select postalAddress exists join partyLocation where partyLocation.Location == postalAddress.Location && partyLocation.Party == CustTable.Party;

Was this reply helpful? Yes No