Issue with Error Message in PA

Issue with Error Message in PA


We have researched the issue and found that Billing errors were caused by missing transaction records which caused NULLs in the returned unapplied data. Entries were missing from transactions, transactions_archive, and transaction_detail tables.
We can restore the missing transactions entries using the transaction_history table, and transaction_detail entries using the previous backup made before the missing entries were removed.
However, we were unable to determine the cause why the transaction entries were removed in the first place. To find the cause of the issue we might need to add logging for transaction tables, which will require a TTX ticket.
Please let us know if we should create one.

 

Module: frmSelTransPreClaim
Procedure: cmdOK_Click
Number: 13
Description: 
Conversion from type 'DBNull' to type 'String' is not valid. : System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.
at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value)
at PAClaimsNew.frmSelTransPreClaim.cmdOK_Click(Object eventSender, EventArgs eventArgs)

    • Related Articles

    • Scheduling Applet error message for ReDoc WebPM

      As it says within the error message, this is an error from PracticeAdmin Scheduling Applet (the desktop app, not the Web App). The message occurs when PracticeAdmin Scheduling Applet loses its connection to our servers.  That can happen in two ...

    • 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 ...

    • Remove Posting Error

      Part 1: How to find the posting error description 1. From the claim transaction detail screen click on the Transaction that is bold with Posting Errors. 2. Click the "Go To Payment" button in the top right corner. 3. Read the "Error Description" ...

    • Unable to Launch Billing Issue

      If your question concerns an issue launching the Billing or Scheduling applets, please collect the version of Microsoft Windows you are using as we will need this information to assist you. Please review and complete any steps below that you have not ...

    • Error: This insurance record can not be deleted

      You are receiving this error message because the system does not want you to remove an insurance plan from a patient's record when there are still open claims attached. If you have added insurance plans in error and are receiving messages that you ...