fix: use primary key for link lookup (#36919)
diff --git a/erpnext/stock/report/stock_balance/stock_balance.py b/erpnext/stock/report/stock_balance/stock_balance.py
index 102c3e1..337b0ea 100644
--- a/erpnext/stock/report/stock_balance/stock_balance.py
+++ b/erpnext/stock/report/stock_balance/stock_balance.py
@@ -339,8 +339,10 @@
for field in ["item_code", "brand"]:
if not self.filters.get(field):
continue
-
- query = query.where(item_table[field] == self.filters.get(field))
+ elif field == "item_code":
+ query = query.where(item_table.name == self.filters.get(field))
+ else:
+ query = query.where(item_table[field] == self.filters.get(field))
return query