Duplicate Account Transactions

[funnylookinhat]

At extremely high volumes, customer or vendor payments can occasionally create duplicate account_transactions. You can find them with the following:

SELECT transaction_id, account_id, date, amount, transfer, writeoff, COUNT(*) 
FROM account_transactions 
GROUP BY transaction_id, account_id, date, amount, transfer, writeoff
HAVING COUNT(*) > 1

We need to come up with a tool to calibrate transactions generically ( not just payments or form actions ) and add it to the broad calibration script and set of checks.