This script allows you to search Payables History for downloads that are missing apply records. It will check the total of all records applied to a document, against the total of the original document.
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 |
MT942 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 interim statement file which details a...
$80.00
$80.00
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
This is a great SmartList that shows all posted payments and the details of how they were applied. Great for general enquiries and is much quicker than using the relevant enquiry screens.Benefits of U...
Free
Free
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 hea...
Free
Free