Address Composite field update

(0) Share

Report

Posted on by Mir Hassan Ali

1,720

One of my plugins updates the address fields to null in a contact, but when I open the contact in CRM application, the composite field still shows the old address but the individual fields in the fly-out are blank. Is there a way to set the composite field to null as well.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Mithilesh Kumar 10,047 on at

Like (0)

Report

Hi Hassan,

You need to update the "address1_composite" field also to null.

Hope that helps

Thanks

Was this reply helpful? Yes No
Mir Hassan Ali 1,720 on at

Like (0)

Report

Hi

That unfortunately is a read-only property.

Thanks

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (0)

Report

Hassan,

Try to set the related Customer Address entity fields (all fields, include street1, street 2, street 3, city, postal code, state, county, country, or any fields you need) to Null as well.

And you need to know that customer address line number 1 is the address1_composite field and customer address line number 2 is the address2_composite, so that not all of the customer records you need to set to null, just the address 1 or address 2 based on what address composite field you need to set to null.

Hope this helps!

Thanks.

Was this reply helpful? Yes No
Mir Hassan Ali 1,720 on at

Like (0)

Report

Hi Aileen

I am already doing that as shown below, but the composite field is not set to null rather it displays the whole previous address.

contact.Address1_Line1 = null;

contact.Address1_Line2 = null;

contact.Address1_Line3 = null;

contact.Address1_City = null;

contact.Address1_StateOrProvince = null;

contact.Address1_PostalCode = null;

contact.Address1_Country = null;

os.Update(contact);

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

No Hassan,

I mean the customer address entity, not the contact. (Contact has 1:N Relationship to an entity, so-called Customer Address), the composite fields (addresses field) in CRM are related to the Customer Address entity as well.

Thanks.

Was this reply helpful? Yes No
Mir Hassan Ali 1,720 on at

Like (1)

Report

Thats it. Deleting record from Customer Address entity worked, thanks!!

Was this reply helpful? Yes No
Mir Hassan Ali 1,720 on at

Like (0)

Report

Just to elaborate further (incase anyone else runs into this condition), if you just delete the record from Customer Address entity then you will not be able update that address later from the CRM application and you will get an error. The reason being that CRM application expects a record to exist in the Customer Address entity for each Mailing and Physical address and if any or both of the records are missing then it will throw an exception. So in my case, after I deleted the record from Customer Address, I created a new blank record as well and all was OK.

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (0)

Report

Hassan,

SO that I think, do not delete, but set to Null for all fields.

" so that not all of the customer records you need to set to nul"

Thanks.

Was this reply helpful? Yes No
Mir Hassan Ali 1,720 on at

Like (1)

Report

Hi Aileen,

No, that brings back the original problem, you can not update the address composite field as it is read-only and setting all other fields to null does not set the composite field to null.

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

How did you create a blank record for the account after deleting it. I was able to create the customeraddress but the account no longer has any address on it.

Was this reply helpful? Yes No