Merge pull request #26683 from deepeshgarg007/tds_194q_fix
fix(minor): Consider grand total for threshold check
diff --git a/erpnext/accounts/doctype/tax_withholding_category/tax_withholding_category.py b/erpnext/accounts/doctype/tax_withholding_category/tax_withholding_category.py
index 45c8e1b..020de3c 100644
--- a/erpnext/accounts/doctype/tax_withholding_category/tax_withholding_category.py
+++ b/erpnext/accounts/doctype/tax_withholding_category/tax_withholding_category.py
@@ -243,10 +243,13 @@
'docstatus': 1
}
+ field = 'sum(net_total)'
+
if not cint(tax_details.consider_party_ledger_amount):
invoice_filters.update({'apply_tds': 1})
+ field = 'sum(grand_total)'
- supp_credit_amt = frappe.db.get_value('Purchase Invoice', invoice_filters, 'sum(net_total)') or 0.0
+ supp_credit_amt = frappe.db.get_value('Purchase Invoice', invoice_filters, field) or 0.0
supp_jv_credit_amt = frappe.db.get_value('Journal Entry Account', {
'parent': ('in', vouchers), 'docstatus': 1,