Subject: Describes what the spSmartFill.sql file included with SmartFill is used for. More Information: The spSmartFill.sql file is a template for a SQL Stored Procedure that can be used to add functionality to your lookups that could not otherwise...
Knowledge Base
Error: A get/change first operation on table ‘SF_Object_MSTR’ failed accessing SQL data After Installing SmartFill
Error: You receive the following error after installing SmartFill. Unhandled database exception: A get/change first operation on table 'SF_Object_MSTR' failed accessing SQL data. Number of results columns doesnt match table definition....
Error: Unhandled database exception: A get/change first operation on table ‘SF_Object_MSTR_OLD’ failed accessing SQL data. Number of results columns doesnt match table definition
Error: When upgrading from Dynamics GP 10 to Dynamics GP 2013, the following error appears: Unhandled database exception: A get/change first operation on table 'SF_Object_MSTR_OLD' failed accessing SQL data. Number of results columns doesnt match...
Error: Unhandled script exception: [Microsoft][ODBC SQL Server Driver][SQL Server] Could not find stored procedure Name.dbo.spSmartFill'. error
Why are we getting an Unhandled script exception: [Microsoft][ODBC SQL Server Driver][SQL Server] Could not find stored procedure Name.dbo.spSmartFill'. error when we try to do lookups after creating a new company? You are getting this message...
Error: Unhandled script exception: Illegal address for field 'Company ID' in script 'Security_Trigger'. Script terminated.
Why am I getting an "Unhandled script exception: Illegal address for field 'Company ID' in script 'Security_Trigger'. Script terminated. error message after installing SmartFill? Typically this error comes from either the SmartFill version being...
How to Temporarily Disable SmartFill
Subject: Describes how to temporarily disable SmartFill to add a new record, etc. Information: You can temporarily disable SmartFill by typing something on any window that is not an exact match, so that you get the Select Record window. Otherwise,...
The Install/Upgrade Window Continues to Appear When Logging into GP after Installing the Latest Build of SmartFill
Issue: After installing the latest build of SmartFill, the Install/Upgrade Wizard window continues to appear when users log into Dynamics GP. Cause: This will happen if the latest build for SmartFill was not installed on all workstations that...
How to Add a Field from Another Table to a SmartFill Object
Subject: Describes the steps to display the Customer Balance field to show in the Make a Selection window when using SmartFill. Resolution: Go to Microsoft Dynamics GP | Tools | Setup | Smartfill | Objects. Open the Customer Object. Click the blue...
SmartFill access for Users and Companies
Issue: How do I provide access to SmartFill for companies and/or users? Resolution: To grant or remove access to companies and users: Open each SmartFill Object. At the bottom of the Object screen you’ll see an Access button. Click on the Access...
SmartFill Compatibility with Integration Manager
Issue: Describes known issues with when using Integration Manager with SmartFill enabled. Resolution: There have been a few issues reported when using Integration Manager while SmartFill is enabled. If you do run into issues, we recommend you...