details: https://code.openbravo.com/erp/devel/pi/rev/6a8a0f555ee5 changeset: 14897:6a8a0f555ee5 user: Javier Etxarri <javier.echarri <at> openbravo.com> date: Mon Dec 19 10:18:32 2011 +0100 summary: Fixes issue 19152: Error in Production Cost Report query
details: https://code.openbravo.com/erp/devel/pi/rev/f651801efc37 changeset: 14898:f651801efc37 user: Javier Etxarri <javier.echarri <at> openbravo.com> date: Mon Dec 19 10:19:16 2011 +0100 summary: Fixes issue 19079: Request User Password field's length in Client window is too small details: https://code.openbravo.com/erp/devel/pi/rev/8b52fbce6a6c changeset: 14899:8b52fbce6a6c user: Javier Etxarri <javier.echarri <at> openbravo.com> date: Mon Dec 19 10:20:00 2011 +0100 summary: Fixes issue 19159: You can not define one "Business Partner" employee as "Operator" details: https://code.openbravo.com/erp/devel/pi/rev/1fe9ce39fb42 changeset: 14900:1fe9ce39fb42 user: Javier Etxarri <javier.echarri <at> openbravo.com> date: Mon Dec 19 15:35:39 2011 +0100 summary: Fixes issue 19096: Invoices Lines without price amount do not appear in Dim.Inv. Reports diffstat: modules/org.openbravo.v3/src-db/database/configScript.xml | 6 +----- src-db/database/sourcedata/AD_COLUMN.xml | 2 +- src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java | 8 +++----- src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java | 8 +++----- src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql | 2 +- 5 files changed, 9 insertions(+), 17 deletions(-) diffs (88 lines): diff -r b144c53d6ca3 -r 1fe9ce39fb42 modules/org.openbravo.v3/src-db/database/configScript.xml --- a/modules/org.openbravo.v3/src-db/database/configScript.xml Mon Dec 19 15:17:26 2011 +0100 +++ b/modules/org.openbravo.v3/src-db/database/configScript.xml Mon Dec 19 15:35:39 2011 +0100 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <vector> - <versionInfo version="3.0.14253"/> + <versionInfo version="3.0.14860"/> <columnDataChange tablename="AD_PROCESS" columnname="ISACTIVE" pkRow="800026"> <oldValue><![CDATA[Y]]></oldValue> <newValue><![CDATA[N]]></newValue> @@ -1485,10 +1485,6 @@ <oldValue><![CDATA[Y]]></oldValue> <newValue><![CDATA[N]]></newValue> </columnDataChange> - <columnDataChange tablename="AD_FIELD" columnname="ISDISPLAYED" pkRow="802534"> - <oldValue><![CDATA[Y]]></oldValue> - <newValue><![CDATA[N]]></newValue> - </columnDataChange> <columnDataChange tablename="AD_FIELD" columnname="ISDISPLAYED" pkRow="802642"> <oldValue><![CDATA[Y]]></oldValue> <newValue><![CDATA[N]]></newValue> diff -r b144c53d6ca3 -r 1fe9ce39fb42 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Mon Dec 19 15:17:26 2011 +0100 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Mon Dec 19 15:35:39 2011 +0100 @@ -89544,7 +89544,7 @@ <!--6560--> <COLUMNNAME><![CDATA[RequestUserPW]]></COLUMNNAME> <!--6560--> <AD_TABLE_ID><![CDATA[112]]></AD_TABLE_ID> <!--6560--> <AD_REFERENCE_ID><![CDATA[16EC6DF4A59747749FDF256B7FBBB058]]></AD_REFERENCE_ID> -<!--6560--> <FIELDLENGTH><![CDATA[20]]></FIELDLENGTH> +<!--6560--> <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH> <!--6560--> <ISKEY><![CDATA[N]]></ISKEY> <!--6560--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--6560--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> diff -r b144c53d6ca3 -r 1fe9ce39fb42 src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java --- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java Mon Dec 19 15:17:26 2011 +0100 +++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java Mon Dec 19 15:35:39 2011 +0100 @@ -623,14 +623,12 @@ } String strHaving = ""; if (!strMayor.equals("") && !strMenor.equals("")) { - strHaving = " HAVING (SUM(CONVAMOUNT) > " + strMayor + " AND SUM(CONVAMOUNT) < " + strMenor + strHaving = " HAVING (SUM(CONVAMOUNT) >= " + strMayor + " AND SUM(CONVAMOUNT) <= " + strMenor + ")"; } else if (!strMayor.equals("") && strMenor.equals("")) { - strHaving = " HAVING (SUM(CONVAMOUNT) > " + strMayor + ")"; + strHaving = " HAVING (SUM(CONVAMOUNT) >= " + strMayor + ")"; } else if (strMayor.equals("") && !strMenor.equals("")) { - strHaving = " HAVING (SUM(CONVAMOUNT) < " + strMenor + ")"; - } else { - strHaving = " HAVING (SUM(CONVAMOUNT) <> 0 OR SUM(CONVAMOUNTREF) <> 0)"; + strHaving = " HAVING (SUM(CONVAMOUNT) <= " + strMenor + ")"; } strOrderby = strHaving + strOrderby; diff -r b144c53d6ca3 -r 1fe9ce39fb42 src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java --- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java Mon Dec 19 15:17:26 2011 +0100 +++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java Mon Dec 19 15:35:39 2011 +0100 @@ -473,14 +473,12 @@ } String strHaving = ""; if (!strMayor.equals("") && !strMenor.equals("")) { - strHaving = " HAVING (SUM(CONVAMOUNT) > " + strMayor + " AND SUM(CONVAMOUNT) < " + strMenor + strHaving = " HAVING (SUM(CONVAMOUNT) >= " + strMayor + " AND SUM(CONVAMOUNT) <= " + strMenor + ")"; } else if (!strMayor.equals("") && strMenor.equals("")) { - strHaving = " HAVING (SUM(CONVAMOUNT) > " + strMayor + ")"; + strHaving = " HAVING (SUM(CONVAMOUNT) >= " + strMayor + ")"; } else if (strMayor.equals("") && !strMenor.equals("")) { - strHaving = " HAVING (SUM(CONVAMOUNT) < " + strMenor + ")"; - } else { - strHaving = " HAVING (SUM(CONVAMOUNT) <> 0 OR SUM(CONVAMOUNTREF) <> 0)"; + strHaving = " HAVING (SUM(CONVAMOUNT) <= " + strMenor + ")"; } strOrderby = strHaving + strOrderby; diff -r b144c53d6ca3 -r 1fe9ce39fb42 src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql --- a/src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql Mon Dec 19 15:17:26 2011 +0100 +++ b/src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql Mon Dec 19 15:35:39 2011 +0100 @@ -99,7 +99,7 @@ HAVING SUM(pl.MovementQty) <> 0) rpp LEFT OUTER JOIN (SELECT pl.M_Product_ID, SUM(pl.MovementQty) AS ConsumedQty, - SUM(pl.MovementQty*C_CURRENCY_CONVERT(pl.CalcCost, ?, ?, TO_DATE(p.movementdate), null, pl.ad_client_id, pl.ad_org_id))/SUM(pl.MovementQty) AS CalcCost, + SUM(C_CURRENCY_CONVERT(pl.CalcCost, ?, ?, TO_DATE(p.movementdate), null, pl.ad_client_id, pl.ad_org_id))/SUM(pl.MovementQty) AS CalcCost, pl.M_ProductionPlan_ID FROM M_ProductionLine pl, M_ProductionPlan pp, M_Production p WHERE pl.ProductionType = '-' ------------------------------------------------------------------------------ Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
