ajperezcrespo wrote on Tuesday, June 28, 2011:
Hi,
When in billing manager and a criteria is set, depending on which criteria you select, errors are returned. Here is a list of criteria and the errors they produce. I tested all and unlisted criteria do not produce errors.
Whether insured, Charge Coded, Claim Type or Authorization will produce a blank Report.
Custom Dates (All), Patient ID or Encounter will produce
ERROR: query failed: select distinct billing.id, form_encounter.date, billing.pid, billing.code_type, billing.code, billing.user from form_encounter, billing, patient_data, claims, insurance_data where billing.encounter = form_encounter.encounter and billing.pid = form_encounter.pid and patient_data.pid = form_encounter.pid and claims.patient_id = form_encounter.pid and claims.encounter_id = form_encounter.encounter and insurance_data.pid = form_encounter.pid and insurance_data.type = ‘primary’ AND (form_encounter.date between ‘2011-06-14 00:00:00’ and ‘2011-06-22 23:59:59’) AND claims.payer_id = '‘135\’ and billing.code_type like ‘%’ and billing.activity = 1 order by billing.pid, billing.date ASC
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘2011-06-14 00:00:00’ and ‘2011-06-22 23:59:59’) AND claims.payer_id = '‘13’ at line 1
The above example is a custom date with a specific insurance company. You don’t have to combine them, each will err on its own.
Thanks