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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Customer postal address

(0) ShareShare
ReportReport
Posted on by 68

hi,

I have duplicated the entity " customer postal address" and created "Projects postal addresses". I have set the logic to create the dirparty at the method "setPartyNumber" and its able to create a new Project address.

I have also added a project address tab in the project master just like the standard ones.

The issue is that sometimes while importing records from excel it sometimes overrides the previous records with the last one even for the standard "Customer postal addresses".

Also in cases wherein you might get the below errors it will actually create records in the logisticspostaladdress table which is very surprising.

Can someone explain on what basis the below errors are shown and what is the best way to create addresses in the table.

for eg. Below are the errors received during import of records 

Cannot edit a record in Addresses (LogisticsPostalAddress). Invalid value specified for 'Expiration'. It has to be less than the 'Expiration' of the next record.

 

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.

Thanks,

VK

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    303,123 Super User 2026 Season 1 on at

    Hi VK,

    The table LogisticsPostalAddress is date effective. To be able to update an existing record, you would need to have the exact same values for Effective and Expiration date/time fields in your source file than for existing records.

    You can limit the number of errors by providing an Effective date/time yourself. If not provided, the data entity will use the current time stamp for the Effective field.

  • vicky1234 Profile Picture
    68 on at

    Thanks Andre,

    Is there a way to understand how it works.

    pastedimage1676623529673v1.png

    I have a project with primary address existing in system and with location id and another one with blank location id which does not exist.
    On importing this there is an error on the second record however the record with blank location id is showing as the primary address in the system. So basically it overwrites.
    However if i check the logiscticspostaladdress table there are 2 records created for the above import which is very surprising.

    Thanks,

    VK

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

    Hi VK,

    Is this related to your custom entity? Or do you have exactly the same with the customer postal addresses? If it is related to your customization, please share technical details how you developed the entity.

  • vicky1234 Profile Picture
    68 on at

    The screens I have shared is of custom one but the same thing happens with std "Customer postal addresses"

    If you try to save and import customer addresses with different combinations and after import check the logisticspostaladdress table as well then it should be more clear because with each import it is creating records in the table, offcourse sometimes it does update as well , however in some cases it will just create a new record and in fthe front end it will show an error.

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

    Hi Vicky,

    What values for the effective date/time do you provide in the source file?

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!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 349

#3
Diego Mancassola Profile Picture

Diego Mancassola 263

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans