Try ERPNext Buy Support Partners Foundation

pymysql.err.InternalError: (1054, "Unknown column 'gst_category' in 'field list'") HC

Hi,
I am unable to create an appointment for a patient.
pymysql.err.InternalError: (1054, “Unknown column ‘gst_category’ in ‘field list’”)

Hi,

It may help to say what version ERPNext, and whether this is happening on first use or if appointments were made successfully in the past and this message in something new.

It is V12, yes for the first use of appointments. I have just downloaded VM image of the Production Box.

Has the patient been set up as customer as well as a patient? The field gst_category field is found in other doctypes but as far as I can tell, not in Patient. Have customizations been made?

<OM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE ‘gst_category%’;
WARNING: terminal is not fully functional
±--------------------±-------------+
| TABLE_NAME | COLUMN_NAME |
±--------------------±-------------+
| tabCustomer | gst_category |
| tabPurchase Invoice | gst_category |
| tabSales Invoice | gst_category |
| tabSupplier | gst_category |
±--------------------±-------------+
4 rows in set (0.05 sec)

Hi @smino, I am first time user of ERPNext, can you let me know the procedure for setting up the customization of HealthCare or direct me to the relevant documentation if exist?

These links may not deal with Healthcare, specifically. They can be used as an introduction to customization in general:

https://docs.erpnext.com/docs/user/manual/en/customize-erpnext

https://www.youtube.com/watch?v=WSzkpPm3iIU

I would rather recommend you, temporarily switch to any other country than India. Save. And, again select your preferred country or India (If it was earlier or Vice-versa).

This also happens when we do not set any country on the Price List.

@asharamseervi I did that ,but no change.