details: https://code.openbravo.com/erp/devel/pi/rev/a7e9e2f864a2
changeset: 15488:a7e9e2f864a2
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Feb 15 18:02:22 2012 +0100
summary: Fixes issue 19771: Wrong conversion rate used in the Sales
Dimensional Report.
Now, the date ordered of the header will be considered to calculate the
conversion
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR_data.xsql
| 6 +++---
src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql
| 6 +++---
2 files changed, 6 insertions(+), 6 deletions(-)
diffs (60 lines):
diff -r 9b82d811c2b2 -r a7e9e2f864a2
src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR_data.xsql
---
a/src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR_data.xsql
Tue Feb 14 13:44:39 2012 +0100
+++
b/src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR_data.xsql
Wed Feb 15 18:02:22 2012 +0100
@@ -46,7 +46,7 @@
C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED,
0 AS LINENETREF, 0 AS QTYORDEREDREF, C_UOM.UOMSYMBOL,
COALESCE(C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS
TRCURRENCYID,
- COALESCE(TO_DATE(C_ORDERLINE.DATEORDERED), TO_DATE(C_ORDER.DATEORDERED),
TO_DATE(NOW())) AS TRDATE,
+ TO_DATE(COALESCE(C_ORDER.DATEORDERED, NOW())) AS TRDATE,
C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID,
C_ORDERLINE.AD_ORG_ID AS TRORGID
FROM M_PRODUCT left join M_PRODUCT_CATEGORY on
M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID
@@ -65,7 +65,7 @@
0 AS LINENETAMT, 0 AS QTYORDERED,
C_ORDERLINE.LINENETAMT AS LINENETREF, C_ORDERLINE.QTYORDERED AS
QTYORDEREDREF, C_UOM.UOMSYMBOL,
COALESCE(C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS
TRCURRENCYID,
- COALESCE(TO_DATE(C_ORDERLINE.DATEORDERED), TO_DATE(C_ORDER.DATEORDERED),
TO_DATE(NOW())) AS TRDATE,
+ TO_DATE(COALESCE(C_ORDER.DATEORDERED, NOW())) AS TRDATE,
C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID,
C_ORDERLINE.AD_ORG_ID AS TRORGID
FROM M_PRODUCT left join M_PRODUCT_CATEGORY on
M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID
@@ -140,7 +140,7 @@
C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED,
0 AS LINENETREF, 0 AS QTYORDEREDREF, C_UOM.UOMSYMBOL,
COALESCE(C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS
TRCURRENCYID,
- COALESCE(TO_DATE(C_ORDERLINE.DATEORDERED),
TO_DATE(C_ORDER.DATEORDERED), TO_DATE(NOW())) AS TRDATE,
+ TO_DATE(COALESCE(C_ORDER.DATEORDERED,NOW())) AS TRDATE,
C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID,
C_ORDERLINE.AD_ORG_ID AS TRORGID
FROM M_PRODUCT left join M_PRODUCT_CATEGORY on
M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID
diff -r 9b82d811c2b2 -r a7e9e2f864a2
src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql
---
a/src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql
Tue Feb 14 13:44:39 2012 +0100
+++
b/src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql
Wed Feb 15 18:02:22 2012 +0100
@@ -46,7 +46,7 @@
C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED,
C_ORDERLINE.QTYORDERED*M_PRODUCT.WEIGHT AS WEIGHT,
0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL,
COALESCE(C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS
TRCURRENCYID,
- TO_DATE(COALESCE(C_ORDERLINE.DATEORDERED, C_ORDER.DATEORDERED,
NOW())) AS TRDATE,
+ TO_DATE(COALESCE(C_ORDER.DATEORDERED, NOW())) AS TRDATE,
C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID,
C_ORDERLINE.AD_ORG_ID AS TRORGID
FROM C_ORDER left join AD_USER on C_ORDER.SALESREP_ID =
AD_USER.AD_USER_ID,
@@ -69,7 +69,7 @@
0 AS LINENETAMT, 0 AS QTYORDERED, 0 AS WEIGHT,
C_ORDERLINE.LINENETAMT AS LINENETREF, C_ORDERLINE.QTYORDERED AS
QTYORDEREDREF, C_ORDERLINE.QTYORDERED*M_PRODUCT.WEIGHT AS WEIGHTREF,
C_UOM.UOMSYMBOL,
COALESCE(C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS
TRCURRENCYID,
- TO_DATE(COALESCE(C_ORDERLINE.DATEORDERED, C_ORDER.DATEORDERED,
NOW())) AS TRDATE,
+ TO_DATE(COALESCE(C_ORDER.DATEORDERED, NOW())) AS TRDATE,
C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID,
C_ORDERLINE.AD_ORG_ID AS TRORGID
FROM C_ORDER left join AD_USER on C_ORDER.SALESREP_ID =
AD_USER.AD_USER_Id,
@@ -201,7 +201,7 @@
C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED,
C_ORDERLINE.QTYORDERED*M_PRODUCT.WEIGHT AS WEIGHT,
0 AS LINENETREF, 0 AS QTYORDEREDREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL,
COALESCE(C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS
TRCURRENCYID,
- TO_DATE(COALESCE(C_ORDERLINE.DATEORDERED, C_ORDER.DATEORDERED,
NOW())) AS TRDATE,
+ TO_DATE(COALESCE(C_ORDER.DATEORDERED, NOW())) AS TRDATE,
C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID,
C_ORDERLINE.AD_ORG_ID AS TRORGID
FROM C_ORDER left join AD_USER on C_ORDER.SALESREP_ID =
AD_USER.AD_USER_ID,
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
