commit 5d8bf56cb9741a5cb3e0f1df9873df3b888d4a3e
author rohitwaghchaure <rohitw1991@gmail.com> Mon Apr 24 18:06:37 2023 +0530
committer GitHub <noreply@github.com> Mon Apr 24 18:06:37 2023 +0530
tree a1cbc2e071a9f9fbda24dcc2350280ca6dd68f11
parent ed14d1ce443e87ba69b1960eb08854af4d62e39e
parent 02c3b41dc27f4826b63b5694862af7c0ce9dc7e1

Merge pull request #35012 from rohitwaghchaure/fixed-incorrect-bom-end-of-life

fix: item not showing in the BOM

erpnext/manufacturing/doctype/bom/bom.py

diff --git a/erpnext/manufacturing/doctype/bom/bom.py b/erpnext/manufacturing/doctype/bom/bom.py
index a085af8..b53149a 100644
--- a/erpnext/manufacturing/doctype/bom/bom.py
+++ b/erpnext/manufacturing/doctype/bom/bom.py
@@ -1317,7 +1317,7 @@
 		if not field in searchfields
 	]
 
-	query_filters = {"disabled": 0, "end_of_life": (">", today())}
+	query_filters = {"disabled": 0, "ifnull(end_of_life, '3099-12-31')": (">", today())}
 
 	or_cond_filters = {}
 	if txt: