From 729c3835dd2e0e3b349898fef720cbd53fb38fc7 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 d3e55f863b..116f498b82 100644 --- a/erpnext/controllers/sales_and_purchase_return.py +++ b/erpnext/controllers/sales_and_purchase_return.py @@ -259,7 +259,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