details: https://code.openbravo.com/erp/stable/2.50/rev/efb0761dac7e
changeset: 9817:efb0761dac7e
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Fri Feb 24 08:58:06 2012 +0100
summary: Fixes issue 19859: The "Goods Shipment" selector it doesn't work
properly.
Now only dissapears the shipments where the related order has invoice term
'After Order Delivered' and is not completely delivered.
diffstat:
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql | 4
++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (18 lines):
diff -r d733a87972b5 -r efb0761dac7e
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
Thu Feb 16 11:01:50 2012 +0100
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
Fri Feb 24 08:58:06 2012 +0100
@@ -373,12 +373,12 @@
WHERE o.C_ORDER_ID = s.C_ORDER_ID
AND o.C_ORDER_ID = ic.C_ORDER_ID
AND ic.term = 'N')
- AND EXISTS (SELECT 1
+ AND NOT EXISTS (SELECT 1
FROM C_ORDER o , C_ORDERLINE ol
WHERE o.C_ORDER_ID = s.C_ORDER_ID
AND o.C_ORDER_ID = ol.C_ORDER_ID
GROUP BY o.INVOICERULE
- HAVING o.INVOICERULE <> 'O' OR (SUM(ol.qtyordered) =
SUM(ol.qtydelivered)))
+ HAVING (o.INVOICERULE = 'O' AND SUM(ol.qtyordered) <>
SUM(ol.qtydelivered)))
ORDER BY NAME
]]>
</Sql>
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
