Check order to see where payments are duplicated
Open DBBrowser
Filter by OrderID=xxxx in the Adjustment Database
Modify Filter to “OrderID=xxxx or (OrderId=0 and CustomerID=xxxx)”
Copy this filter to be used in the following tables:
Adjustment Database
GL Database
Order Database
Payments Database
In those tables, remove the duplicated payment entry
Filter by CustomerId=xxxx in the Customer Database
Remove or reduce Customer credit appropriately
NOTE: Some tables will have double entries, some won't.