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 |
✯ This Item Requires The Bacs File Generator Application ✯ Electronic Funds Transfer (EFT) is becoming a more common payment method in our everyday personal banking. Remember the last time you tran...
$80.00
$80.00
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...
$200.00
$200.00
MT940 is a standard structured SWIFT Customer Statement message. In short, it is an electronic bank account statement which has been developed by SWIFT. It is an end of day statement file which detail...
$80.00
$80.00
This SmartList shows all posted deposits and the related receipts. Each receipt is on its own line and the deposit info separated as many times as they appear against a receipt. This a great repo...
Free
Free