Finance | Project Operations, Human Resources, ...

Address effective date concepts and issues

(0) Share

Report

Posted on by vicky1234

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.

I have the same question (0)

All responses (10)

Answers (0)

vicky1234 66 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

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.

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.

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (1)

Report

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).

Was this reply helpful? Yes No
André Arnaud de Cal... 301,210 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,210 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No