Subject: The information here describes what happens when you use SmartFill with an Extender window. Information: Extender is a set of generic windows and fields. For example: You can use Extender to create two objects with forms, such as...
Knowledge Base

Error: A get/change operation on table HR_orientation_V2 failed. A record was already locked.
On the Orientation Checklist window, once an employee ID is entered if you check a checkbox in the list it produces Error: 'A get/change operation on table 'HR_orientation_V2' failed. A record was already locked.' This is a known bug. The current...
Decimals do not show correctly in the SmartFill Make a Selection
Issue: When numerical values are used in SmartFill, decimals do not show correctly in the Make a Selection window. Cause: SmartFill was not designed to display decimals in the Make a Selection window. Resolution: You may use a SmartFill Custom SQL...
SmartFill randomly stops working in Dynamics GP 8.0 or newer versions.
Issue: After launching Dynamics GP 8.0 or newer versions, you notice that SmartFill randomly stops working. Recommendations: Microsoft has added a lot of initialization processes to Dynamics GP 8.0 when compared to previous versions. When you start...
What is the difference between SmartFill and Lookup Pro?
What is the difference between SmartFill and Lookup Pro? SmartFill now allows the functionality of Lookup Pro to work ANYWHERE on ANY object. Lookup Pro was limited to just Customers, Vendors, Items, Accounts, and Employees. SmartFill does not have...
SmartFill spSmartFill.sql File
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...
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...