Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / LogistcsPostalAddress ...
Microsoft Dynamics AX (Archived)

LogistcsPostalAddress Table Address Issue

(0) ShareShare
ReportReport
Posted on by JDMCRM 1,797

Hi, 

We have an AX > CRM integration and have been looking at extending this to include Addresses (AX addresses going over to CRM). It seems that within a Customer Record, if you update an existing Address this actually creates a new Record in the LogisticsPostalAddress Table rather than updating the existing Record. 

This is causing an issue where any updates to existing Addresses against a Customer Record is causing a duplicate Record being created in CRM with the updated Address Lines. 

Would there be anyway around this? and why is a new Record created in the underlying LPA table for updates to existing addresses?

*This post is locked for comments

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,614 User Group Leader on at
    RE: LogistcsPostalAddress Table Address Issue

    what you are using for integration? if you are using CRM connector I am not aware of details how it works internally.

  • JDMCRM Profile Picture
    JDMCRM 1,797 on at
    RE: LogistcsPostalAddress Table Address Issue

    Thanks guys. I wasn't aware of Date Effective Data so that explains a lot.

    The issue there, Sohaib, is I can't think of a way the original Address Record that has passed over to CRM would be updated. I could query so only active Records are sent over, but that would still send a new Record over, rather than updating the existing Record.

  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,614 User Group Leader on at
    RE: LogistcsPostalAddress Table Address Issue

    and you can see only 2 records are valid, by validefrom, validadto date(s)

    The table is using Date Effective pattern.

    you may do something  so that ax will send only that data to crm, which is active as of date.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 231,837 Most Valuable Professional on at
    RE: LogistcsPostalAddress Table Address Issue

    It seems that you're not familiar with the concept of date effective data.

  • JDMCRM Profile Picture
    JDMCRM 1,797 on at
    RE: LogistcsPostalAddress Table Address Issue

    Thanks for the response.

    I've attached an image of the Records created in the LPA Table. Perhaps that may help to identify something. The three Records that have been created are all from the same address against a Customer Record. All I did was click the Address on the Customer Record and clicked "edit". I then just altered the Street Name. I made two changes to the Street Field, and, as you can see, two additional LPA Records were created.  

    Are you saying these shouldn't be created and the original (bottom address) should have been updated?

    Screen-Shot-2016_2D00_06_2D00_15-at-14.16.11.png

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,614 User Group Leader on at
    RE: LogistcsPostalAddress Table Address Issue

    A new record in address table can be created for two reasons

    1) if previous address has been expired and you may make a new address

    2) you may create multiple address, where one address is primary. e.g. an organization/customer may has 10 branches each having own address or e.g. an organization/customer may has different address for different roles (delivery, invoice)

    I cannot see any other reasons for creation of extra records in LogisticsPostalAddress

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... 293,001 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans