web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / find customer primary ...
Microsoft Dynamics AX (Archived)

find customer primary address

(0) ShareShare
ReportReport
Posted on by RT10 780

How do i find a customer's primary address? I tried it two different ways. The code didn't even compile both ways, so I commented the lines.

static void Jobxx_findprimaryAddress(Args _args)
{

    CustTable custTable;
    DirPartyTable dirPartyTable;
    DirPartyAddress dirPartyAddress;

    ;

    custTable = CustTable::find("ABCD", false);

//first way
    //dirPartyAddress = dirPartyAddress::findPrimaryAddress(custTable.PartyId);

// second way    
    dirPartyTable = DirPartyTable::find(custTable.PartyId);
    //dirPartyAddress = dirPartyAddress::findPrimaryAddress(dirPartyTable.PartyId);
   
    info(strFmt("Street: %1", dirPartyAddress.parmStreet());

}

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    try this...

    static void FindPrimaryAddress(Args _args)
    {
        CustTable       custTable;
        Address         primaryAddress;
        ;

        custTable = CustTable::find("ABCD", false);

        //first way
        primaryAddress = dirPartyAddress::findPrimaryAddress(custTable.PartyId);
      
        info(strFmt("Street: %1", primaryAddress.Street));
    }

    your only problem was that findPrimaryAddress returns Address, not DirPartyAddress

  • Community Member Profile Picture
    Community Member on at

    This job works in DAX 2009:

    static void FindPrimaryAddress(Args _args)
    {
        utcDateTime                         dateTimeNow = DateTimeUtil::utcNow();
        CustTable                           custTable;
        DirPartyAddressRelationship         dpar;
        DirPartyAddressRelationshipMapping  dparm;
        Address                             address;
        ;

        select firstfast firstonly custTable;

        
        select firstfast firstonly dpar
            where   dpar.PartyId            == custTable.PartyId
                &&  dpar.Status             == DirPartyAddressRelationshipStatus::Active
                &&  dpar.ValidFromDateTime  <= dateTimeNow
                &&  dpar.ValidToDateTime    >= dateTimeNow
                &&  dpar.IsPrimary          == NoYes::Yes;
               
        select firstfast firstonly dparm
            where   dparm.PartyAddressRelationshipRecId == dpar.RecId;
           
        select firstfast firstonly address
            where   address.RecId   == dparm.AddressRecId;
           
        info(strFmt('Primary address for %1 is %2', custTable.Name, address.Address));
    }

  • Community Member Profile Picture
    Community Member on at

    Mr. Andrew W Ford has submitted the best way of getting primary address here. Mr. Fords suggestion by far out performs the DirPartyAddress::findPrimaryAddress method.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans