details: https://code.openbravo.com/erp/devel/pi/rev/56870c4b2bd0
changeset: 32725:56870c4b2bd0
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Tue Sep 19 23:11:32 2017 +0530
summary: Fixes issue 36870: After delivery invoice terms excludes services
while Customer Schedule After Delivery doesn't.
Create Line From popup order selector strictly considered that all lines should
be delivered
in the order with invoice term "Customer Schedule After Delivery". Change the
condition
same as "After Delivery" invoice term.
diffstat:
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql | 2
+-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 16a1e0e90f6c -r 56870c4b2bd0
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
Wed Sep 20 09:21:47 2017 +0200
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
Tue Sep 19 23:11:32 2017 +0530
@@ -161,7 +161,7 @@
AND ic.C_BPartner_ID = ?
AND pl.istaxincluded = ?
AND o.C_Order_Id = ic.C_Order_Id
- AND ((ic.term = 'D' AND ic.qtydelivered <>0) OR (ic.term = 'I' AND
exists (SELECT 1 FROM C_ORDERLINE ol WHERE ol.C_ORDER_ID = o.C_ORDER_ID group
by ol.c_orderline_id having SUM(ol.QTYORDERED)-SUM(ol.QTYINVOICED)<>0)) OR
(ic.term IN ('O','S') AND (ic.qtyordered = ic.qtydelivered) ) )
+ AND ((ic.term IN ('D', 'S') AND ic.qtydelivered <> 0) OR (ic.term =
'I' AND exists (SELECT 1 FROM C_ORDERLINE ol WHERE ol.C_ORDER_ID = o.C_ORDER_ID
group by ol.c_orderline_id having SUM(ol.QTYORDERED) - SUM(ol.QTYINVOICED) <>
0)) OR (ic.term = 'O' AND (ic.qtyordered = ic.qtydelivered)))
GROUP BY o.C_ORDER_ID, o.DocumentNo, o.DateOrdered, o.GrandTotal
ORDER BY NAME
]]>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
