Possible billing glitch

Support
1

Situation
Staff member accidentally clicked the “Add Copay” button , twice, and saved 2 $0 copay entries on fee sheet. There doesn’t appear to be a way to delete these, if you mark them for deletion and then save the fee sheet, the blank entries remain.

OpenEMR Version
I’m using OpenEMR version 7.0.2 , Patch 1

Browser:
Tried Chrome, Firefox, & Brave

Operating System
I’m using: Ubuntu 22.04 LTS , MariaDB 10.6

Search
Did you search the forum for similar questions? Yes

Logs
Did you check the logs? Yes
Was there anything pertinent in them? No relevant errors logged
Please paste them here (surround with three backticks (```) for readability.
You can also turn on User Debugging under Administration->Globals->Logging User Debugging Options=>All

The other thing I was trying to figure out, is there any way besides re-writing the Fee Sheet code to get read of the ICD9 Diagnosis option at the top?

2

yep, thanks for the reminder @Penguin8R

3

Oh! I forgot to search in GitHub, that’s on me.
I was hoping to be able to find a way to purge these manually, but after searching through the database for a few hours, I still can’t find where those co-pay records are stored. Whenever I do track them down I’ll update here in case anybody else is dealing with similar issues cleaning up data entry mistakes.

4

The copays should be stored in the ar_session or ar_activity table. The payment type column should be marked appropriately to denote the copay.

5

Thanks Sherwin! You are correct, it’s ar_session, I missed them the first time around because the column name is ‘patient_id’ instead of ‘pid’. Unfortunately, even if you take those rows out, the ghost $0 copays still show on the fee sheet, so the quest continues.
Still need to dig into getting rid of ICD9 too…

6

Likely you have a record in the billing table that’s pulled into the fee sheet. Might be helpful to look at the following ERD diagrams:
billing:
https://one.openemr.io/b/openemr/Documentation/EHI_Export/docs/tables/billing.html
ar_session:
https://one.openemr.io/b/openemr/Documentation/EHI_Export/docs/tables/ar_session.html

1 Like