Help With This Error

pymysql.err.InternalError: (1054, “Unknown column ‘b.stock_entry_type’ in ‘field list’”)

In Material Transfer For Consumption. I am Unable to submit this request. it gives me the Above Error.

Kindly Let me know what i can do to solve it.

Thank you!

please kindly provide reproducible steps with sample data and error screen shot, also mention which version you are using.

Hello @szufisher Thank you for Replying

I am using ERP V12

Here is what i am trying to do

  1. Create Material Receipt for Consumption Sending from One warehouse to FG warehouse.
  2. Upon selecting all the mandatory field.
  3. I save the receipt.
  4. upon submitting it. It gives me this error pymysql.err.InternalError: (1054, “Unknown column ‘b.stock_entry_type’ in ‘field list’”)

And this report

Once i click on this Report i get codes which is too long to take screenshot. Let me know if i can paste it.

The same is when i got to Manufacturing under work order

  1. I create Work Order.
  2. When i click on Material Consumption i again get the following error

below is the Screenshot of it.

Let me know if you need any other information.

As I can not simulate the your case because I am using version 13, from the error message, it maybe caused by either your customized script code or hooked event code or simply a bug on version12, anyway you got to get developer’s help.

Hello @szufisher happy to let you know that I’ve solved the issue. It was rather simple mistake in my end