commit 0c0c34567874dc126367a8a9196302f1c8767544
author Nabin Hait <nabinhait@gmail.com> Mon Jul 23 14:38:40 2018 +0530
committer Nabin Hait <nabinhait@gmail.com> Mon Jul 23 14:38:50 2018 +0530
tree eca01d5f5f9286dfdd12f62e2c7149dc954e3f63
parent 20a80fee454a88d7618b1d9dd3a44972ab2a303d

Added index on SLE based on batch_no, item and warehouse

erpnext/stock/doctype/stock_ledger_entry/stock_ledger_entry.py

diff --git a/erpnext/stock/doctype/stock_ledger_entry/stock_ledger_entry.py b/erpnext/stock/doctype/stock_ledger_entry/stock_ledger_entry.py
index 085e87f..3c60896 100644
--- a/erpnext/stock/doctype/stock_ledger_entry/stock_ledger_entry.py
+++ b/erpnext/stock/doctype/stock_ledger_entry/stock_ledger_entry.py
@@ -131,3 +131,5 @@
 			add index posting_sort_index(posting_date, posting_time, name)""")
 
 	frappe.db.add_index("Stock Ledger Entry", ["voucher_no", "voucher_type"])
+	frappe.db.add_index("Stock Ledger Entry", ["batch_no", "item_code", "warehouse"])
+