Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

how i will get address and contact information from warehouse and site through code in AX 2012 R3

(0) ShareShare
ReportReport
Posted on by 2

hi all,

how i will get address and contact information from warehouse and site through code in AX 2012 R3

warehs.jpg

please give me more shed on this.

tahnsk!

  • @rp@n Profile Picture
    @rp@n 2 on at
    RE: how i will get address and contact information from warehouse and site through code in AX 2012 R3

    Shall I pass salesTable.inventsiteid to get address for specific site?

  • @rp@n Profile Picture
    @rp@n 2 on at
    RE: how i will get address and contact information from warehouse and site through code in AX 2012 R3

    Hi Blue,

    The above code is working fine for Warehouse but not working for 'SITE"

    I just changed the LogisticsLocationEntityType::Site

    but not working. anything else need to change?

  • @rp@n Profile Picture
    @rp@n 2 on at
    RE: how i will get address and contact information from warehouse and site through code in AX 2012 R3

    Thanks Blue,

    static void testContactLogic(Args _args)

    {

       //WHSShipmentTable         shipmentTable = WHSShipmentTable::find('USMF-000002');

       SalesTable                      salesTable  = SalesTable::find("SO-0000002");

       InventLocation                      inventLocation;

       LogisticsEntityPostalAddressView     postalAddressView;

       LogisticsElectronicAddress           electronicAddress;

       LogisticsLocation                   contactLocation;

       LogisticsAddressing                     address;

       inventLocation = inventLocation::find(salesTable.InventLocationId);

       if (inventLocation)

       {

           select firstonly postalAddressView

               where   postalAddressView.Entity     == inventLocation.RecId

               &&      postalAddressView.EntityType == LogisticsLocationEntityType::Warehouse

               &&     postalAddressView.isPrimary  == NoYes::Yes;

           if (postalAddressView)

           {

               address = postalAddressView.Address;

               info(address);

               select firstOnly electronicAddress where electronicAddress.Type == LogisticsElectronicAddressMethodType::Phone

               join contactLocation where contactLocation.ParentLocation  == postalAddressView.Location

                   && contactLocation.RecId == electronicAddress.Location;

               info(strFmt("Primary contact name: %1  Primary contact phone: %2",electronicAddress.Description, electronicAddress.Locator));

           }

       }

    }

    It's done which the matching with SalesOrder >> InventLocationId

  • @rp@n Profile Picture
    @rp@n 2 on at
    RE: how i will get address and contact information from warehouse and site through code in AX 2012 R3

    Thanks blue

    Actually we having 10 warehouse and sites. So, which warehouse and site need to print in Sales invoice report that I can match with SO header warehouse and site?

    Is it correct?

  • Verified answer
    Blue Wang Profile Picture
    Blue Wang on at
    RE: how i will get address and contact information from warehouse and site through code in AX 2012 R3

    HI @rp@n,

    Check these if they are helpful:

    stoneridgesoftware.com/.../

    mohsinkhalid.com/.../

  • @rp@n Profile Picture
    @rp@n 2 on at
    RE: how i will get address and contact information from warehouse and site through code in AX 2012 R3

    kindly let me know how i will get the contact information from warehouse and site through code?

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 231,409 Most Valuable Professional on at
    RE: how i will get address and contact information from warehouse and site through code in AX 2012 R3

    What you should have learnt from your older threads (such as when you asked the similar thing about customers) is that there may be helper methods you can use. And it's indeed the case - InventLocation table has a method called address(). Make sure you look at methods next time.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans