Finance | Project Operations, Human Resources, ...

Customer address through code in AX 2012 r3

(0) Share

Report

Posted on by @rp@n

2627.A2.jpg

i wrote below code to display address of customer, BUT it's not printing the "Japan"

while select AccountNum,party from custTable where custTable.AccountNum == customerCode
    {
        if(custTable)
        {
            party       = custTable.Party;
            description = DirParty::primaryPostalAddress(party).displayLocationDescription();
            address     = DirParty::getPostalAddressByType(party, LogisticsLocationRoleType::Delivery);

            // phone -- customer
            logisticsElectronicAddress = DirParty::primaryElectronicAddress(party, LogisticsElectronicAddressMethodType::Phone);
            if(logisticsElectronicAddress)
            {
                locator = logisticsElectronicAddress.Locator;
            }

            // fax -- customer
            logisticsElectronicAddress2 = DirParty::primaryElectronicAddress(party, LogisticsElectronicAddressMethodType::Fax);
            if(logisticsElectronicAddress2)
            {
                locator2 = logisticsElectronicAddress2.Locator;
            }

        }
    }

Output

6076.report2.jpg

Please give me more shed on this.

thanks!

All responses (6)

Answers (0)

WillWU 22,352 on at

Like (0)

Report

RE: Customer address through code in AX 2012 r3

Hi @rp@n,

Where is your code to output the address? I can't find it.

This line will return the Delivery address of your customer. DirParty::getPostalAddressByType(party, LogisticsLocationRoleType::Delivery)

Have you used a placeholder somewhere? I suggest you print out the address directly and check it.

Hope this helps.
Suggested answer

Sukrut Parab 71,682 Moderator on at

Like (0)

Report

RE: Customer address through code in AX 2012 r3

If you debug and see you are getting full value in your address variable its a problem where you are printing it. How /Where do you printing your output ?
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Customer address through code in AX 2012 r3

Arpan,

Were you able to resolve this issue?
Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report
RE: Customer address through code in AX 2012 r3

There is nothing wrong with this call. You may want to check the data in LogisticsPostalAddress Table.

An alternative could be to write your own method -

public static Addressing getPostalAddressByType(DirPartyRecId _party, LogisticsLocationRoleType _type) { DirPartyLocation partyLocation; DirPartyLocationRole partyLocationRole; LogisticsLocation location; LogisticsLocationRole locationRole; LogisticsPostalAddress postalAddress; select firstonly postalAddress exists join location where location.RecId == postalAddress.Location exists join locationRole where locationRole.Type == _type//LogisticsLocationRoleType::Invoice exists join partyLocation where partyLocation.Location == location.RecId && partyLocation.IsPrimary == NoYes::Yes && partyLocation.Party == _party exists join partyLocationRole where partyLocationRole.PartyLocation == partyLocation.RecId && partyLocationRole.LocationRole == locationRole.RecId; return postalAddress.Address; }

Also, it looks like you are trying to get the Delivery address for a sales order. Can you not use the SalesTable\deliveryAddress method?
@rp@n 18 on at

Like (0)

Report
RE: Customer address through code in AX 2012 r3

select salesInvoiceHeaderFooterTmp; salesInvoiceHeaderFooterTmp.Address = address; salesInvoiceHeaderFooterTmp.insert();
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Customer address through code in AX 2012 r3

Hi Arpan,

It is not sure from your code which field you are choosing to display address.

Can you share the entire code that you are using?