ERPNext Version 14 - Item Tax Template - GST Taxes not loading properly

Hi
we assigned the GST Tax 18% in Item Master.

While we make PO this item taxes list as below.

there is one tax to be loaded. but bunch of taxes loading.
Newly introduced GST Tax as Input and Output.

We installed India Compliance App for GST.
How can we assign GST taxes for Item Tax Template in V14.

Hello,

Please update to the latest version of India Compliance. We added a patch to fix this a couple of days ago:

https://github.com/resilient-tech/india-compliance/pull/220

Do we have a user manual for Indian compliance module setup and implementation?
The item tax template configuration is bit confussing. What is the purpose of TAX CATEGORY field? if a same item template has to be defined for all kind of sales wheather it is inter state or intra state?

The invoice template is also not showing tax rate and tax amount at line item level; which is a very basic need for a businesses who deal in multiple tax rates.

The tax breakup summary shows inconsistent / wrong data in case a same HSN with two or more type of tax rate are billed in a invoice. For example in footwear the HSN remains same 6404 however depending on the taxable value either 12 or 18 is applied to an item, in such cases if you have one footwear style with HSN 6404 and tax rate 12% and another footwear style with HSN 6404 and tax rate 18%.

The tax breakup summary shows the data in one line with correct amount but wrong GST%. ideally, it has be grouped at both HSN and tax level which at present is grouped at just HSN level.

1 Like

Yes, we do. It’s a part of the ERPNext v14 documentation itself:
https://docs.erpnext.com/docs/v14/user/manual/en/regional/india

We’re working on making this more comprehensive.

We do know there is still scope for improvement and almost all the points listed by you are part of the issues that we have noted down and will be working on.

We don’t currently have plans to display tax rate and amount at line item level in the standard Sales Invoice print format. Do you want to sponsor this feature?

@dollar_singh The issues mentioned by you also exist in version 13, and were not part of our initial release plan.

PS: Please create a different thread for separate issues - it helps keep the forum easy to navigate. The issues you’ve mentioned are unrelated to the issue being faced by @benjaminrosary.

We have updated the Latest version of India Compliance. After that Item wise Taxes Not loading in Taxes Section as below image.

We have assigned the Taxes in Item Master → Tax Tab → Item Tax Template.

For V14 Is anything to be assigned other than that. Please clarify.

You need to setup one of the following to load purchase taxes automatically:

  • A Purchase Taxes and Charges Template with Tax Category configured. Additionally, tax category can be set in the relevant Supplier or Address for accurate fetching.
  • A default Purchase Taxes and Charges Template for the relevant Company.
  • A Tax Rule based on which a tax template gets set.

You can read more about Tax Rules, Tax Templates and Tax Categories in the documentation:
https://docs.erpnext.com/docs/v13/user/manual/en/introduction


We are working on improving this flow so that taxes can be automatically added without requiring configuration of Tax Category. You can track it here:
https://github.com/resilient-tech/india-compliance/pull/223

2 Likes

Hi
In V13 We can able to Set Item Tax Template. There is no issue.

For V14 using India Compliance Item Tax Template not loading properly.

For India Compliance, Do you have any document to set the Item Tax Template.
Pls Help.

Hi

Any updates for Item Tax Template - GST Multiple Taxes not loading issue in V14.

Please refer to the post here and ensure you have made configurations appropriately.

Although only one tax account is chosen, item taxes are calculated appropriately at rates you have set for items.

1 Like

Hi
Thanks for your reply.

In V14 - after installing india-compliance app following Item Tax Template created automatically. Not created by us.


Item Tax Mapped in Item Master

But In Transactions Item tax Template taxes not loading as mentioned below.

Purchase Taxes and Charges there is no issue. For Item multiple Tax Template tax not loading.

In addition, do I set up the item tax template other than that for the V14 India-Compliance App.

There are 2 components here,

  1. Tax Rate (comes from Item tax template)
  2. Tax Template (may be required to be selected manually, for now, i.e in-state vs out-state)

Tax will be calculated on the tax accounts in the taxes and charges template at the rate you set in items.

Logical and better automation for the selection of Tax Templates automatically is in progress, and you shall see it in the next update.

You can now use Tax Rules or a default purchase taxes and charges template.
However, the issue that you pointed out → the Item tax template is working as it should be.

This is What I follow to autopopulate the tax on adding item either in Sales or Purchase Transaction.
Modified the “Item Tax Template” default settings.

Split GST rates for Intra State & Inter State
You can name it “In GST 5%” & “Out GST 5%”

In GST 5% should be as follows.

Out GST 5% should be as follows

Now for an Item or Item Group with 5% tax update as follows

Now you should see the tax rates and values auto-populating in sales and purchase transactions.

Some custom fields were added to Item Tax Template in V13 then Migrated to V14. and exported in the fixture.

getting error while migrating.

Installing india_compliance...
Updating DocTypes for india_compliance: [========================================] 100%
Setting up Income Tax...
Installation for India Compliance failed due to an error. Please try re-installing the app or report the issue on https://github.com/resilient-tech/india-compliance/issues/new if not resolved.
An error occurred while installing india_compliance: Customer: Fieldname column_break_66 appears multiple times in rows 70, 70
Traceback (most recent call last):
  File "apps/frappe/frappe/commands/site.py", line 413, in install_app
    _install_app(app, verbose=context.verbose, force=force)
  File "apps/frappe/frappe/installer.py", line 304, in install_app
    frappe.get_attr(after_install)()
  File "apps/india_compliance/india_compliance/install.py", line 55, in after_install
    raise e
  File "apps/india_compliance/india_compliance/install.py", line 39, in after_install
    setup_income_tax()
  File "apps/india_compliance/india_compliance/income_tax_india/setup.py", line 7, in after_install
    create_custom_fields(CUSTOM_FIELDS, update=True)
  File "apps/frappe/frappe/custom/doctype/custom_field/custom_field.py", line 209, in create_custom_fields
    create_custom_field(doctype, df, ignore_validate=ignore_validate)
  File "apps/frappe/frappe/custom/doctype/custom_field/custom_field.py", line 175, in create_custom_field
    custom_field.insert()
  File "apps/frappe/frappe/model/document.py", line 283, in insert
    self.run_post_save_methods()
  File "apps/frappe/frappe/model/document.py", line 1076, in run_post_save_methods
    self.run_method("on_update")
  File "apps/frappe/frappe/model/document.py", line 908, in run_method
    out = Document.hook(fn)(self, *args, **kwargs)
  File "apps/frappe/frappe/model/document.py", line 1260, in composer
    return composed(self, method, *args, **kwargs)
  File "apps/frappe/frappe/model/document.py", line 1242, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "apps/frappe/frappe/model/document.py", line 905, in fn
    return method_object(*args, **kwargs)
  File "apps/frappe/frappe/custom/doctype/custom_field/custom_field.py", line 87, in on_update
    validate_fields_for_doctype(self.dt)
  File "apps/frappe/frappe/core/doctype/doctype/doctype.py", line 1032, in validate_fields_for_doctype
    validate_fields(meta)
  File "apps/frappe/frappe/core/doctype/doctype/doctype.py", line 1458, in validate_fields
    check_unique_fieldname(meta.get("name"), d.fieldname)
  File "apps/frappe/frappe/core/doctype/doctype/doctype.py", line 1073, in check_unique_fieldname
    frappe.throw(
  File "apps/frappe/frappe/__init__.py", line 522, in throw
    msgprint(
  File "apps/frappe/frappe/__init__.py", line 490, in msgprint
    _raise_exception()
  File "apps/frappe/frappe/__init__.py", line 442, in _raise_exception
    raise raise_exception(msg)
frappe.core.doctype.doctype.doctype.UniqueFieldnameError: Customer: Fieldname column_break_66 appears multiple times in rows 70, 70

Please suggest.

Error is self-explanatory.

Go to Customize form → Customer → Delete duplicate row.

This post might help you with migration.

@Smit_Vora , Thanks. it’s resolved.

Team, Please help.

while submitting a quotation, an error shows the '‘Quotation’ object has no attribute ‘is_reverse_charge’

ERPNext: v14.9.0 (version-14)
Frappe Framework: v14.17.1 (version-14)
India Compliance: v14.0.5 (version-14)

Traceback (most recent call last):
  File "apps/frappe/frappe/app.py", line 69, in application
    response = frappe.api.handle()
  File "apps/frappe/frappe/api.py", line 54, in handle
    return frappe.handler.handle()
  File "apps/frappe/frappe/handler.py", line 45, in handle
    data = execute_cmd(cmd)
  File "apps/frappe/frappe/handler.py", line 83, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "apps/frappe/frappe/__init__.py", line 1587, in call
    return fn(*args, **newargs)
  File "apps/frappe/frappe/desk/form/save.py", line 23, in savedocs
    doc.save()
  File "apps/frappe/frappe/model/document.py", line 303, in save
    return self._save(*args, **kwargs)
  File "apps/frappe/frappe/model/document.py", line 325, in _save
    return self.insert()
  File "apps/frappe/frappe/model/document.py", line 257, in insert
    self.run_before_save_methods()
  File "apps/frappe/frappe/model/document.py", line 1039, in run_before_save_methods
    self.run_method("before_save")
  File "apps/frappe/frappe/model/document.py", line 908, in run_method
  File "apps/frappe/frappe/model/document.py", line 1260, in composer
  File "apps/frappe/frappe/model/document.py", line 1244, in runner
  File "apps/india_compliance/india_compliance/gst_india/overrides/transaction.py", line 724, in validate_transaction
    valid_accounts = validate_gst_accounts(doc, is_sales_transaction) or ()
  File "apps/india_compliance/india_compliance/gst_india/overrides/transaction.py", line 188, in validate_gst_accounts
    if doc.is_reverse_charge and (
AttributeError: 'Quotation' object has no attribute 'is_reverse_charge'```

Not sure why is_reverse_charge field is not created for you in Quotation Doctype.

Try running this in bench directory

bench execute india_compliance.gst_india.setup.create_custom_fields

This would create the fields if absent and should solve this issue.


PS: You should create a new issue for unrelated discussions.

2 Likes

Hi @roshrnair, can you please also share your GST settings in the Chart of Account for Purchase and Sales? I tried to change the Item Template and Item Tax as you described, and it’s still not auto-populating the tax rates.

why is setting up GST in erpnext v14 so diificult

small suggestion

item has GST tax rate-Both IGST & GST
any tax rule to check if in state or out state
if in state use GST
if out state use IGST

should be as simple as that
Regards
Frz