picklist defect

Infor CRM V8.2 Picklist Defect, and How to Fix it!

If you have the new or upgraded Infor CRM 8.2.0 database, you may have noticed that adding & editing picklists causes an error. This is a defect in the system. The good news is, there’s a workaround – but don’t try this at home, kids! The procedure requires knowledge of Microsoft SQL Server and/or Transact SQL, so if you’re not a database administrator, pass this along to someone who is so they can properly implement the changes. They’ll need to back up all systems and application databases before making any changes to the tables, just to be safe.

Here are the steps for the workaround:

  1. Open the SITEKEYS table
  2. Locate the row where SITEKEYS.KeyType is 30
  3. Increment the SITEKEYS.KeyValue value for that column so it is higher than the maximum value in the PICKLIST.ItemID
    • Ex: if the current value in PICKLIST.ItemID is A00014O increment SITEKEYS.KeyValue to A00114O

And voila! You should now be able to add and edit picklists. If you’re still running into problems, contact your next level of Infor CRM customer support. Good luck!

Trevor Walker's picture
Trevor Walker

Trevor started with Technology Advisors doing support and maintaining the internal network. Now he spends his time developing solutions primarily with Infor CRM and Starfish ETL. When he's not working he’s probably off doing something totally exciting.

Related Articles

March 22, 2018

What is Infor CRM doing to prepare its system for the GDPR? Let’s take a quick look at how Infor is approaching GDPR compliance and the steps its teams are taking to ensure success.

February 27, 2018

When a sales rep closes an opportunity, she should always indicate the reason for the lost sale in the CRM system. Why? Management can help teams fill gaps and ultimately improve win rates by properly addressing the underlying issues behind these lost sales. Let’s look at some best practices for tracking lost sales in your CRM.