I just wanted to take a second and highlight again David Musgrave’s very useful SQL Scripts Series. David has some great scripts today for identifying duplicate transactions. Make sure that you give it a look.
Identifying Duplicate Transactions
Archived post from 2008. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.