If you have multiple companies and need to run a script against all of them, you would usually have to repeat the script execution for every company. However, with this command you can simply paste the script you would like to run below the “/* Insert your script below this Line, Note: Double up single quotes */” and execute it against all GP companies.
Benefits of using SQL Scripts
Dynamics GP is a great system full of lots of features, but every now and then we need to turn to SQL to help us. So we have gathered some of the most useful SQL scripts from our partners, and the GP community, for your use.
Supported Systems | |
ERP Software | Microsoft Dynamics GP |
This script grants all of your users access to all SQL objects in your Dynamics GP databases. It’s useful in situations where new SQL objects have been added that need to be accessed via the Dynamics ...
Free
Free
If you're using Sage X3 PU9 to generate bank files, you've probably run into this little issue. When generating bank files, you can only save them to a Sage volume, which may not be the easiest place ...
$30.00
$30.00
If you have multiple companies and need to run a script against all of them, you would usually have to repeat the script execution for every company. However, with this command you can simply paste th...
Free
Free
Benefits of Using SmartList For Dynamics GPSmartList is one of the easiest reporting tools for Dynamics GP. You can instantly visualize your data in the form of simple reports. You can expor...
Free
Free