You’re offline. This is a read only version of the page.
Announcements
64
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.
Your query isn't related to the customer in question. It lists all addresses (for all customers, vendors etc.).
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.
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.
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).
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.
I mean running a SQL query and checking the actual data in database.
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.
Your screenshot seems to show your input (I'm guessing). What data do you now see in the table(s)?
#1
André Arnaud de Cal...
294,161
Super User 2025 Season 1
#2
Martin Dráb
232,942
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
