Fee Sheet Error in V7

Hi everyone, please i am facing errors in the Fee sheet recently . It keeps sending the following errors.

Query Error

ERROR: query failed: select DOB, sex, pricelevel from patient_data where pid=? order by date DESC limit 0,1

Error: Unknown column ‘pricelevel’ in ‘field list’

C:\xampp\htdocs\openemr\library\patient.inc at 71:sqlQuery
C:\xampp\htdocs\openemr\library\FeeSheet.class.php at 141:getPatientData(8,DOB, sex, pricelevel)
C:\xampp\htdocs\openemr\library\FeeSheetHtml.class.php at 26:__construct(8,129)
C:\xampp\htdocs\openemr\interface\forms\fee_sheet\new.php at 476:__construct()
C:\xampp\htdocs\openemr\interface\patient_file\encounter\load_form.php at 41:include_once(C:\xampp\htdocs\openemr\interface\forms\fee_sheet\new.php)

Please @Ajospace @adunsulag @htuck i need help in this.
Image below

hi @Natt_SL_Limited , do you see it in the demographics layout?

1 Like

@stephenwaite i dont see anything on the demographics

then it’s missing from the patient_data table so you’ll have to add it

1 Like

@stephenwaite problem solved thanks very much for the swift response.

1 Like