Issue: How is SmartFill different from what Dynamics GP already offers for lookups? Dynamics GP Explanation: Advanced Lookups are a core part of Dynamics GP, introduced back in version 6.0. These are the standard lookups that have always been part...
Knowledge Base
How to change the number of results returned in the SmartFill "Make a Selection" window
Issue: How do I change the number of results returned in the SmartFill 'Make a Selection' window? Resolution: You can change the default number of 1,000 records to a different number that you prefer by following these steps: Go to Tools | Setup |...
How can I stop SmartFill from creating duplicate results in the 'Make a Selection' window?
Issue: How can I stop SmartFill from creating duplicate results in the 'Make a Selection' window? Resolution: If SmartFill finds multiple records it will bring back all records that apply, even if they are duplicates. You can add a Filter at either...
How do I get SmartFill to default to a sort order on a custom SQL object?
Issue: How do I get SmartFill to default to a specific sort order on a custom SQL object? Resolution: It will always sort by the first column, so you will need to make whatever you want as the default sort order to be the first column in the...
How do I stop a SmartFill search in progress?
Issue: How do I stop a SmartFill search in progress? Resolution: To stop a search that is in progress where it is for example, returning say 1,000,000 rows and you don’t want a user sitting idle during this time, it cannot be stopped. Therefore,...
How to stop a SmartFill Search
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...
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...