details: /erp/devel/pi/rev/85e337e45594
changeset: 8754:85e337e45594
user: Ratnakaram Suresh <ratnakaram.suresh <at> openbravo.com>
date: Wed Oct 27 10:24:42 2010 +0530
summary: Fixes issue 0014852: Error in report Invoiced Sales Order Report
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql | 2
+-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 080b4b811fa9 -r 85e337e45594
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql
Tue Oct 26 21:24:16 2010 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql
Wed Oct 27 10:24:42 2010 +0530
@@ -60,7 +60,7 @@
GROUP BY COALESCE(CB.NAME, C_BPARTNER.NAME), C_PROJECT.VALUE,
C_PROJECT.NAME, M_PRODUCT.NAME, C_UOM.NAME, C_ORDERLINE.PRICEACTUAL,
COALESCE(C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID),
TO_DATE(COALESCE(C_ORDERLINE.DATEORDERED, C_ORDER.DATEORDERED, NOW())),
C_ORDERLINE.AD_CLIENT_ID, C_ORDERLINE.AD_ORG_ID,
C_DOCTYPE.DOCBASETYPE
- HAVING SUM(C_ORDERLINE.QTYDELIVERED) > 0
+ HAVING SUM(C_ORDERLINE.QTYINVOICED) > 0
ORDER BY COALESCE(CB.NAME, C_BPARTNER.NAME), C_PROJECT.NAME,
M_PRODUCT.NAME
]]></Sql>
<Parameter name="cCurrencyConv"/>
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
