find customer primary address

(0) Share

Report

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)

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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));
}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Community site session details

find customer primary address

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

find customer primary address

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates