| commit | be9fe7331a7eb7a5bab2b7f92a91fc9f399050a3 | [log] [tgz] |
|---|---|---|
| author | barredterra <14891507+barredterra@users.noreply.github.com> | Wed Mar 20 19:37:34 2024 +0100 |
| committer | barredterra <14891507+barredterra@users.noreply.github.com> | Wed Mar 20 19:37:34 2024 +0100 |
| tree | 479f3c59144aef2e2d232c7e6e80ecf42cf4a69e | |
| parent | 1714ac65870191d7ceaf6ca3276723c8e9220ad2 [diff] |
perf: query one item price only
diff --git a/erpnext/stock/get_item_details.py b/erpnext/stock/get_item_details.py index 12049f1..019be8a 100644 --- a/erpnext/stock/get_item_details.py +++ b/erpnext/stock/get_item_details.py
@@ -911,6 +911,7 @@ .orderby(ip.valid_from, order=frappe.qb.desc) .orderby(IfNull(ip.batch_no, ""), order=frappe.qb.desc) .orderby(ip.uom, order=frappe.qb.desc) + .limit(1) ) if not ignore_party: