Error "Unknown column 'is_zero_rated' in 'SELECT'" in VAT Audit Report

ERPNext Reports
1

I bump into this error when opening VAT Audit Rport

pymysql.err.OperationalError: (1054, “Unknown column ‘is_zero_rated’ in ‘SELECT’”)
Possible source of error: erpnext (app)

I do not use custom app and I do not understand why this error happen.

I use frappe cloud for erpnext with some apps installed (Erpnext related) with additional third party app POSNext app.

Please help

### App Versions

```

{

“erpnext”: “15.93.0”,

“famila_custom_reports”: “0.0.1”,

“frappe”: “15.93.0”,

“hrms”: “15.54.1”,

“insights”: “2.2.10”,

“payments”: “0.0.1”,

“print_designer”: “1.6.5”

}

```

### Route

```

query-report/VAT Audit Report

```

### Traceback

```

Traceback (most recent call last):

File “apps/frappe/frappe/app.py”, line 120, in application

response = frappe.api.handle(request)

           ^^^^^^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/api/_init_.py”, line 52, in handle

data = endpoint(\*\*arguments)

       ^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/api/v1.py”, line 40, in handle_rpc_call

return frappe.handler.handle()

       ^^^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/handler.py”, line 53, in handle

data = execute_cmd(cmd)

       ^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/handler.py”, line 86, in execute_cmd

return frappe.call(method, \*\*frappe.form_dict)

       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/_init_.py”, line 1754, in call

return fn(\*args, \*\*newargs)

       ^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/utils/typing_validations.py”, line 32, in wrapper

return func(\*args, \*\*kwargs)

       ^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/_init_.py”, line 891, in wrapper_fn

retval = fn(\*args, \*\*get_newargs(fn, kwargs))

         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/desk/query_report.py”, line 229, in run

result = generate_report_result(report, filters, user, custom_columns, is_tree, parent_field)

         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/_init_.py”, line 891, in wrapper_fn

retval = fn(\*args, \*\*get_newargs(fn, kwargs))

         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/desk/query_report.py”, line 85, in generate_report_result

res = get_report_result(report, filters) or \[\]

      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/desk/query_report.py”, line 66, in get_report_result

res = report.execute_script_report(filters)

      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/core/doctype/report/report.py”, line 179, in execute_script_report

res = self.execute_module(filters)

      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “apps/frappe/frappe/core/doctype/report/report.py”, line 195, in execute_module

return frappe.get_attr(method_name)(frappe.\_dict(filters))

       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “apps/erpnext/erpnext/regional/report/vat_audit_report/vat_audit_report.py”, line 13, in execute

return VATAuditReport(filters).run()

       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “apps/erpnext/erpnext/regional/report/vat_audit_report/vat_audit_report.py”, line 40, in run

self.get_invoice_items(doctype)

File “apps/erpnext/erpnext/regional/report/vat_audit_report/vat_audit_report.py”, line 82, in get_invoice_items

items = frappe.db.sql(

        ^^^^^^^^^^^^^^

File “apps/frappe/frappe/database/database.py”, line 230, in sql

self.\_cursor.execute(query, values)

File “env/lib/python3.11/site-packages/pymysql/cursors.py”, line 153, in execute

result = self.\_query(query)

         ^^^^^^^^^^^^^^^^^^

File “env/lib/python3.11/site-packages/pymysql/cursors.py”, line 322, in _query

conn.query(q)

File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 563, in query

self.\_affected_rows = self.\_read_query_result(unbuffered=unbuffered)

                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 825, in _read_query_result

result.read()

File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 1199, in read

first_packet = self.connection.\_read_packet()

               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File “env/lib/python3.11/site-packages/pymysql/connections.py”, line 775, in _read_packet

packet.raise_for_error()

File “env/lib/python3.11/site-packages/pymysql/protocol.py”, line 219, in raise_for_error

err.raise_mysql_exception(self.\_data)

File “env/lib/python3.11/site-packages/pymysql/err.py”, line 150, in raise_mysql_exception

raise errorclass(errno, errval)

pymysql.err.OperationalError: (1054, “Unknown column ‘is_zero_rated’ in ‘SELECT’”)

```

### Request Data

```

{

“type”: “GET”,

“args”: {

“report_name”: “VAT Audit Report”,

“filters”: “{\“company\”:\“Famila Abadi Makmur\”,\“from_date\”:\“2025-10-30\”,\“to_date\”:\“2025-12-30\”}”,

“ignore_prepared_report”: false,

“are_default_filters”: true

},

“headers”: {},

“error_handlers”: {},

“url”: “/api/method/frappe.desk.query_report.run”,

“request_id”: “67f3d924-f33f-475d-b6a6-71b680c7dae6”

}

```

### Response Data

```

{

“exception”: “pymysql.err.OperationalError: (1054, \“Unknown column ‘is_zero_rated’ in ‘SELECT’\”)”,

“exc_type”: “OperationalError”,

“_exc_source”: “erpnext (app)”

}

```