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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Address effective date...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Address effective date concepts and issues

(0) ShareShare
ReportReport
Posted on by vicky1234 68

We trying to import customer postal entity for updating the customer entity but we are encounter with some problems.

 We are updating 2 address for a customer wherein the effective and expiration dates are as follow:

1st address: 1-april 2023 to 5-april 2023

2nd address: 5-april 2023 to 10-april 2023

Apart from street address, both the address are same.

 

We expect that after 5-april 2023 we should see the second address as the first address should expired, instead we see the first address for 1-april 2023 to 10-april 2023 by changing the system date.

 

pastedimage1680513438271v1.jpeg

I have the same question (0)
  • vicky1234 Profile Picture
    vicky1234 68 on at

    Has anyone faced such issue before or its a correct behaviour of the system.

  • Martin Dráb Profile Picture
    Martin Dráb 238,743 Most Valuable Professional on at

    Your screenshot seems to show your input (I'm guessing). What data do you now see in the table(s)?

  • vicky1234 Profile Picture
    vicky1234 68 on at

    hi Martin,

    Thanks for the reply.

    The customer address shows the same address even in case the the date is from  1st march to 10th June,

    It shows the old address only and not the new one.

    And we have not made any changes to this entity.

  • Martin Dráb Profile Picture
    Martin Dráb 238,743 Most Valuable Professional on at

    I mean running a SQL query and checking the actual data in database.

  • vicky1234 Profile Picture
    vicky1234 68 on at

    hi Martin,

    Below is the screen from the logisticspostaladdress 

    pehla - first record
    dusra - second record. and I see always the first record only.
    It has created multiple times because I used the entity again to check the data and update it.

    pastedimage1680527369002v1.png

    As per my understanding it should show "dusra" record if system date is greater than 7 april

    Also as per standard what should be the date when the system date is  less than 3rd april.

  • Martin Dráb Profile Picture
    Martin Dráb 238,743 Most Valuable Professional on at

    You showed us a result of a query, but you didn't tell us what query you used.

    I see records with the same ValidFrom, which suggests that they are actually related to different locations (because having

    the same Location and ValidFrom on two records would violate uniqueness of AK1 index of LogisticsPostalAddress table).

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,128 Super User 2026 Season 1 on at

    Hi Vicky,

    Are you looking at the customer form itself to see the addresses or did you create e.g. an SQL query to verify results. Please provide the details what you execute and look at. So far, I only see screenshots of data outside F&O. Note that the date effectiveness is applied when using Dynamics 365 select statements or queries, unless you specify you need to see all records. If you created an SQL query to get the first record, SQL is not aware of the date effective framework inside F&O.

  • vicky1234 Profile Picture
    vicky1234 68 on at

    Hi Andre,

    I am checking the values in D365 FO customer master list page - > address tab.

    @MartinDrab

    below is the query.

    select validfrom,VALIDTO,LOCATION,* from logisticspostaladdress order by recid desc

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,128 Super User 2026 Season 1 on at

    Hi Vicky1234,

    I just read the question and details again and I missed your assumption about the system date.

    The date effective framework is taking the today's date; not the system date. If you want to view it as of a particular date, you can use the Advanced view of the addresses (More options > Advanced) and change the view to show Future records.

  • Martin Dráb Profile Picture
    Martin Dráb 238,743 Most Valuable Professional on at

    Your query isn't related to the customer in question. It lists all addresses (for all customers, vendors etc.).

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 583 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 378

#3
Diego Mancassola Profile Picture

Diego Mancassola 255

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans