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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / how get the Logistics ...
Microsoft Dynamics AX (Archived)

how get the Logistics Electronic Address Table Description Field Based On the Purch Id and Vend Accountnum

(0) ShareShare
ReportReport
Posted on by srinivas pamidi 1,737

Currently I am Working on the Purchase order Confirmation Report(Morphx).

I need to fetch the Description in the Vendor Address Form ->contact Information->description

It is There in the Logistics Electronic Address Hoe to get this Field in the Purchase order Report.

what is the Relation Between the PurchID Vend Accountnum and Logistics Electronic Address Table.

Please Help Me.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    jasman Profile Picture
    jasman 1,413 on at
    RE: how get the Logistics Electronic Address Table Description Field Based On the Purch Id and Vend Accountnum

    The following x++ code can find the primary postal address of a vendor:

    static void Job189(Args _args)
    {
        DirParty        dirParty;
        LogisticsPostalAddress   lpa;
       
        VendTable       vendor;
       
        vendor = VendTable::find("‪‪‪143040‬‬");
        dirParty = dirParty::constructFromCommon(vendor);
        lpa = dirParty.getPrimaryPostalAddressLocation().getPostalAddress();
        info(lpa.Address);
    }

  • srinivas pamidi Profile Picture
    srinivas pamidi 1,737 on at
    RE: how get the Logistics Electronic Address Table Description Field Based On the Purch Id and Vend Accountnum

    Hi

    Thanks for your Response.

    I am Writing this Below code in the Fetch Method But it is Not Working

    while select firstOnly10 * from vendTable

       join dirPartyLocation where vendTable.Party == dirPartyLocation.Party

       join purchTable

       where purchTable.PurchId == _vendPurchOrderJour.PurchId

       join logisticsElectronicAddress where logisticsElectronicAddress.Location == dirPartyLocation.Location

       && logisticsElectronicAddress.IsPrimary == NoYes::Yes

       && logisticsElectronicAddress.Type == LogisticsElectronicAddressMethodType::Phone

       && vendTable.AccountNum == _vendPurchOrderJour.PurchId

            ContactPersonName = logisticsElectronicAddress.Description;

    Can your Please See And Let me know any Changes Required in this.

    Currently Working on the Purchase order Confirmation Report.

    I want to get the Vendor Contact Information Description Based on this Particular Purchase order.

    Please Help Me.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,364 Super User 2025 Season 2 on at
    RE: how get the Logistics Electronic Address Table Description Field Based On the Purch Id and Vend Accountnum

    Hi Srinivas,

    I do hope you are using SSSRS reports for development.

    There is a relation to the Logistics electronic address using the DirParty record from the Vendor.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans