[Fix] TDS Payable Monthly report is not working (#15666)
diff --git a/erpnext/accounts/report/tds_payable_monthly/tds_payable_monthly.js b/erpnext/accounts/report/tds_payable_monthly/tds_payable_monthly.js
index 232d053..344539e 100644
--- a/erpnext/accounts/report/tds_payable_monthly/tds_payable_monthly.js
+++ b/erpnext/accounts/report/tds_payable_monthly/tds_payable_monthly.js
@@ -8,6 +8,7 @@
"fieldname":"company",
"label": __("Company"),
"fieldtype": "Link",
+ "options": "Company",
"default": frappe.defaults.get_default('company')
},
{
diff --git a/erpnext/accounts/report/tds_payable_monthly/tds_payable_monthly.py b/erpnext/accounts/report/tds_payable_monthly/tds_payable_monthly.py
index 8e5723f..843b58f 100644
--- a/erpnext/accounts/report/tds_payable_monthly/tds_payable_monthly.py
+++ b/erpnext/accounts/report/tds_payable_monthly/tds_payable_monthly.py
@@ -64,13 +64,16 @@
total_amount_credited += k.credit
rate = [i.tax_withholding_rate for i in tds_doc.rates
- if i.fiscal_year == gle_map[d][0].fiscal_year][0]
+ if i.fiscal_year == gle_map[d][0].fiscal_year]
- if getdate(filters.from_date) <= gle_map[d][0].posting_date \
- and getdate(filters.to_date) >= gle_map[d][0].posting_date:
- out.append([supplier.pan, supplier.name, tds_doc.name,
- supplier.supplier_type, rate, total_amount_credited, tds_deducted,
- gle_map[d][0].posting_date, "Purchase Invoice", d])
+ if rate and len(rate) > 0:
+ rate = rate[0]
+
+ if getdate(filters.from_date) <= gle_map[d][0].posting_date \
+ and getdate(filters.to_date) >= gle_map[d][0].posting_date:
+ out.append([supplier.pan, supplier.name, tds_doc.name,
+ supplier.supplier_type, rate, total_amount_credited, tds_deducted,
+ gle_map[d][0].posting_date, "Purchase Invoice", d])
return out