Issues with Item Tax Rate

[vorasmit]

Introduction

Item tax rate is a field that's updated in items table (eg: Sales Invoice Item) and used to update total taxes.

Workflow: Item Tax Template => Updates Item Tax Rate => Updates Final Taxes.

Hence it's crucial to ensure Item tax template and Item tax rate are consistent.

eg: Item Tax Rate:
{"Output Tax SGST - RT": 6.0, "Output Tax CGST - RT": 6.0, "Output Tax IGST - RT": 12.0, "Input Tax SGST - RT": 6.0, "Input Tax CGST - RT": 6.0, "Input Tax IGST - RT": 12.0, "Input Tax SGST RCM - RT": 6.0, "Input Tax CGST RCM - RT": 6.0, "Input Tax IGST RCM - RT": 12.0}

Issues

We found following two cases where it's inconsistent.

Item tax rate is only updated in UI and not backend.

Reference: Function: get_item_tax_info

This causes issues when trying to use data import tool to import transactions.

Item tax rate is set even after Item Tax Template is removed

Steps on how to replicate this issue

• Create one item with only one item tax template
• Create a transaction for this item. This should auto-fetch item tax template.
• Unset item tax template from the item. Save

With unset, it doesn't unset item tax rate, causing incorrect final taxes.

Module

accounts

Version

Frappe & ERPNext Develop

Installation method

None

Relevant log output / Stack trace / Full Error Message.

No response