details: https://code.openbravo.com/erp/devel/pi/rev/c2a4ef7a3e2f
changeset: 16614:c2a4ef7a3e2f
user: Jon AlegrÃa <jon.alegria <at> openbravo.com>
date: Thu May 24 11:37:17 2012 +0200
summary: Fixes issue 0020574: Orders closed should appear in this report
diffstat:
modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
| 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 5d862719708d -r c2a4ef7a3e2f
modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
---
a/modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
Thu May 17 18:36:17 2012 +0200
+++
b/modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
Thu May 24 11:37:17 2012 +0200
@@ -52,7 +52,7 @@
AND O.C_BPARTNER_ID = BP.C_BPARTNER_ID
AND O.C_BPARTNER_LOCATION_ID = BPADD.C_BPARTNER_LOCATION_ID
AND O.C_ORDER_ID = OL.C_ORDER_ID
- AND O.DOCSTATUS IN ('CO','CL')
+ AND O.DOCSTATUS = 'CO'
AND O.ISSOTRX = 'Y'
AND OL.M_PRODUCT_ID = PR.M_PRODUCT_ID
AND OL.C_UOM_ID = UO.C_UOM_ID
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
