details:   https://code.openbravo.com/erp/devel/pi/rev/e3ce9604cae9
changeset: 14784:e3ce9604cae9
user:      Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
date:      Wed Nov 30 23:53:50 2011 +0100
summary:   Fixed bug 19204:
P&E button. Prices that have been edited are overwritten when clicking again 
the button

diffstat:

 src-db/database/model/views/C_RM_ORDER_PICK_EDIT_LINES.xml |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r c988198065c0 -r e3ce9604cae9 
src-db/database/model/views/C_RM_ORDER_PICK_EDIT_LINES.xml
--- a/src-db/database/model/views/C_RM_ORDER_PICK_EDIT_LINES.xml        Wed Nov 
30 23:46:25 2011 +0100
+++ b/src-db/database/model/views/C_RM_ORDER_PICK_EDIT_LINES.xml        Wed Nov 
30 23:53:50 2011 +0100
@@ -4,7 +4,7 @@
 CASE
 WHEN rol.c_orderline_id IS NOT NULL THEN 'Y'
 ELSE 'N'
-END AS ob_selected, il.m_inoutline_id, rol.c_order_id AS returnorderid, 
i.documentno AS inoutno, i.movementdate, il.m_product_id, 
il.m_attributesetinstance_id, il.movementqty, il.c_uom_id, (-1) * 
rol.qtyordered AS returned, rol.priceactual, rol.c_return_reason_id, 
o.documentno AS orderno, i.issotrx, (-1) * retol.returnedqty AS returnedqty
+END AS ob_selected, il.m_inoutline_id, rol.c_order_id AS returnorderid, 
i.documentno AS inoutno, i.movementdate, il.m_product_id, 
il.m_attributesetinstance_id, il.movementqty, il.c_uom_id, (-1) * 
rol.qtyordered AS returned, COALESCE(rol.priceactual, ol.priceactual) AS 
priceactual, rol.c_return_reason_id, o.documentno AS orderno, i.issotrx, (-1) * 
retol.returnedqty AS returnedqty
 FROM m_inoutline il
 JOIN m_inout i ON il.m_inout_id = i.m_inout_id AND i.processed = 'Y' AND 
i.docstatus <> 'VO'
 JOIN c_doctype dt ON i.c_doctype_id = dt.c_doctype_id AND dt.isreturn = 'N'

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to