Knowledge Base Knowledge Base Operations Other

            How to Fix Claim Awaiting Transaction Processing Error

            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 =

            Updated: 23 Aug 2017 11:33 AM
            Helpful?  
            Help us to make this article better
            0 0