Hello,
Please update to the latest version of India Compliance. We added a patch to fix this a couple of days ago:
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,
- Tax Rate (comes from Item tax template)
- 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.
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)
