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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / modified address in table
Microsoft Dynamics AX (Archived)

modified address in table

(1) ShareShare
ReportReport
Posted on by Ganriver1 1,559

Hi Friends,

When we modify address, We know AX still stores old address, and insert a new one, and display the modified(new) address  only.

Just wondering, in database table, how to distinguish two address records?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Satish Panwar Profile Picture
    Satish Panwar 14,673 Moderator on at

    Hi Ganriver,

    Addresses are stored in "LOGISTICSPOSTALADDRESS". This table has valid state framework, what that means is it has ValidFrom and ValidTo fields that holds the versioning of the records.

    Here is how you can understand this real quick:

    1. Go to a customer, create an address, find in LOGISTICSPOSTALADDRESS table

    2. Go back to same address, modify and say you changed the street, go back to LOGISTICSPOSTALADDRESS table, you will see two records, pay attention to ValidFrom and ValidTo fields in database.

    While these are retrieved and shown by default, only current records are shown but others can be seen as well. For addresses, use More options > Advanced. then on the left pane you see Active/Future/history. Hope this helps.

    Thanks,

    Satish Panwar

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

  • Ganriver1 Profile Picture
    Ganriver1 1,559 on at

    Thanks a lot!

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

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sanhthosh.Kumar.K Profile Picture

Sanhthosh.Kumar.K 2

#2
Raed Salah Bzour Profile Picture

Raed Salah Bzour 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans