details: https://code.openbravo.com/erp/devel/pi/rev/5b802926a14d
changeset: 24211:5b802926a14d
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Mon Aug 04 19:31:00 2014 +0530
summary: Fixes Issue 0026959: Wrong Reservation status under some
circumstances
diffstat:
src-db/database/model/triggers/M_RESERVATION_TRG.xml | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diffs (22 lines):
diff -r afb3f52f139e -r 5b802926a14d
src-db/database/model/triggers/M_RESERVATION_TRG.xml
--- a/src-db/database/model/triggers/M_RESERVATION_TRG.xml Tue Aug 05
01:30:44 2014 +0530
+++ b/src-db/database/model/triggers/M_RESERVATION_TRG.xml Mon Aug 04
19:31:00 2014 +0530
@@ -15,7 +15,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
-* All portions are Copyright (C) 2012-2013 Openbravo SLU
+* All portions are Copyright (C) 2012-2014 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************/
@@ -49,7 +49,8 @@
IF (:NEW.res_status NOT IN ('DR', 'CL') AND :NEW.c_orderline_id IS NOT
NULL) THEN
UPDATE c_orderline
SET so_res_status = CASE WHEN :NEW.quantity = :NEW.reservedqty THEN 'CR'
- ELSE 'PR'
+ WHEN :NEW.quantity > :NEW.reservedqty AND
:NEW.reservedqty > 0 THEN 'PR'
+ ELSE 'NR'
END
WHERE c_orderline_id = :NEW.c_orderline_id;
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
