Symptom-

There no prior or unposted transaction prior to this patient yet whenever you try to post a payment, a message pops up 'This claim was awaiting transaction processing when you pulled up the claim data, but has since finished processing. You must refresh the claim list before posting transactions to this claim. Would you like to refresh now?'  If you click yes and try posting the payment again, it brings up the same error message.

Fix

There is again some records in transaction detail preprocessing without record in transaction preprocessing. Used the below scripts to help find the claims.

SELECT tdp.* FROM transaction_detail_preprocessing tdp

INNER JOIN claims c ON tdp.claim_id = c.claim_id

WHERE c.claim_id = 

SELECT ts.description, t.* FROM transaction_preprocessing t

INNER JOIN transaction_status ts ON t.status = ts.status

WHERE trans_id_preprocessing =

SELECT p.acct_number, tdp.*

FROM transaction_detail_preprocessing tdp

INNER JOIN claims c ON tdp.claim_id = c.claim_id

INNER JOIN patients p on c.patient_id = p.patient_id

--WHERE trans_desc_id = 310

WHERE trans_id_preprocessing = 9031561

SELECT tdp.*

FROM transaction_detail_preprocessing tdp

INNER JOIN claims c ON tdp.claim_id = c.claim_id

--WHERE trans_desc_id = 310

WHERE c.claim_id = 10025831

Used the delete script to remove

delete from transaction_detail_preprocessing where claim_id = and trans_id_preprocessing =