Clear the Marked Payment From Customer Payment Process

This is typical issue when the Red Mark hand is shown on the open invoice transaction from Customer Details > Open Transaction Editing

Sometimes after marking and process the payment, the red hand doesn't go away. It is stuck in a table called Spectrans.

The relation to get to the record to delete is

Get the Recid from CustTrans table from invoice number
Get the Recid from CustTransOpen table from CustTrans Recid under RefRecId
Get the Record from Spectrans table from CustTransOpen Recid under RefRecid
Remove the record from Spectrans will remove the red hand.