What would cause such error?
Cannot create a record in Addresses (LogisticsPostalAddress). Insert not supported with the values specified for 'Effective' and 'Expiration'. New record overlaps with multiple existing records
I can't find the error in D365 labels..to look for references. How can i find it?
I have a custom service that updates or creates an address using logisitcsPostalAddressHistoricalCDSV2Entity
Any idea?
Hi martin,
But as i said, if location and validFrom are the same, then it will never create a new record and it will just update it(maybe it uses correction). As it the validTimeStateEnabled property for this entity is no.
So i tried multiple times but got no errors.
In order to create new records, validFrom needs to be different it seems
Now you have the same location, but different period.
The unique index isn't violated because the records didn't have the same combination of Location and ValidFrom.
Hi Martin,
If i try to insert record with same data or by changing street only for example, it's going to override it because logisticsPostalAddressHistorecalCDSV2Entity ValidTimeStateEnabled = no
But i tried to change validFrom so that it creates history, it worked so i still can't reproduce the error. can you please tell me the repro steps?
Your screenshots show addresses for different locations.
Hi Martin,
I tried to reproduce by creating addresses that are valid at the same time, but I didn't get any error.
When then would such error appear?
Hi Girish,
Based on ur first link, i tried to add an address that is between an existing period but I didn't get an error as well
Hi DELDYN,
Check the below blogs and thread which will help you to understand about the error.
https://www.anegis.com/articles/basics-of-working-with-date-effective-framework-in-ax-2012-p2
Thanks,
Girish S.
It comes from kernel logic for date-effective tables.
You're trying to insert a record with invalid values. It it was allowed, it would cause having several addresses valid at the same time.
Hi, There might be existing records in this effective and expiration period.
André Arnaud de Cal...
292,111
Super User 2025 Season 1
Martin Dráb
230,934
Most Valuable Professional
nmaenpaa
101,156