We edited the invoice 'status reason' picklist ( actualy deleted some values
) and modified others. This we have done on other picklists with no problems.

However we have noticed that when this attribute is displayed on selection
lists the text displayed is not the same as that on the picklist. We now
presume there is code behind particular list values and want to restore the
old values with the same list value. We have a backup of the DB available
through enterprise manager and can see the missing records there in
STRINGMAP and STRINGMAPBIT . We are missing values 4,5, 6 and are concerned
that this will cause problems?

Any solution.

The way I would do this is:

Backup the MSCRM and METABASE databases
Export customisations for your entity.
Make a copy of the file, then open it it any text or xml editor.
Find the <field name="statuscode" element
Add the status values back in under the <statuses> element by copying what's
already there and editing the value and description attributes.

Then import the customisation file and publish the changes

"Steve" wrote:

Thanks David...will do

"Steve" wrote: