Identifying Duplicate Transactions

From the Useful SQL Scripts Series. Because Microsoft Dynamics GP is designed to have separate tables for WORK, OPEN and HISTORY transactions, there are times where it is possible for a transaction record to exist in more than one table.  This is usually the result of an error or interruption. These duplicate records become an issue when…

21