Sometimes a bit of housekeeping is needed to get the engines revving on all cylinders again. This file contains 4 statements. The first 2 will display records in the sales table that are missing a header record. If a line item has no record it is essentially a garbage record. So, once you have found your erroneous sales lines you can delete them using the 2 delete statements contained within the file.
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 |
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
With this SmartList you can quickly and easily gain an insight into the state of your Accounts Payables ledger and easily export the data to Excel.Benefits of Using SmartList For Dynamics GPSmartList ...
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
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