fix: asset requiring maintenance sold status
diff --git a/erpnext/assets/doctype/asset/asset.py b/erpnext/assets/doctype/asset/asset.py
index 8ac7ed6..83e0f02 100644
--- a/erpnext/assets/doctype/asset/asset.py
+++ b/erpnext/assets/doctype/asset/asset.py
@@ -660,7 +660,18 @@
elif self.docstatus == 1:
status = "Submitted"
- if self.journal_entry_for_scrap:
+ is_asset_sold = frappe.db.sql(
+ """
+ select item.parent
+ from `tabSales Invoice Item` item, `tabSales Invoice` p
+ where item.asset=%s and item.parent = p.name and p.docstatus = 1
+ """,
+ self.name,
+ )
+
+ if is_asset_sold:
+ status = "Sold"
+ elif self.journal_entry_for_scrap:
status = "Scrapped"
elif self.finance_books:
idx = self.get_default_finance_book_idx() or 0