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!

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Gunjan Bhattachayya 35,429 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!
select salesInvoiceHeaderFooterTmp; salesInvoiceHeaderFooterTmp.Address = address; salesInvoiceHeaderFooterTmp.insert();

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,429 on at

Like (0)

Report
Copy link

Link copied!
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?

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,429 on at

Like (0)

Report
Copy link

Link copied!

Arpan,

Were you able to resolve this issue?

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,741 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
WillWU 22,363 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No