Unlink Quality Inspection from PR while cancelling QI
diff --git a/erpnext/buying/doctype/quality_inspection/quality_inspection.py b/erpnext/buying/doctype/quality_inspection/quality_inspection.py
index d1d9518..8d85715 100644
--- a/erpnext/buying/doctype/quality_inspection/quality_inspection.py
+++ b/erpnext/buying/doctype/quality_inspection/quality_inspection.py
@@ -28,15 +28,12 @@
frappe.db.sql("""update `tabPurchase Receipt Item` t1, `tabPurchase Receipt` t2
set t1.qa_no = %s, t2.modified = %s
where t1.parent = %s and t1.item_code = %s and t1.parent = t2.name""",
- (self.name, self.modified, self.purchase_receipt_no,
- self.item_code))
+ (self.name, self.modified, self.purchase_receipt_no, self.item_code))
def on_cancel(self):
if self.purchase_receipt_no:
- frappe.db.sql("""update `tabPurchase Receipt Item` t1, `tabPurchase Receipt` t2
- set t1.qa_no = '', t2.modified = %s
- where t1.parent = %s and t1.item_code = %s and t1.parent = t2.name""",
- (self.modified, self.purchase_receipt_no, self.item_code))
+ frappe.db.sql("""update `tabPurchase Receipt Item` set qa_no = '', modified=%s
+ where qa_no = %s""", (self.modified, self.name))
def item_query(doctype, txt, searchfield, start, page_len, filters):
if filters.get("from"):