details: https://code.openbravo.com/erp/devel/pi/rev/cbb2250c5eb8
changeset: 23932:cbb2250c5eb8
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Sat Jun 28 15:30:46 2014 +0530
summary: Fixes Issue 26668:Sales Quotation and Order report showing wrong
information
for non stocked BOM products
diffstat:
src/org/openbravo/erpReports/C_OrderLinesJR_new.jrxml | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diffs (11 lines):
diff -r d6f7f070b57d -r cbb2250c5eb8
src/org/openbravo/erpReports/C_OrderLinesJR_new.jrxml
--- a/src/org/openbravo/erpReports/C_OrderLinesJR_new.jrxml Mon Jun 30
12:46:03 2014 +0530
+++ b/src/org/openbravo/erpReports/C_OrderLinesJR_new.jrxml Sat Jun 28
15:30:46 2014 +0530
@@ -35,6 +35,7 @@
C_ORDER
WHERE C_ORDERLINE.C_ORDER_ID = $P{C_ORDER_ID}
AND C_ORDERLINE.C_ORDER_ID=C_ORDER.C_ORDER_ID
+ AND C_ORDERLINE.BOM_PARENT_ID IS NULL
UNION
SELECT 2 AS ISBOM, C_ORDERLINE.LINE, M_PRODUCT.NAME AS PRODUCT_NAME,
C_ORDERLINE.QTYORDERED*M_PRODUCT_BOM.BOMQTY AS QUANTITY,
TO_CHAR(C_UOM.NAME) AS UOM, TO_NUMBER(NULL) AS PRICEACTUAL,
TO_NUMBER(NULL) AS BASE, TO_NUMBER(NULL) AS LINENETAMT, TO_NUMBER(NULL) AS
TAXLINE,
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
