SmartList Builder Error When Upgrading Dynamics GP

Posted by David Gigear, Senior Consultant on September 21, 2016


Recently, we were upgrading a client from Dynamics GP 2010 to Dynamics GP 2016.  When we added in SmartList Builder to Dynamics GP 2016, we encountered an error.  Every time users started Dynamics GP and tried to use SmartList Builder, they received the following pop-up message and could not use it.

SmartList Builder needs to finish installing.  This may take a few minutes.

Why?

It turns out that this error happens because in Dynamics GP 2010, Microsoft owned SmartList Builder, but then Microsoft gave it back to eOne, who made some changes to the SQL tables.  Specifically, eOne added a new column called “Blank_Field_CB” to the ERB111000 table.

Here’s the Fix

If you’re experiencing this error too, you can download and run the following SQL Script against your Dynamics database.  Please note, make sure to verify your error with the dexsql error log first. 

Download SQL Script File

If you need assistance, just email us at Support@Crestwood.com and we can help you out.


Share this:
 
 

Comments:

Add your comment: