The ability to create smartlists are an important part of making any business work in a more efficient manner. Using Anyview with SQL View you are able to make smartlist for any situation. First start by creating your View in SQL in the appropriate database. Remember to give your view a unique name.
To add your View to the Anyview available tables go to Microsoft Dynamics GP>Tool>Utilities>System>AnyView>AV External Tables
The Set Up Wizard will start, simply choose “Add External Tables”
Data Source will be “Microsoft Dynamics GP SQL Server” and Database will be “Microsoft Dynamics GP Company Database”.
When “Add External Tables” Window comes up, scroll down in “Physical Name” Column to your View and click the Insert>> button.
Move over the fields you want in your SmartList
Next, go to Microsoft Dynamics GP>Tool>Utilities>System>AnyView>AV Creator Wizard
Action = Define a New Object
Select your View as the Main Table by finding it in the list, highlighting it and clicking Next.
You probably don’t need any other tables, so just click “Next” on the screen that comes up.
On the next screen, make your selections for any Object Restrictions you need for your SmartList
Select your Columns to include by using the Insert>> or All>> buttons
Mark your default columns
Click Sum if you want to Sum any of your numeric columns
Select your Object Goto’s
Select to Add This SmartList Object to the ANYVIEW_CREATOR_OBJECTS Security Task
Name your new SmartList
Go to SmartList and test your SmartList to see if it acts as expected.
It’s as easy as that….