Here are a few errors that may be encountered when using SmartConnect and some simple steps to try and fix them. As always, when using SQL, please make sure to have a restorable backup and test first in a test company.
Company Button missing/screen distorted
The display settings on the machine need to be adjusted. You can refer to the eOne Solutions KB article here: http://www.eonesolutions.com/help-article/kba-01111-g2p6v7/
Once you adjust your settings and restart the machine it should display correctly.
Failed to convert parameter string to decimal
Remove Amount field as one of the Key fields
Failing to AutoPost using Stored Procedure
Verify that all Checkbooks are assigned a Currency ID
Watch this space for more tips on working with SmartConnect or contact our experts 855-437-7201