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 GP application.
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 SmartList shows all unapplied AR transactions in Dynamics GP. It also calculates how many days overdue a transaction is. A great SmartList for credit control.Benefits of Using SmartList For Dynam...
Free
Free
Dynamics GP uses OPEN, WORK and HISTORY tables to process transactions. As transactions move between the tables, interruptions (much like those that cause stuck batches) can cause duplicate data to be...
Free
Free
Microsoft Dynamics GP easily integrates with one of the world's most used applications, Word. Together, it is possible to create beautiful looking reports that can seamlessly flow from Dynamics GP. Al...
$40.00
$40.00
This report shows all transactions against the checkbook in Dynamics GP. It's a great SmartList for enquiring into the makeup of the detail behind your checkbook balances.Benefits of Using SmartList F...
Free
Free