diff --git a/erpnext/stock/get_item_details.py b/erpnext/stock/get_item_details.py index 6db5b16d955bd5a55a259bfe0fae7c1cc153251c..fcaffe75202ca56d1ecf27701095a12753638369 100644 --- a/erpnext/stock/get_item_details.py +++ b/erpnext/stock/get_item_details.py @@ -1619,8 +1619,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(