From 9642ac71ff63e6a95a130267bf0285dfe1231c59 Mon Sep 17 00:00:00 2001 From: Nabin Hait Date: Fri, 17 Jan 2025 16:51:07 +0530 Subject: [PATCH] fix: Ambiguous column error while creating Sales Return (#45275) --- erpnext/controllers/sales_and_purchase_return.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/erpnext/controllers/sales_and_purchase_return.py b/erpnext/controllers/sales_and_purchase_return.py index 3739367676..c534b00c88 100644 --- a/erpnext/controllers/sales_and_purchase_return.py +++ b/erpnext/controllers/sales_and_purchase_return.py @@ -261,7 +261,7 @@ def get_already_returned_items(doc): ) data = frappe.db.sql( f""" - select {column}, {field} + select {column}, child.{field} from `tab{doc.doctype} Item` child, `tab{doc.doctype}` par where -- GitLab