diff --git a/src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql b/src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
@@ -46,7 +46,7 @@
           sum(t.movementqty) as movementqty,
           case when tc.c_currency_id = ?
              then sum(case when t.movementqty>=0 then tc.cost else -tc.cost end)
-             else c_currency_convert_precision(sum(case when t.movementqty>=0 then tc.cost else -tc.cost end), tc.c_currency_id, ?, to_date(now()), null, ?, ?) 
+             else sum(c_currency_convert_precision(case when t.movementqty>=0 then tc.cost else -tc.cost end, tc.c_currency_id, ?, tc.dateacct, null, ?, ?)) 
           end as value_per_orgwarehouseproduct
    from m_transaction_cost tc
    join m_transaction t on (tc.m_transaction_id = t.m_transaction_id)
@@ -70,7 +70,7 @@
          agg.stock as movementqty,
          case when agg.c_currency_id = ?
              then agg.valuation
-             else c_currency_convert_precision(agg.valuation, agg.c_currency_id, ?, to_date(now()), null, agg.ad_client_id, agg.ad_org_id) 
+             else c_currency_convert_precision(agg.valuation, agg.c_currency_id, ?, agg.dateto, null, agg.ad_client_id, agg.ad_org_id) 
          end as value_per_orgwarehouseproduct
   from m_valued_stock_agg agg
   join m_locator l on (agg.m_locator_id = l.m_locator_id)