Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029762 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Openbravo ERP] 07. Sales management | major | have not tried | 2015-05-04 13:04 | 2015-11-23 21:16 | |||
| Reporter | ebecerra | View Status | public | |||||
| Assigned To | asiermartirena | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | e08af66882c0 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 3.0PR15Q1.2 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | vmromanos | |||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0029762: Add columns Quantity, Product Search Key and Unit Price in: Sales Invoice Dimensional Report | |||||||
| Description | ERP Reports. Sales Invoice Dimensional Report. The columns Quantity, Product Search Key and Unit Price will be included in the Excel result. | |||||||
| Steps To Reproduce | N/A | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  issue29762.diff [^] (26,914 bytes) 2015-07-09 16:15 [Show Content] [Hide Content]diff --git a/src-db/database/sourcedata/AD_TEXTINTERFACES.xml b/src-db/database/sourcedata/AD_TEXTINTERFACES.xml
--- a/src-db/database/sourcedata/AD_TEXTINTERFACES.xml
+++ b/src-db/database/sourcedata/AD_TEXTINTERFACES.xml
@@ -18315,6 +18315,17 @@
<!--7FF3469B9A49B90AE040007F01007549--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--7FF3469B9A49B90AE040007F01007549--></AD_TEXTINTERFACES>
+<!--80A6CA8DAFBC49C3B64D4E2D09381C28--><AD_TEXTINTERFACES>
+<!--80A6CA8DAFBC49C3B64D4E2D09381C28--> <AD_TEXTINTERFACES_ID><![CDATA[80A6CA8DAFBC49C3B64D4E2D09381C28]]></AD_TEXTINTERFACES_ID>
+<!--80A6CA8DAFBC49C3B64D4E2D09381C28--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--80A6CA8DAFBC49C3B64D4E2D09381C28--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--80A6CA8DAFBC49C3B64D4E2D09381C28--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--80A6CA8DAFBC49C3B64D4E2D09381C28--> <TEXT><![CDATA[Unit Price]]></TEXT>
+<!--80A6CA8DAFBC49C3B64D4E2D09381C28--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml]]></FILENAME>
+<!--80A6CA8DAFBC49C3B64D4E2D09381C28--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--80A6CA8DAFBC49C3B64D4E2D09381C28--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--80A6CA8DAFBC49C3B64D4E2D09381C28--></AD_TEXTINTERFACES>
+
<!--811C781F0F9B4F13945E02EE4EF47A2E--><AD_TEXTINTERFACES>
<!--811C781F0F9B4F13945E02EE4EF47A2E--> <AD_TEXTINTERFACES_ID><![CDATA[811C781F0F9B4F13945E02EE4EF47A2E]]></AD_TEXTINTERFACES_ID>
<!--811C781F0F9B4F13945E02EE4EF47A2E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -22086,6 +22097,17 @@
<!--FABD7427F65B4853B4997065812A3C17--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--FABD7427F65B4853B4997065812A3C17--></AD_TEXTINTERFACES>
+<!--FABF71E4B9474AE683F42B7AEC070D6E--><AD_TEXTINTERFACES>
+<!--FABF71E4B9474AE683F42B7AEC070D6E--> <AD_TEXTINTERFACES_ID><![CDATA[FABF71E4B9474AE683F42B7AEC070D6E]]></AD_TEXTINTERFACES_ID>
+<!--FABF71E4B9474AE683F42B7AEC070D6E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FABF71E4B9474AE683F42B7AEC070D6E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FABF71E4B9474AE683F42B7AEC070D6E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FABF71E4B9474AE683F42B7AEC070D6E--> <TEXT><![CDATA[Product Search Key]]></TEXT>
+<!--FABF71E4B9474AE683F42B7AEC070D6E--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml]]></FILENAME>
+<!--FABF71E4B9474AE683F42B7AEC070D6E--> <ISUSED><![CDATA[Y]]></ISUSED>
+<!--FABF71E4B9474AE683F42B7AEC070D6E--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FABF71E4B9474AE683F42B7AEC070D6E--></AD_TEXTINTERFACES>
+
<!--FB62B1323B604E6CBEDDB554D2E4447F--><AD_TEXTINTERFACES>
<!--FB62B1323B604E6CBEDDB554D2E4447F--> <AD_TEXTINTERFACES_ID><![CDATA[FB62B1323B604E6CBEDDB554D2E4447F]]></AD_TEXTINTERFACES_ID>
<!--FB62B1323B604E6CBEDDB554D2E4447F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff --git a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
@@ -37,7 +37,8 @@
'' AS ORG, '' AS PARTNERGROUP, '' AS PARTNER, '' AS DOCUMENTNO, '' AS INVOICEDATE, '' AS PRODCATEGORY, '' AS PRODUCT,
'' AS PROFIT, '' AS MARGIN, '' AS PRICE, '' AS CONTACT, '' AS SALESREP, '' AS PROJECT, '' AS ADDRESS,
'' AS AMOUNTREF2, '' AS QTYREF2, '' AS WEIGHTREF2, '' AS COSTREF2, '' AS CONVAMOUNTREF2, '' AS CONVCOSTREF2,
- '' AS AMOUNTREF3, '' AS QTYREF3, '' AS WEIGHTREF3, '' AS COSTREF3, '' AS CONVAMOUNTREF3, '' AS CONVCOSTREF3
+ '' AS AMOUNTREF3, '' AS QTYREF3, '' AS WEIGHTREF3, '' AS COSTREF3, '' AS CONVAMOUNTREF3, '' AS CONVCOSTREF3,
+ '' AS SEARCHKEY, '' AS UNITPRICE
FROM (SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10,
SUM(LINENETAMT) AS AMOUNT, SUM(QTYINVOICED) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM(COST) AS COST,
SUM(LINENETREF) AS AMOUNTREF, SUM(QTYINVOICEDREF) AS QTYREF, SUM(WEIGHT_REF) AS WEIGHTREF, SUM(COSTREF) AS COSTREF,
@@ -1139,7 +1140,7 @@
<SqlMethodComment></SqlMethodComment>
<Sql>
<![CDATA[
- SELECT ORG, PARTNERGROUP, PARTNER, DOCUMENTNO, INVOICEDATE, PRODCATEGORY, PRODUCT,
+ SELECT ORG, PARTNERGROUP, PARTNER, DOCUMENTNO, INVOICEDATE, PRODCATEGORY, PRODUCT, SEARCHKEY, UNITPRICE,
AMOUNT, COST, (AMOUNT - COST) AS PROFIT, CASE WHEN AMOUNT <> 0 THEN ROUND((100 * (AMOUNT - COST) / AMOUNT), 2) * SIGN(AMOUNT - COST) ELSE 0 END AS MARGIN,
WEIGHT, QTY, CONTACT, SALESREP, PROJECT, ADDRESS
FROM (
@@ -1150,6 +1151,8 @@
TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS INVOICEDATE,
M_PRODUCT_CATEGORY.NAME AS PRODCATEGORY,
M_PRODUCT.NAME AS PRODUCT,
+ M_PRODUCT.VALUE AS SEARCHKEY,
+ C_INVOICELINE.PRICEACTUAL AS UNITPRICE,
CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_CURRENCY_CONVERT(C_INVOICELINE.LINENETAMT*-1, C_INVOICE.C_CURRENCY_ID, ?, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICE.AD_CLIENT_ID, C_INVOICE.AD_ORG_ID) ELSE C_CURRENCY_CONVERT(C_INVOICELINE.LINENETAMT, C_INVOICE.C_CURRENCY_ID, ?, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICE.AD_CLIENT_ID, C_INVOICE.AD_ORG_ID) END AS AMOUNT,
CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*(CASE WHEN c_doctype.docbasetype = 'ARC' THEN c_invoiceline.qtyinvoiced *- 1 ELSE c_invoiceline.qtyinvoiced END), C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,?,trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*(CASE WHEN c_doctype.docbasetype = 'ARC' THEN c_invoiceline.qtyinvoiced *- 1 ELSE c_invoiceline.qtyinvoiced END)) END AS COST,
C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT,
diff --git a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
@@ -1,9 +1,9 @@
<?xml version="1.0" encoding="UTF-8"?>
-<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="ReportInvoiceCustomerDimensionalAnalysesXLS" pageWidth="1500" pageHeight="842" orientation="Landscape" columnWidth="1500" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true" uuid="59be190b-97b3-4951-842b-79d4e9d2d71b">
+<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="ReportInvoiceCustomerDimensionalAnalysesXLS" pageWidth="1800" pageHeight="842" orientation="Landscape" columnWidth="1800" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true" uuid="59be190b-97b3-4951-842b-79d4e9d2d71b">
<property name="ireport.scriptlethandling" value="0"/>
<property name="ireport.encoding" value="UTF-8"/>
<property name="ireport.zoom" value="1.5"/>
- <property name="ireport.x" value="0"/>
+ <property name="ireport.x" value="587"/>
<property name="ireport.y" value="0"/>
<import value="net.sf.jasperreports.engine.*"/>
<import value="java.util.*"/>
@@ -66,7 +66,7 @@
<defaultValueExpression><![CDATA["dd/MM/yyyy"]]></defaultValueExpression>
</parameter>
<queryString>
- <![CDATA[SELECT ORG, PARTNERGROUP, PARTNER, DOCUMENTNO, INVOICEDATE, PRODCATEGORY, PRODUCT,
+ <![CDATA[SELECT ORG, PARTNERGROUP, PARTNER, DOCUMENTNO, INVOICEDATE, PRODCATEGORY, PRODUCT, SEARCHKEY, UNITPRICE,
AMOUNT, COST, (AMOUNT - COST) AS PROFIT, CASE WHEN AMOUNT <> 0 THEN ROUND((100 * (AMOUNT - COST) / AMOUNT), 2) ELSE 0 END AS MARGIN,
WEIGHT, QTY, CONTACT, SALESREP, PROJECT, ADDRESS
FROM (
@@ -77,6 +77,8 @@
TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS INVOICEDATE,
M_PRODUCT_CATEGORY.NAME AS PRODCATEGORY,
M_PRODUCT.NAME AS PRODUCT,
+ M_PRODUCT.VALUE AS SEARCHKEY,
+ C_INVOICELINE.PRICEACTUAL AS UNITPRICE,
CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_CURRENCY_CONVERT(C_INVOICELINE.LINENETAMT*-1, C_INVOICE.C_CURRENCY_ID, ?, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICE.AD_CLIENT_ID, C_INVOICE.AD_ORG_ID) ELSE C_CURRENCY_CONVERT(C_INVOICELINE.LINENETAMT, C_INVOICE.C_CURRENCY_ID, ?, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICE.AD_CLIENT_ID, C_INVOICE.AD_ORG_ID) END AS AMOUNT,
CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*c_invoiceline.qtyinvoiced, C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,?,trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*C_INVOICELINE.QTYINVOICED) END AS COST,
C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT,
@@ -119,12 +121,14 @@
<field name="INVOICEDATE" class="java.util.Date"/>
<field name="PRODCATEGORY" class="java.lang.String"/>
<field name="PRODUCT" class="java.lang.String"/>
+ <field name="SEARCHKEY" class="java.lang.String"/>
+ <field name="UNITPRICE" class="java.math.BigDecimal"/>
+ <field name="QTY" class="java.math.BigDecimal"/>
<field name="AMOUNT" class="java.math.BigDecimal"/>
<field name="COST" class="java.math.BigDecimal"/>
<field name="PROFIT" class="java.math.BigDecimal"/>
<field name="MARGIN" class="java.math.BigDecimal"/>
<field name="WEIGHT" class="java.math.BigDecimal"/>
- <field name="QTY" class="java.math.BigDecimal"/>
<field name="CONTACT" class="java.lang.String"/>
<field name="SALESREP" class="java.lang.String"/>
<field name="PROJECT" class="java.lang.String"/>
@@ -229,7 +233,46 @@
<text><![CDATA[Product]]></text>
</staticText>
<staticText>
- <reportElement key="element-8" style="Detail_Header" x="700" y="0" width="100" height="15" uuid="b03c90c1-ca4b-421c-b3c0-691a98e114f5"/>
+ <reportElement key="element-7-1" style="Detail_Header" x="700" y="0" width="100" height="15"/>
+ <box leftPadding="5" rightPadding="2">
+ <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <bottomPen lineWidth="0.0" lineColor="#000000"/>
+ <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/>
+ </box>
+ <textElement>
+ <font size="8"/>
+ </textElement>
+ <text><![CDATA[Product Search Key]]></text>
+ </staticText>
+ <staticText>
+ <reportElement key="element-7-2" style="Detail_Header" x="800" y="0" width="100" height="15"/>
+ <box leftPadding="5" rightPadding="2">
+ <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <bottomPen lineWidth="0.0" lineColor="#000000"/>
+ <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/>
+ </box>
+ <textElement textAlignment="Right">
+ <font size="8"/>
+ </textElement>
+ <text><![CDATA[Unit Price]]></text>
+ </staticText>
+ <staticText>
+ <reportElement key="element-7-3" style="Detail_Header" x="900" y="0" width="100" height="15"/>
+ <box leftPadding="5" rightPadding="2">
+ <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <bottomPen lineWidth="0.0" lineColor="#000000"/>
+ <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/>
+ </box>
+ <textElement textAlignment="Right">
+ <font size="8"/>
+ </textElement>
+ <text><![CDATA[Quantity]]></text>
+ </staticText>
+ <staticText>
+ <reportElement key="element-8" style="Detail_Header" x="1000" y="0" width="100" height="15" uuid="b03c90c1-ca4b-421c-b3c0-691a98e114f5"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -242,7 +285,7 @@
<text><![CDATA[Amount]]></text>
</staticText>
<staticText>
- <reportElement key="element-9" style="Detail_Header" x="800" y="0" width="100" height="15" uuid="4723d7ac-6850-430e-a4aa-577e94984f44"/>
+ <reportElement key="element-9" style="Detail_Header" x="1100" y="0" width="100" height="15" uuid="4723d7ac-6850-430e-a4aa-577e94984f44"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -255,7 +298,7 @@
<text><![CDATA[Cost]]></text>
</staticText>
<staticText>
- <reportElement key="element-10" style="Detail_Header" x="900" y="0" width="100" height="15" uuid="5695ba74-05af-4c6b-8ea4-3a9ef0c6109b"/>
+ <reportElement key="element-10" style="Detail_Header" x="1200" y="0" width="100" height="15" uuid="5695ba74-05af-4c6b-8ea4-3a9ef0c6109b"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -268,7 +311,7 @@
<text><![CDATA[Profit]]></text>
</staticText>
<staticText>
- <reportElement key="element-11" style="Detail_Header" x="1000" y="0" width="50" height="15" uuid="9f789559-d1de-4a31-80ac-8052c7080088"/>
+ <reportElement key="element-11" style="Detail_Header" x="1300" y="0" width="50" height="15" uuid="9f789559-d1de-4a31-80ac-8052c7080088"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -281,7 +324,7 @@
<text><![CDATA[M.%]]></text>
</staticText>
<staticText>
- <reportElement key="element-12" style="Detail_Header" x="1050" y="0" width="50" height="15" uuid="209d378a-71bc-48eb-a71a-83c2948f9286"/>
+ <reportElement key="element-12" style="Detail_Header" x="1350" y="0" width="50" height="15" uuid="209d378a-71bc-48eb-a71a-83c2948f9286"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -294,7 +337,7 @@
<text><![CDATA[Weight]]></text>
</staticText>
<staticText>
- <reportElement key="element-13" style="Detail_Header" x="1100" y="0" width="100" height="15" uuid="b7720fd1-f58b-43af-996f-ce19d09ca9bf"/>
+ <reportElement key="element-13" style="Detail_Header" x="1400" y="0" width="100" height="15" uuid="b7720fd1-f58b-43af-996f-ce19d09ca9bf"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -307,7 +350,7 @@
<text><![CDATA[Quantity]]></text>
</staticText>
<staticText>
- <reportElement key="element-14" style="Detail_Header" x="1100" y="0" width="100" height="15" uuid="7cdf0b1e-d288-4be0-be37-f0f44e74e6a1"/>
+ <reportElement key="element-14" style="Detail_Header" x="1400" y="0" width="100" height="15" uuid="7cdf0b1e-d288-4be0-be37-f0f44e74e6a1"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -320,7 +363,7 @@
<text><![CDATA[Contact]]></text>
</staticText>
<staticText>
- <reportElement key="element-15" style="Detail_Header" x="1200" y="0" width="100" height="15" uuid="d40acb18-ce14-465b-9427-c99a5c192c24"/>
+ <reportElement key="element-15" style="Detail_Header" x="1500" y="0" width="100" height="15" uuid="d40acb18-ce14-465b-9427-c99a5c192c24"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -333,7 +376,7 @@
<text><![CDATA[Sales rep.]]></text>
</staticText>
<staticText>
- <reportElement key="element-16" style="Detail_Header" x="1300" y="0" width="100" height="15" uuid="46e9cfee-0663-4bcc-99e2-559fe0c31be0"/>
+ <reportElement key="element-16" style="Detail_Header" x="1600" y="0" width="100" height="15" uuid="46e9cfee-0663-4bcc-99e2-559fe0c31be0"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -346,7 +389,7 @@
<text><![CDATA[Project]]></text>
</staticText>
<staticText>
- <reportElement key="element-17" style="Detail_Header" x="1400" y="0" width="100" height="15" uuid="bd9a2711-395d-4ebd-856b-14005795d9d8"/>
+ <reportElement key="element-17" style="Detail_Header" x="1700" y="0" width="100" height="15" uuid="bd9a2711-395d-4ebd-856b-14005795d9d8"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -446,8 +489,21 @@
</textElement>
<textFieldExpression><![CDATA[$F{PRODUCT}]]></textFieldExpression>
</textField>
+ <textField pattern="" isBlankWhenNull="true">
+ <reportElement key="textField-13" stretchType="RelativeToBandHeight" x="900" y="0" width="100" height="13"/>
+ <box rightPadding="2">
+ <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <bottomPen lineWidth="0.0" lineColor="#000000"/>
+ <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ </box>
+ <textElement textAlignment="Right">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{QTY}]]></textFieldExpression>
+ </textField>
<textField pattern="" isBlankWhenNull="false">
- <reportElement key="textField-8" stretchType="RelativeToBandHeight" x="700" y="0" width="100" height="13" uuid="09f0aa65-d2eb-4ee4-a68f-a368840c5904"/>
+ <reportElement key="textField-8" stretchType="RelativeToBandHeight" x="1000" y="0" width="100" height="13" uuid="09f0aa65-d2eb-4ee4-a68f-a368840c5904"/>
<box rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -460,7 +516,7 @@
<textFieldExpression><![CDATA[$F{AMOUNT}]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="false">
- <reportElement key="textField-9" stretchType="RelativeToBandHeight" x="800" y="0" width="100" height="13" uuid="485e1ead-f9d9-4b7e-9b69-de548e006df9"/>
+ <reportElement key="textField-9" stretchType="RelativeToBandHeight" x="1100" y="0" width="100" height="13" uuid="485e1ead-f9d9-4b7e-9b69-de548e006df9"/>
<box rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -473,7 +529,7 @@
<textFieldExpression><![CDATA[$F{COST}]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="false">
- <reportElement key="textField-10" stretchType="RelativeToBandHeight" x="900" y="0" width="100" height="13" uuid="98e73443-30bf-4370-9c33-c03f18722331"/>
+ <reportElement key="textField-10" stretchType="RelativeToBandHeight" x="1200" y="0" width="100" height="13" uuid="98e73443-30bf-4370-9c33-c03f18722331"/>
<box rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -486,7 +542,7 @@
<textFieldExpression><![CDATA[$F{PROFIT}]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="false">
- <reportElement key="textField-11" stretchType="RelativeToBandHeight" x="1000" y="0" width="50" height="13" uuid="3d0815a2-b760-434e-bb63-ec856afae135"/>
+ <reportElement key="textField-11" stretchType="RelativeToBandHeight" x="1300" y="0" width="50" height="13" uuid="3d0815a2-b760-434e-bb63-ec856afae135"/>
<box rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -499,7 +555,7 @@
<textFieldExpression><![CDATA[$F{MARGIN}]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="true">
- <reportElement key="textField-12" stretchType="RelativeToBandHeight" x="1050" y="0" width="50" height="13" uuid="d9693cbb-9d69-418a-becf-e47130fcc0a3"/>
+ <reportElement key="textField-12" stretchType="RelativeToBandHeight" x="1350" y="0" width="50" height="13" uuid="d9693cbb-9d69-418a-becf-e47130fcc0a3"/>
<box rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -511,21 +567,8 @@
</textElement>
<textFieldExpression><![CDATA[$F{WEIGHT}]]></textFieldExpression>
</textField>
- <textField pattern="" isBlankWhenNull="true">
- <reportElement key="textField-13" stretchType="RelativeToBandHeight" x="1100" y="0" width="100" height="13" uuid="c77304b6-6c88-4430-843c-33e0463f04e0"/>
- <box rightPadding="2">
- <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
- <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
- <bottomPen lineWidth="0.0" lineColor="#000000"/>
- <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
- </box>
- <textElement textAlignment="Right">
- <font size="8"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{QTY}]]></textFieldExpression>
- </textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
- <reportElement key="textField-14" stretchType="RelativeToBandHeight" x="1100" y="0" width="100" height="13" uuid="79490dd4-4d29-4e5a-9301-aeb669776a2d"/>
+ <reportElement key="textField-14" stretchType="RelativeToBandHeight" x="1400" y="0" width="100" height="13" uuid="79490dd4-4d29-4e5a-9301-aeb669776a2d"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -538,7 +581,7 @@
<textFieldExpression><![CDATA[$F{CONTACT}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
- <reportElement key="textField-15" stretchType="RelativeToBandHeight" x="1200" y="0" width="100" height="13" uuid="bc1efd65-c636-44b1-b917-d996463d5051"/>
+ <reportElement key="textField-15" stretchType="RelativeToBandHeight" x="1500" y="0" width="100" height="13" uuid="bc1efd65-c636-44b1-b917-d996463d5051"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -551,7 +594,7 @@
<textFieldExpression><![CDATA[$F{SALESREP}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
- <reportElement key="textField-16" stretchType="RelativeToBandHeight" x="1300" y="0" width="100" height="13" uuid="6ebe8fea-d158-42b0-858d-92dcd3018570"/>
+ <reportElement key="textField-16" stretchType="RelativeToBandHeight" x="1600" y="0" width="100" height="13" uuid="6ebe8fea-d158-42b0-858d-92dcd3018570"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -564,7 +607,7 @@
<textFieldExpression><![CDATA[$F{PROJECT}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
- <reportElement key="textField-17" stretchType="RelativeToBandHeight" x="1400" y="0" width="100" height="13" uuid="ba9df64a-1e05-46b2-ae62-7ac93a7698af"/>
+ <reportElement key="textField-17" stretchType="RelativeToBandHeight" x="1700" y="0" width="100" height="13" uuid="ba9df64a-1e05-46b2-ae62-7ac93a7698af"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -576,6 +619,27 @@
</textElement>
<textFieldExpression><![CDATA[$F{ADDRESS}]]></textFieldExpression>
</textField>
+ <textField pattern="" isBlankWhenNull="true">
+ <reportElement key="textField-13" stretchType="RelativeToBandHeight" x="800" y="0" width="100" height="13"/>
+ <box rightPadding="2">
+ <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <bottomPen lineWidth="0.0" lineColor="#000000"/>
+ <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ </box>
+ <textElement textAlignment="Right">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{UNITPRICE}]]></textFieldExpression>
+ </textField>
+ <textField isStretchWithOverflow="true" isBlankWhenNull="true">
+ <reportElement key="textField-7" stretchType="RelativeToBandHeight" x="700" y="0" width="100" height="13"/>
+ <box rightPadding="2"/>
+ <textElement>
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression class="java.lang.String"><![CDATA[$F{SEARCHKEY}]]></textFieldExpression>
+ </textField>
</band>
</detail>
<columnFooter>
issue_29762_2.diff [^] (7,697 bytes) 2015-08-13 13:26 [Show Content] [Hide Content]diff --git a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
@@ -1152,7 +1152,7 @@
M_PRODUCT_CATEGORY.NAME AS PRODCATEGORY,
M_PRODUCT.NAME AS PRODUCT,
M_PRODUCT.VALUE AS SEARCHKEY,
- C_INVOICELINE.PRICEACTUAL AS UNITPRICE,
+ C_CURRENCY_CONVERT(CASE WHEN C_INVOICELINE.QTYINVOICED = 0 THEN 0 ELSE C_INVOICELINE.LINENETAMT/C_INVOICELINE.QTYINVOICED END, C_INVOICE.C_CURRENCY_ID, ?, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICE.AD_CLIENT_ID, C_INVOICE.AD_ORG_ID) AS UNITPRICE,
CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_CURRENCY_CONVERT(C_INVOICELINE.LINENETAMT*-1, C_INVOICE.C_CURRENCY_ID, ?, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICE.AD_CLIENT_ID, C_INVOICE.AD_ORG_ID) ELSE C_CURRENCY_CONVERT(C_INVOICELINE.LINENETAMT, C_INVOICE.C_CURRENCY_ID, ?, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICE.AD_CLIENT_ID, C_INVOICE.AD_ORG_ID) END AS AMOUNT,
CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*(CASE WHEN c_doctype.docbasetype = 'ARC' THEN c_invoiceline.qtyinvoiced *- 1 ELSE c_invoiceline.qtyinvoiced END), C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,?,trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*(CASE WHEN c_doctype.docbasetype = 'ARC' THEN c_invoiceline.qtyinvoiced *- 1 ELSE c_invoiceline.qtyinvoiced END)) END AS COST,
C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT,
@@ -1191,6 +1191,7 @@
<Parameter name="cCurrencyConv"/>
<Parameter name="cCurrencyConv"/>
<Parameter name="cCurrencyConv"/>
+ <Parameter name="cCurrencyConv"/>
<Parameter name="adOrgId" optional="true" type="replace" after="AND C_INVOICE.AD_ORG_ID IN (" text="'1'"/>
<Parameter name="adUserClient" type="replace" optional="true" after="AND C_INVOICE.AD_CLIENT_ID IN (" text="'7'"/>
<Parameter name="dateFrom" optional="true" after="AND 1=1"><![CDATA[AND C_INVOICE.DATEINVOICED >= to_date(?)]]></Parameter>
diff --git a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
@@ -77,8 +77,8 @@
TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS INVOICEDATE,
M_PRODUCT_CATEGORY.NAME AS PRODCATEGORY,
M_PRODUCT.NAME AS PRODUCT,
- M_PRODUCT.VALUE AS SEARCHKEY,
- C_INVOICELINE.PRICEACTUAL AS UNITPRICE,
+ M_PRODUCT.VALUE AS SEARCHKEY,
+ CASE WHEN C_INVOICELINE.QTYINVOICED = 0 THEN 0 ELSE C_INVOICELINE.LINENETAMT/C_INVOICELINE.QTYINVOICED END AS UNITPRICE,
CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_CURRENCY_CONVERT(C_INVOICELINE.LINENETAMT*-1, C_INVOICE.C_CURRENCY_ID, ?, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICE.AD_CLIENT_ID, C_INVOICE.AD_ORG_ID) ELSE C_CURRENCY_CONVERT(C_INVOICELINE.LINENETAMT, C_INVOICE.C_CURRENCY_ID, ?, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICE.AD_CLIENT_ID, C_INVOICE.AD_ORG_ID) END AS AMOUNT,
CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*c_invoiceline.qtyinvoiced, C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,?,trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*C_INVOICELINE.QTYINVOICED) END AS COST,
C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT,
@@ -246,7 +246,20 @@
<text><![CDATA[Product Search Key]]></text>
</staticText>
<staticText>
- <reportElement key="element-7-2" style="Detail_Header" x="800" y="0" width="100" height="15"/>
+ <reportElement key="element-7-3" style="Detail_Header" x="800" y="0" width="100" height="15"/>
+ <box leftPadding="5" rightPadding="2">
+ <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <bottomPen lineWidth="0.0" lineColor="#000000"/>
+ <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/>
+ </box>
+ <textElement textAlignment="Right">
+ <font size="8"/>
+ </textElement>
+ <text><![CDATA[Quantity]]></text>
+ </staticText>
+ <staticText>
+ <reportElement key="element-7-2" style="Detail_Header" x="900" y="0" width="100" height="15"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -259,19 +272,6 @@
<text><![CDATA[Unit Price]]></text>
</staticText>
<staticText>
- <reportElement key="element-7-3" style="Detail_Header" x="900" y="0" width="100" height="15"/>
- <box leftPadding="5" rightPadding="2">
- <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
- <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
- <bottomPen lineWidth="0.0" lineColor="#000000"/>
- <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/>
- </box>
- <textElement textAlignment="Right">
- <font size="8"/>
- </textElement>
- <text><![CDATA[Quantity]]></text>
- </staticText>
- <staticText>
<reportElement key="element-8" style="Detail_Header" x="1000" y="0" width="100" height="15" uuid="b03c90c1-ca4b-421c-b3c0-691a98e114f5"/>
<box leftPadding="5" rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -490,7 +490,7 @@
<textFieldExpression><![CDATA[$F{PRODUCT}]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="true">
- <reportElement key="textField-13" stretchType="RelativeToBandHeight" x="900" y="0" width="100" height="13"/>
+ <reportElement key="textField-13" stretchType="RelativeToBandHeight" x="800" y="0" width="100" height="13"/>
<box rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
@@ -620,7 +620,7 @@
<textFieldExpression><![CDATA[$F{ADDRESS}]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="true">
- <reportElement key="textField-13" stretchType="RelativeToBandHeight" x="800" y="0" width="100" height="13"/>
+ <reportElement key="textField-13" stretchType="RelativeToBandHeight" x="900" y="0" width="100" height="13"/>
<box rightPadding="2">
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0080872) hgbot (developer) 2015-10-07 19:12 |
Repository: erp/devel/pi Changeset: e08af66882c07b7bf9bc32285adbe5af1f3a0c61 Author: Asier Martirena <asier.martirena <at> openbravo.com> Date: Wed Oct 07 19:11:13 2015 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/e08af66882c07b7bf9bc32285adbe5af1f3a0c61 [^] Fixed issue 29762: Add columns to purchase and sales invoice dimensional report --- M src-db/database/sourcedata/AD_TEXTINTERFACES.xml M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml --- |
|
(0081380) vmromanos (viewer) 2015-10-28 12:25 |
Code review + testing OK |
|
(0082117) hudsonbot (viewer) 2015-11-23 21:16 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/7b56bebaaa88 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-05-04 13:04 | ebecerra | New Issue | |
| 2015-05-04 13:04 | ebecerra | Assigned To | => ebecerra |
| 2015-05-04 13:04 | ebecerra | OBNetwork customer | => No |
| 2015-05-04 13:04 | ebecerra | Modules | => Core |
| 2015-05-04 13:04 | ebecerra | Triggers an Emergency Pack | => No |
| 2015-05-05 09:57 | ebecerra | File Added: issue_0029762.export | |
| 2015-07-09 13:13 | asiermartirena | File Deleted: issue_0029762.export | |
| 2015-07-09 13:14 | asiermartirena | File Added: issue_29762.diff | |
| 2015-07-09 16:15 | naiaramartinez | File Deleted: issue_29762.diff | |
| 2015-07-09 16:15 | naiaramartinez | File Added: issue29762.diff | |
| 2015-08-13 13:26 | ebecerra | File Added: issue_29762_2.diff | |
| 2015-09-30 19:07 | ngarcia | Relationship added | related to 0026751 |
| 2015-09-30 19:08 | ngarcia | Relationship deleted | related to 0026751 |
| 2015-10-07 19:12 | hgbot | Checkin | |
| 2015-10-07 19:12 | hgbot | Note Added: 0080872 | |
| 2015-10-07 19:12 | hgbot | Status | new => resolved |
| 2015-10-07 19:12 | hgbot | Resolution | open => fixed |
| 2015-10-07 19:12 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e08af66882c07b7bf9bc32285adbe5af1f3a0c61 [^] |
| 2015-10-13 17:47 | gorkaion | Review Assigned To | => vmromanos |
| 2015-10-13 17:47 | gorkaion | Assigned To | ebecerra => asiermartirena |
| 2015-10-28 12:25 | vmromanos | Note Added: 0081380 | |
| 2015-10-28 12:25 | vmromanos | Status | resolved => closed |
| 2015-11-23 21:16 | hudsonbot | Checkin | |
| 2015-11-23 21:16 | hudsonbot | Note Added: 0082117 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |