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.
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.
If you need assistance, just email us at Support@Crestwood.com and we can help you out.