aethelwulffe wrote on Friday, January 07, 2011:
Upgraded 3.2 to 4.0, with file named “openemr-openemr-v3_0_1-1116-g02da2cd” downloaded at 4:25 AM 2011JAN7.
Everything else looks good so far, except the billing module. Billing reports on localhost are VERY slow.
Query x-12 partner (choosing a specific one) results in a list that has multiple x12 partners.
Last level billed, choosing ins1 or anything else results in a list of every encounter, including those not coded.
Authorization status choices never result in a list.
Billing Status reports seem like they may be OK, but it seems like we somehow have a lot of claims that have been re-opened…hmmm…
Charge coded==coded/not coded…whatever that is, no results either way, and “All” doesn’t result in a selection, though it does give what may be a full list.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.encounter in ('87-6003) 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 '‘87-6003) and billing.code_type like ‘%’ and billing.activity = 1 order by bill’ at line 1
Whether insured=not insured (and we have quite a few) or "insured== no results.
by encounter=
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-01-07 00:00:00\' and \'2011-01-07 23:59:59\') AND billing.billed = '\'0' 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-01-07 00:00:00\' and \'2011-01-07 23:59:59\') AND billing.billed = '\'0' ' at line 1
by insurance company = no selection available even with full name entered.
by patient number=
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.pid in (\'666) 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 '\'666) and billing.code_type like '%' and billing.activity = 1 order by billing.' at line 1
Patient Name==no results
Claim type==no results
Date of Billing==
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 (claims.process_time between \'2011-01-01 00:00:00\' and \'2011-01-07 23:59:59\') 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-01-01 00:00:00\' and \'2011-01-07 23:59:59\') and billing.code_type like ' at line 1
Date of Entry:
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 (billing.date between \'2011-01-01 00:00:00\' and \'2011-01-07 23:59:59\') 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-01-01 00:00:00\' and \'2011-01-07 23:59:59\') and billing.code_type like ' at line 1
Date of Service (Last month was tried)==yet another sql error message.