diff --git a/erpnext/stock/get_item_details.py b/erpnext/stock/get_item_details.py index 70e7d88c7d5ffe75bbe976b0af56e2924e3a78ab..85d1cbcf5056f93a7c56ef02e7b9cb3e796a6c3d 100644 --- a/erpnext/stock/get_item_details.py +++ b/erpnext/stock/get_item_details.py @@ -1775,8 +1775,10 @@ def get_best_buying_price(args, item_code): if args.get("price_list"): query = query.where(ip.price_list == args.get("price_list")) else: - buying_price_lists = frappe.get_all("Price List", filters={"buying": 1, "enabled": 1}, pluck="name") - query = query.where(ip.price_list.isin(buying_price_lists)) + if buying_price_lists := frappe.get_all( + "Price List", filters={"buying": 1, "enabled": 1}, pluck="name" + ): + query = query.where(ip.price_list.isin(buying_price_lists)) if args.get("transaction_date"): query = query.where(