Deleted codes showing in patient report billing information

Support
#1

Situation
CPT4 codes deleted from an encounter fee sheet still show up in the Billing Information section of a Patient Report.

The activity field for those codes in the billing database table is set to 0, and the file library/report.inc on my server contains the proper WHERE clause in getPatientBillingEncounter to filter out rows without activity set to ‘1’.

Yet, the output from from “Report->Patient Report->Generate Report” with Billing selected still shows the codes with activity = 0.

Is the output generated from a function other than getPatientBillingEncounter?

OpenEMR Version
I’m using OpenEMR version 6.1.0-1

Browser:
I’m using: N/A

Operating System
I’m using: N/A

Logs
Did you check the logs? yes
Was there anything pertinent in them? no
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

#2

Do the single quotes in the WHERE clause make a difference since it’s filtering on a tinyint field?

#3

Replicable on demo.openemr.io. Steps:

  1. Create encounter for patient.
  2. Add code to fee sheet. Save.
  3. Delete code from fee sheet. Save.
  4. Select “Report” from patient dashboard.
  5. Ensure “Billing” is checked, then select “Generate Report” under “Patient Report”.
#4

it’s the function printPatientBilling()that needs some help when it’s called

1 Like
#5

Ah, I see. Thanks!