India Compliance Patch throwing error

Hi ,

While trying to update bench, the India Compliance app is throwing the error below:

Executing india_compliance.patches.post_install.update_gst_treatment_for_taxable_nil_transaction_item

Syntax error in query:
UPDATE `tabSales Invoice Item` SET `gst_treatment`=%(param1)s WHERE `item_tax_template` IN () AND `gst_treatment`=%(param2)s {'param1': 'Nil-Rated', 'param2': 'Taxable'}

pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND `gst_treatment`='Taxable'' at line 1")

Pls help fix


Hello @wale

We have fixed the issue in develop branch.
We will update you once the fix has been released.
You can track PR here: fix: return if no nil rated templates by ljain112 · Pull Request #1570 · resilient-tech/india-compliance · GitHub

Lakshit Jain

Many thanks @Lakshit_Jain

I really appreciate your fast rresponse. Will keep track of the PR as advised

Thanks again


The fix for the issue has been released in the latest version of the India Compliance App. You can find the release details at:

Please ensure that you update your app to the latest version in order to resolve the issue.


Lakshit Jain