You’re offline. This is a read only version of the page.
Announcements
64
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
Hi Vicky,
What values for the effective date/time do you provide in the source file?
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.
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.
Thanks Andre,
Is there a way to understand how it works.
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
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.
#1
André Arnaud de Cal...
294,099
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
