India Compliance Patch throwing error

ERPNext
1

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

Thanks

2

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

Regards,
Lakshit Jain

3

Many thanks @Lakshit_Jain

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

Thanks again

4

Hello,

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.

Regards,

Lakshit Jain