Healthcare Appointment

Hi,
I am testing the Healthcare module in ERPNext. In Healthcare >> Patient Appointment form I got the below error while booking & view Appointment record.

ERPNext: v9.x.x-develop (9893a2d) (develop)
Frappe Framework: v9.x.x-develop (ae6fa0b) (develop)

OperationalError: (1054, “Unknown column ‘tabSales Invoice.appointment’ in ‘where clause’”)

Thanks
– Ashfaq

Hi,

Your database is missing the appointment column in the table tabSales Invoice. You can add it by using custom field and add the field.

Thanks for you feedback.
Please let me know, should I add ‘appointment’ filed and tabSales table directly in mariaDB or It can be add thru DocType?

If using DocType, kindly mention the name.

Regards,
–Ashfaq

Try executing this command from your frappe-bench folder

bench --site sitename migrate

Not working after this command:

bench --site sitename migrate

Regards,
–Ashfaq

How can I determine the data type of tabSales Invoice.appointment, if I add it by Customize Form?

regards,
–Ashfaq

Add by custom field like this