Fee Sheet Error in V7

Day-to-Day Users
#1

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

error
error1659×757 59.5 KB

#2

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

Screenshot from 2023-01-02 15-53-43
Screenshot from 2023-01-02 15-53-43983×505 62.1 KB

1 Like
#3

@stephenwaite i dont see anything on the demographics

#4

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

1 Like
#5

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

1 Like