commit ce75fe0ec405c68f1c5dd7b4a5d1bbde1af70705
author Ankush Menat <ankush@frappe.io> Fri Apr 22 11:44:30 2022 +0530
committer Ankush Menat <ankush@frappe.io> Tue Apr 26 11:03:32 2022 +0530
tree 179312f1c6e2ca4c1eef4fbe930c16cb3005b29f
parent cdac2b8c63e5856498e5c4cbcc871a1178f7cb80

fix: out of range date value

erpnext/stock/doctype/stock_entry/stock_entry.py

diff --git a/erpnext/stock/doctype/stock_entry/stock_entry.py b/erpnext/stock/doctype/stock_entry/stock_entry.py
index c4aa8a4..27a6eaf 100644
--- a/erpnext/stock/doctype/stock_entry/stock_entry.py
+++ b/erpnext/stock/doctype/stock_entry/stock_entry.py
@@ -1167,7 +1167,7 @@
 			from `tabItem` i LEFT JOIN `tabItem Default` id ON i.name=id.parent and id.company=%s
 			where i.name=%s
 				and i.disabled=0
-				and (i.end_of_life is null or i.end_of_life='0000-00-00' or i.end_of_life > %s)""",
+				and (i.end_of_life is null or i.end_of_life<'1900-01-01' or i.end_of_life > %s)""",
 			(self.company, args.get("item_code"), nowdate()),
 			as_dict=1,
 		)