details: https://code.openbravo.com/erp/devel/pi/rev/91a9ede68a28
changeset: 14083:91a9ede68a28
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Tue Oct 25 11:58:14 2011 +0200
summary: Fixes issue 18623: Amount, in Material Receipt Dimensional Reports,
is incorrect when quantity delivered is minor than quantity ordered
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR_data.xsql
| 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diffs (30 lines):
diff -r edb7b23471e3 -r 91a9ede68a28
src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR_data.xsql
---
a/src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR_data.xsql
Mon Oct 24 14:26:28 2011 +0200
+++
b/src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR_data.xsql
Tue Oct 25 11:58:14 2011 +0200
@@ -39,7 +39,7 @@
C_CURRENCY_CONVERT(SUM(LINENETREF), TRCURRENCYID, ?, TO_DATE(TRDATE),
NULL, TRCLIENTID, TRORGID) AS CONVAMOUNTREF,
TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID
FROM (SELECT to_char('1') AS NIVEL1, to_char('2') AS NIVEL2,
to_char('3') AS NIVEL3, to_char('4') AS NIVEL4, to_char('5') AS NIVEL5,
- C_ORDERLINE.LINENETAMT, M_INOUTLINE.MOVEMENTQTY,
+ C_ORDERLINE.LINENETAMT*(M_INOUTLINE.MOVEMENTQTY/C_ORDERLINE.QtyOrdered)
as LINENETAMT, M_INOUTLINE.MOVEMENTQTY,
0 AS LINENETREF, 0 AS MOVEMENTQTYREF, C_UOM.UOMSYMBOL,
C_ORDERLINE.C_CURRENCY_ID AS TRCURRENCYID,
TO_DATE(COALESCE(C_ORDERLINE.DATEORDERED, NOW())) AS TRDATE,
@@ -60,7 +60,7 @@
AND 1=1
UNION ALL SELECT to_char('7') AS NIVEL1 , to_char('8') AS NIVEL2 ,
to_char('9') AS NIVEL3 , to_char('10') AS NIVEL4 , to_char('11') AS NIVEL5,
0 AS LINENETAMT, 0 AS MOVEMENTQTY,
- C_ORDERLINE.LINENETAMT AS LINENETREF, M_INOUTLINE.MOVEMENTQTY AS
MOVEMENTQTYREF, C_UOM.UOMSYMBOL,
+ C_ORDERLINE.LINENETAMT*(M_INOUTLINE.MOVEMENTQTY/C_ORDERLINE.QtyOrdered)
AS LINENETREF, M_INOUTLINE.MOVEMENTQTY AS MOVEMENTQTYREF, C_UOM.UOMSYMBOL,
C_ORDERLINE.C_CURRENCY_ID AS TRCURRENCYID,
TO_DATE(COALESCE(C_ORDERLINE.DATEORDERED, NOW())) AS TRDATE,
C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID,
@@ -135,7 +135,7 @@
0 AS CONVAMOUNTREF,
TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID
FROM (SELECT to_char('1') AS NIVEL1, to_char('2') AS NIVEL2,
to_char('3') AS NIVEL3, to_char('4') AS NIVEL4, to_char('5') AS NIVEL5,
- C_ORDERLINE.LINENETAMT, M_INOUTLINE.MOVEMENTQTY,
+ C_ORDERLINE.LINENETAMT*(M_INOUTLINE.MOVEMENTQTY/C_ORDERLINE.QtyOrdered)
as LINENETAMT, M_INOUTLINE.MOVEMENTQTY,
0 AS LINENETREF, 0 AS MOVEMENTQTYREF, C_UOM.UOMSYMBOL,
C_ORDERLINE.C_CURRENCY_ID AS TRCURRENCYID,
TO_DATE(COALESCE(C_ORDERLINE.DATEORDERED, NOW())) AS TRDATE,
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
