details: https://code.openbravo.com/erp/devel/pi/rev/afb3f52f139e
changeset: 24210:afb3f52f139e
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Tue Aug 05 01:30:44 2014 +0530
summary: Fixes Issue 26831:Sales order shows reservation status as partially
reserved
though there is no reservation.
diffstat:
src-db/database/model/functions/C_ORDER_POST1.xml | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diffs (13 lines):
diff -r 5e90aad08cf4 -r afb3f52f139e
src-db/database/model/functions/C_ORDER_POST1.xml
--- a/src-db/database/model/functions/C_ORDER_POST1.xml Tue Aug 05 07:19:17
2014 +0200
+++ b/src-db/database/model/functions/C_ORDER_POST1.xml Tue Aug 05 01:30:44
2014 +0530
@@ -1254,7 +1254,8 @@
-- Update so_res_status
UPDATE c_orderline
SET so_res_status = CASE WHEN cur_orderline.qtyordered =
v_reservedqty THEN 'CR'
- ELSE 'PR'
+ WHEN cur_orderline.qtyordered >
v_reservedqty AND v_reservedqty > 0 THEN 'PR'
+ ELSE 'NR'
END
WHERE c_orderline_id = cur_orderline.c_orderline_id;
END IF;
------------------------------------------------------------------------------
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
