Occasionally, seemingly at random, a payment would be duplicated. This caused significant distrust in the system and resulted in the client manually checking the payable file every day.
The current solution was a complex SQL integration services packaging running essentially as a “black box”, meaning that either it worked, or it didn’t, without an opportunity to run it a second time.