Phone number field size

I added a new link_persphon translation for another phone number type. When I looked on the end screen I see that the field is a different size to the standard ones. What's also annoying is the maxlength of the phone number field is 20 chars whereas the standard ones are 27. This is v7.3. Is this a known issue?

  • 0

    I've not seen this discussed but the local Sage Support team will be able to confirm whether this is a known issue. I suspect it has been resolved in a later patch.

    If it is any comfort it doesn't seem to be an issue in Sage CRM 2017 R2. (In which I am currently working).

  • 0

    Hi,

    You might want to look at the entrysize.

    UPDATE custom_edits

    SET colp_entrysize = 50

    WHERE (ColP_Entity = 'phone') AND (ColP_ColName LIKE 'phon_number%')

    UPDATE custom_edits

    SET colp_lookupwidth = 50

    WHERE (ColP_Entity = 'phone') AND (ColP_ColName LIKE 'phon_number%')

    and colp_lookupwidth is not null;

    alter table phone alter column phon_number nvarchar(50)

    UPDATE custom_edits SET colp_lookupwidth = 50

    WHERE ColP_Entity = 'phone' and ColP_ColName = 'phon_number'

    alter table CRMEmailPhoneData alter column epd_PhoneNumber nvarchar(50)

    alter table CRMEmailPhoneData alter column epd_PhoneFullNumber nvarchar(85)