commit 49e4693abf6314de9973b735a07954395a0748b5
author Saqib Ansari <nextchamp.saqib@gmail.com> Thu Mar 04 11:58:45 2021 +0530
committer Saqib Ansari <nextchamp.saqib@gmail.com> Thu Mar 04 11:58:45 2021 +0530
tree 21fb1e4c6e0e18d7fd802d4c495c90fa83267086
parent d713ac45055874fcd0fd4dd9ebd98851fe08224d

fix(patch): updating pos closing reference in merge log

erpnext/patches/v13_0/update_pos_closing_entry_in_merge_log.py

diff --git a/erpnext/patches/v13_0/update_pos_closing_entry_in_merge_log.py b/erpnext/patches/v13_0/update_pos_closing_entry_in_merge_log.py
index 42bca7c..262e38d 100644
--- a/erpnext/patches/v13_0/update_pos_closing_entry_in_merge_log.py
+++ b/erpnext/patches/v13_0/update_pos_closing_entry_in_merge_log.py
@@ -15,7 +15,7 @@
 				log.pos_closing_entry = (
 					SELECT clo_ref.parent FROM `tabPOS Invoice Reference` clo_ref
 					WHERE clo_ref.pos_invoice = log_ref.pos_invoice
-					AND clo_ref.parenttype = 'POS Closing Entry'
+					AND clo_ref.parenttype = 'POS Closing Entry' LIMIT 1
 				)
 			WHERE
 				log_ref.parent = log.name