Subject: You are using SmartFill but need to stop the search before it is complete. More information: Enable the 'Toggle Fast Search' feature under Microsoft Dynamics GP | Tools | Utilities | SmartFill | Toggle Fast Search. This is a toggle you...
Knowledge Base
Error 4 occurs in the Comment field of SmartFill Repository
Issue: What does Error 4 in the comment field of the SmartFill Repository indicate? Resolution: This error typically indicates that the field referenced in the Repository no longer exists. For example, the Account Number field on the...
Error: "Procedure or function spSmartFill has too many arguments specified." occurs in SmartFill
Issue: Why am I receiving the error message, "[Microsoft][SQL Native Client][SQL Server]Procedure or function spSmartFill has too many arguments specified."? Resolution: This issue was resolved in the latest builds of SmartFill. Upgrade to the...
Errors: "Unable to find a table" or "Unable to include new code" when installing SmartFill
Issue: I'm installing SmartFill on a Dynamics GP2010 install. I get two error messages when trying to include new code that say, "Unable to find a table" or "Unable to include new code". Resolution: If you get an "Unable to find a table" error...
How can I set up a search on Item Number and Item Description for Company A, and just Item Number for Company B in SmartFill?
Issue: Is it possible for SmartFill to do a search on Item Number and Item Description for Company A, and a search on just Item Number for Company B? Resolution: Yes. In this case, you would need to do the following: Make a copy of the...
SmartFill and Forms Modified with Modifier or VBA
Subject: The information here describes if SmartFill works with windows modified through Modifier and Visual Basic for Applications (VBA). Information: SmartFill works on forms modified with Modifier. SmartFill also works on forms modified with VBA...
SmartFill works with Dexterity-based Dynamics GP Third Party Products
Subject: The information here describes that SmartFill can work with third party product objects. Information: SmartFill works with any other Dexterity-based Microsoft Dynamics GP product and can do lookups and can auto-fill values from those...
Error "A get/change first operation on table 'Rockton_Usage_Statistics_MSTR' cannot find the table. Could not find stored procedure 'DYNAMICS.dbo.zDP_RSIUSAGEF_1'. Invalid object name 'DYNAMICS.dbo.RSIUSAGE'."
Issue: During installation I am getting the errors, 'A get/change first operation on table 'Rockton_Usage_Statistics_MSTR' cannot find the table. Followed by, Could not find stored procedure 'DYNAMICS.dbo.zDP_RSIUSAGEF_1'. Invalid object name...
Error "A get/change first operation on table 'SY_Current_Activity' failed accessing SQL data."
Issue: How do I resolve the error, 'A get/change first operation on table 'SY_Current_Activity' failed accessing SQL data.'? Resolution: This is a known issue and is caused by our product code not using the proper Country date format. We will be...
Error: "Countrecords operation on table RM_Customer_MSTR failed accessing SQL Data" when using SmartFill
Issue: I’m getting an “A countrecords operation on table ‘RM_Customer_MSTR’ failed accessing SQL data” error message when using SmartFill. Resolution: This error message indicates the ANSI and/or Translation boxes have been marked in the ODBC. ...