commit f7619df8b22e4579d27f1150f76b6b9e94823147
author Rucha Mahabal <ruchamahabal2@gmail.com> Tue Sep 08 11:57:45 2020 +0530
committer GitHub <noreply@github.com> Tue Sep 08 11:57:45 2020 +0530
tree 4778962f42344289113cad6bf738a4635fa95713
parent 9691422fb766b9d0f628fd9a5a1c712376896ddf

fix: Lock row in subquery while setting delivered qty (#23100)

erpnext/controllers/status_updater.py

diff --git a/erpnext/controllers/status_updater.py b/erpnext/controllers/status_updater.py
index 0dc9878..9feac78 100644
--- a/erpnext/controllers/status_updater.py
+++ b/erpnext/controllers/status_updater.py
@@ -255,7 +255,7 @@
 				args['second_source_condition'] = """ + ifnull((select sum(%(second_source_field)s)
 					from `tab%(second_source_dt)s`
 					where `%(second_join_field)s`="%(detail_id)s"
-					and (`tab%(second_source_dt)s`.docstatus=1) %(second_source_extra_cond)s), 0) """ % args
+					and (`tab%(second_source_dt)s`.docstatus=1) %(second_source_extra_cond)s FOR UPDATE), 0)""" % args
 
 			if args['detail_id']:
 				if not args.get("extra_cond"): args["extra_cond"] = ""