[Fix] Supplier wise sales analytics report not showing item details which is added in purchase invoice with update stock (#15869)
diff --git a/erpnext/stock/report/supplier_wise_sales_analytics/supplier_wise_sales_analytics.py b/erpnext/stock/report/supplier_wise_sales_analytics/supplier_wise_sales_analytics.py
index 1d69429..8dec3d0 100644
--- a/erpnext/stock/report/supplier_wise_sales_analytics/supplier_wise_sales_analytics.py
+++ b/erpnext/stock/report/supplier_wise_sales_analytics/supplier_wise_sales_analytics.py
@@ -84,6 +84,14 @@
is_stock_item=1 and name=pri.item_code)""", as_dict=1):
item_supplier_map.setdefault(d.item_code, []).append(d.supplier)
+ for d in frappe.db.sql("""select pr.supplier, pri.item_code from
+ `tabPurchase Invoice` pr, `tabPurchase Invoice Item` pri
+ where pr.name=pri.parent and pr.docstatus=1 and
+ ifnull(pr.update_stock, 0) = 1 and pri.item_code=(select name from `tabItem`
+ where is_stock_item=1 and name=pri.item_code)""", as_dict=1):
+ if d.item_code not in item_supplier_map:
+ item_supplier_map.setdefault(d.item_code, []).append(d.supplier)
+
if supplier:
for item_code, suppliers in item_supplier_map.items():
if supplier not in suppliers: