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

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

Well, I never said it’s difficult. I just wanted to see how it’s setup as with the below settings in Chart of Account for Purchase GST, Item Tax Template and Tax in Item, I don’t see the tax fetched automatically when an Item is added to a Purchase Order for example:

Chart of Accounts:

Item Tax Template:

Here is the tax rate assigned to the item that I want to be updated when the item code is inserted:

Here is how it looks when the item code is entered: (Tax is still showing 18% where as it should be 12% in this case, the rate didn’t update after entering the item code)

my reply wasn’t meant for you…
I was simply asking Smit
Regards
Frz

We know it can be simplified and we are working on it.

However its a little more complex from an implementation perspective

  • We have to patch existing data or settings
  • We need to maintain backward compatibility
  • We also need to take care of specific use cases (even though they may not be applicable to 95% of transactions)

I hope you understand and appreciate your patience.

1 Like

Ah! sorry, my bad. @Frz @Smit_Vora can you please help with my issue or direct me to someone that can help? I am unable to create Purchase Order with different tax rates on multiple products on version 14 due to this. I would really appreciate some help here. Thanks for your time in advance.

@Smit_Vora, I am facing the same. Please take this on priority.

Hi @roshrnair, not sure if you saw my message earlier, but can you please confirm if the item tax is still auto-populating for you while creating purchase and sales order in version 14? I have still not been able to get it working. Can you please help?

Not sure whether you were able to resolve your issue. As mentioned by @roshrnair follow this for Item tax template.

Tax rules for sales and purchase.