Again, some spring cleaning tips. This script has 2 select statements that will show you historical sales documents where the customer no longer exists. The two delete statements will allow you to remove these erroneous records.
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 |
We’ve all been there! We meant to store the system password in a secure place just in case we forgot it, but that didn’t happen. And now we are locked out of all of the Dynamics GP system menus. What ...
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 swipe throug...
$80.00
$80.00
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
Again, some spring cleaning tips. This script has 2 select statements that will show you historical sales documents where the customer no longer exists. The two delete statements will allow you to rem...
Free
Free