details: https://code.openbravo.com/erp/devel/pi/rev/6165a0f9f60c
changeset: 16837:6165a0f9f60c
user: Naiara Martinez <naiara.martinez <at> openbravo.com>
date: Thu May 17 13:10:01 2012 +0200
summary: fixed bug 19607 Change SQL.Add new parameter when calling
c_currency_convert
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql | 6
+++---
1 files changed, 3 insertions(+), 3 deletions(-)
diffs (23 lines):
diff -r 5d556655fef9 -r 6165a0f9f60c
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
Wed Jun 13 18:42:54 2012 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
Thu May 17 13:10:01 2012 +0200
@@ -12,7 +12,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2001-2010 Openbravo SLU
+ * All portions are Copyright (C) 2001-2012 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************
@@ -34,8 +34,8 @@
p.value as searchkey, p.name as name,
ad_column_identifier('C_Uom', p.c_uom_id, ?) as unit,
w.ad_org_id, sd.m_product_id, sum(sd.qtyonhand) as qty,
- c_currency_convert(c.cost, ?, ?, to_date(now()), w.ad_client_id,
w.ad_org_id) as cost,
- c_currency_convert(sum(sd.qtyonhand*c.cost), ?, ?, to_date(now()),
w.ad_client_id, w.ad_org_id) as value,
+ c_currency_convert(c.cost, ?, ?, to_date(now()),'S', w.ad_client_id,
w.ad_org_id) as cost,
+ c_currency_convert(sum(sd.qtyonhand*c.cost), ?, ?, to_date(now()),
'S', w.ad_client_id, w.ad_org_id) as value,
100*sum(sd.qtyonhand*c.cost)/(
select sum(c_aux.cost * sd_aux.qtyonhand)
from m_locator l_aux, m_warehouse w_aux, m_storage_detail sd_aux,
m_costing c_aux
------------------------------------------------------------------------------
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
