[WebERP-developers] Transaction's Rollback failed

[ExsonQu <hex...@gm...>]

*Dear all,*

               I found a serious problem in WorkOrderReceive.php during
fixing a bug.

              The transaction roll back failed for following query statement
( It's around at line 450~454). 

                      	$SQL = "UPDATE locstock
				SET quantity = locstock.quantity + " . $QuantityReceived . "
				WHERE locstock.stockid = '" . $_POST['StockID'] . "'
				AND loccode = '" . $_POST['IntoLocation'] . "'";

                 All of others queries have been rolled back, but only this
one failed. It leads to stock quantity updated so the inventory quantity
become a mess. 

               Any comments are highly appreciated!

               Thanks in advance!

               Best regards!

               Exson

                 
             



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Transaction-s-Rollback-failed-tp4658233.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.