Extending length address fields on account entity (or contact entity)
When you need to extend the length of the address fields on the account entity (or the contact entity), don't forget to also extend the length of the corresponding fields on the customeraddress entity. The address values are also saved in there...
So to avoid error messages saying that the length isn't long enough (although you changed it for the account entity), be sure to update both entities!
So to avoid error messages saying that the length isn't long enough (although you changed it for the account entity), be sure to update both entities!
I want to externd address1_line1 of systemuser, I updated it in both the systemuser and customeraddress, but it seem doesn't work. it seems to need to update internaladdress table also, but it is disable in the crm web interface. have you experienced with this ?
ReplyDeleteThanks
Unfortunately I don't have experience with updating address fields for the systemuser entity. Something you can try, but is totally unsupported (do it first in a test environment, f.e. on a vpc), is update the database to convert the system entity to a customizable entity.
ReplyDeleteThis is how:
Open SQL Server Management Studio
Connect to the [organization name]_MSCRM database.
Run the following update command:
update ENTITY
set ISCUSTOMIZABLE = 1
WHERE NAME = 'internaladdress'
Please note that I haven't tested this (when I have the time to test it, I will post it here), so it is at your own risk. Make sure you have a backup of your database.
Good luck!
Kevin Dosseray