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 Customers aged as of the current date. It uses the default Dynamics GP aging buckets and the documents due date to calculate aging.Benefits of Using SmartList For Dynamic...
Free
Free
Electronic Funds Transfer (EFT) is becoming a more common payment method in our everyday personal banking. Remember the last time you transferred money to your friend? Was it done in a...
$80.00
$80.00
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
Interested in seeing the last time an item was sold? You can use this SmartList to analyse your data in Dynamics GP. With this, you can gain an insight into what items are currently underperformi...
Free
Free