int-basic-oracle - Build # 1814 - Fixed:
Check console output at https://ci.openbravo.com/job/int-basic-oracle/1814/ to
view the results.
Committers since last success:
Changes for Build #1812
David Miguelez <[email protected]> null
Related to Issue 35410. Code Review.
Fixes problem when retrieving currency from parameter window.
Also, fixes problem of currency reloading when no organization has been changed.
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.java
Víctor Martínez Romanos <[email protected]> null
Fixed issue 35410: Default currency in Pareto Product Report
Set default currency according to the selected organization
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.html
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.java
Víctor Martínez Romanos <[email protected]> null
Fixed bug 32493: Pareto Product Report performance refactor
The Pareto Product report had very important performance issues due to the way
data was retrieved from the database.
Multiple (and unnecessary) sequencial scans were executed on high volume tables
making the report unusable on real environments.
Besides it has been detected that the information shown was not right: products
without stock might appear in the report, the percentages were clearly not
right and the ABC category was also wrong because it was based on wrong
percentages.
The fix mainly includes a total refactor of the queries, which fixes most of
the performance issues.
It also adds data aggregation support based on Valued Stock aggregated data,
which should help to keep the report's performance when the time goes by.
It has been tested that, even without aggregated data, the report performs
really well on high volume environments. Example: An environment without
aggregated data and with 7.7E+6 transactions took only 38 seconds to get the
data for an organization with 250E+3 transactions; before it took "days".
List of important changes:
* Deprecated M_GET_PARETO_ABC function and implemented the same logic directly
into the SQL query
* Added index on M_TRANSACTION_COST table to the DATEACCT column, which is
heavily used as a filter criteria for many reports (included Pareto Product)
* Modified index M_VALUED_STOCK_AGG_DATETO on M_VALUED_STOCK_AGG to take into
account AD_ORG_ID and DATETO. This makes the queries to get data from this
aggregated table to perform really well.
* Modified ReportParetoProduct_data.xsq select query. This is actually the key
to get the performance improvement:
* Usage of window functions to calculate:
* the total value per organization's warehouse,
* the percentage per product and organization's warehouse,
* the accumulated percentage per product and organization's warehouse.
* The ABC is calculated looking at the accumulated percentage gotten before
instead of calling the M_GET_PARETO_ABC db function.
* Reduced the usage of functions in select clause because, although
individually they are quite fast, they must be executed over multiple records
thus making the whole query really slow (example 2ms multiplied by 10E3 records
delays the query 20 seconds!):
* ad_get_org_le_bu is not needed anymore because the legal entity will be
always the same for each record in the report. Note that the Pareto's
organization combo only shows legal entities or child organizations (which only
have a unique legal entity).
* c_currency_convert_precision is only called when a currency conversion is
needed, thus reducing unnecessary overhead.
* ad_column_identifier calls have been removed. Instead we get static
(translated) values.
* Transactions are now filtered by trxprocessdate when the costing rule was
started, so we avoid to compute legacy records.
* Although not strictly necessary to get a performance improvement, the query
has been split in several CTEs, thus making the query more readable and easy to
maintain.
src-db/database/model/functions/M_GET_PARETO_ABC.xml
src-db/database/model/tables/M_TRANSACTION_COST.xml
src-db/database/model/tables/M_VALUED_STOCK_AGG.xml
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.java
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java
Carlos Aristu <[email protected]> null
related to issue 35397: add missing javadoc information
src/org/openbravo/dal/xml/EntityXMLConverter.java
Changes for Build #1813
Víctor Martínez Romanos <[email protected]> null
Related to issue 35089: Excel format wasn't generated after merging xlsx
project
Added support for XLSX format.
src/org/openbravo/common/actionhandler/AgingBalanceReportActionHandler.java
Ander Iraceburu <[email protected]> null
Related to issue 33206: Fixed dbcons
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
Alvaro Ferraz <[email protected]> null
Related to issue 32265: TaxesTest refactor
Fix current tests and add more tests:
https://docs.google.com/spreadsheets/d/1qsDD2LOCVILuVtCGGQEHtarTkKJHgnW90m3OyVzLxU4/edit?ts=582051de#gid=729589137
src-test/src/org/openbravo/test/taxes/data/TaxesLineTestData.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData100.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData101.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData102.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData103.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData104.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData105.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData106.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData107.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData108.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData109.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData110.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData111.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData112.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData113.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData114.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData115.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData116.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData117.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData118.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData119.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData120.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData121.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData122.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData123.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData124.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData125.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData126.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData127.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData128.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData129.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData130.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData131.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData132.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData133.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData134.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData135.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData136.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData137.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData138.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData139.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData140.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData141.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData142.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData143.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData144.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData145.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData146.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData147.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData148.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData149.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData150.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData151.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData152.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData153.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData154.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData155.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData156.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData157.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData158.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData159.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData160.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData35.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData36.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData37.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData38.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData39.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData40.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData41.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData42.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData43.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData44.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData45.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData46.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData47.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData48.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData49.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData50.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData51.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData52.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData53.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData54.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData55.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData56.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData57.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData58.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData59.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData60.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData61.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData62.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData63.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData64.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData65.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData66.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData67.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData68.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData69.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData70.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData71.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData72.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData73.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData74.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData75.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData76.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData77.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData78.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData79.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData80.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData81.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData82.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData83.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData84.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData85.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData86.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData87.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData88.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData89.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData90.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData91.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData92.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData93.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData94.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData95.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData96.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData97.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData98.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData99.java
referencedata/sampledata/QA_Testing/C_BPARTNER.xml
referencedata/sampledata/QA_Testing/C_TAX.xml
referencedata/sampledata/QA_Testing/C_TAXCATEGORY.xml
referencedata/sampledata/QA_Testing/C_TAXCATEGORY_TRL.xml
referencedata/sampledata/QA_Testing/C_TAX_ACCT.xml
referencedata/sampledata/QA_Testing/C_TAX_TRL.xml
src-test/src/org/openbravo/test/taxes/TaxesTest.java
src-test/src/org/openbravo/test/taxes/data/ProductDataConstants.java
src-test/src/org/openbravo/test/taxes/data/TaxDataConstants.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData1.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData10.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData11.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData12.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData13.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData14.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData15.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData16.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData17.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData18.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData19.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData2.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData20.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData21.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData22.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData23.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData24.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData25.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData26.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData27.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData28.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData29.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData3.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData30.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData31.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData32.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData33.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData34.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData4.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData5.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData6.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData7.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData8.java
src-test/src/org/openbravo/test/taxes/data/TaxesTestData9.java
Alvaro Ferraz <[email protected]> null
Fixes issue 32265: Fix price including taxes at document level
Do not round line amounts and tax bases, and header tax bases, in case price
including taxes at document level, when document is in draft status.
Round them when completing the document.
Call again line triggers to calculate again amounts and taxes without rounding
when reactivating the document.
Do not calculate document net amount incrementally in case price including
taxes as we need to sum rounded taxes instead of round the sum of taxes.
Adjust taxes at line level in case price including taxes to make sure line tax
base amount + line tax amount is equals line gross amount.
Adjust taxes at document level, when completing the document, in case price
including taxes at document level, to make sure document tax base amount +
document tax amount is equals document gross amount.
Adjust line amount, when completing the document, in case price including taxes
at document level, to make sure sum of line net amounts is equals document net
amount.
When reactivating price including taxes invoices with manual taxes, no
recalculate taxes will be automatically deleted.
src-db/database/model/functions/C_GET_NET_AMOUNT_FROM_GROSS.xml
src-db/database/model/functions/C_INVOICELINETAX_INSERT.xml
src-db/database/model/functions/C_INVOICE_POST.xml
src-db/database/model/functions/C_ORDERLINETAX_INSERT.xml
src-db/database/model/functions/C_ORDER_POST1.xml
src-db/database/model/tables/C_ORDERLINETAX.xml
src-db/database/model/tables/C_ORDERTAX.xml
src-db/database/model/triggers/C_INVLINE_CHK_RESTRICTIONS_TRG.xml
src-db/database/model/triggers/C_INVOICELINETAX_TRG.xml
src-db/database/model/triggers/C_INVOICELINE_BEFORE_TRG.xml
src-db/database/model/triggers/C_INVOICELINE_TRG2.xml
src-db/database/model/triggers/C_ORDERLINETAX_TRG.xml
src-db/database/model/triggers/C_ORDERLINE_TRG.xml
src-db/database/model/triggers/C_ORDERLINE_TRG2.xml
Alvaro Ferraz <[email protected]> null
Fixes issue 32265: Calculate linenetamount from gross amount instead from
price
Calculate linenetamount from gross amount instead from price in C_OrderLine and
C_InvoiceLine triggers using new C_Get_Net_Amount_From_Gross function.
Before, we were calculating Net Unit Price from Gross Unit Price and then Line
Net Amount from Net Unit Price by multiplying by the quantity. Thus, we were
increasing the rounding error.
Now, we calculate first Line Net Amount from Line Gross Amount and then Net
Unit Price from Line Net Amount by dividing by the quantity. Thus, we are
decreasing the rounding error.
src-db/database/model/functions/C_GET_NET_AMOUNT_FROM_GROSS.xml
src-db/database/model/triggers/C_INVOICELINE_BEFORE_TRG.xml
src-db/database/model/triggers/C_INVOICELINE_TRG2.xml
src-db/database/model/triggers/C_ORDERLINE_TRG.xml
src-db/database/model/triggers/C_ORDERLINE_TRG2.xml
Ander Iraceburu <[email protected]> null
Related to issue 33206: Code Review 4
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeExtendedJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt_doctypecount.jrxml
Ander Iraceburu <[email protected]> null
Related to issue 33206: Fixed dbcons
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
Ander Iraceburu <[email protected]> null
Related to issue 33206: Code Review 3
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeExtendedJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt_doctypecount.jrxml
Ander Iraceburu <[email protected]> null
Related to issue 33206: Code Review 2
src/org/openbravo/base/secureApp/OrgTree.java
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeExtendedJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt_doctypecount.jrxml
Ander Iraceburu <[email protected]> null
Related to issue 33206: Code Review
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt_doctypecount.jrxml
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
src/org/openbravo/base/secureApp/OrgTree.java
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeExtendedJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt.jrxml
Ander Iraceburu <[email protected]> null
Related to issue 33206: Fixed dbcons
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
Ander Iraceburu <[email protected]> null
Fixes issue 33206: Sales Invoice Dimensional Report. New features
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalyses_srpt.jrxml
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeExtendedJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesMultiComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml
Asier Martirena <[email protected]> null
Merged from PI
Asier Martirena <[email protected]> null
[Gift Cards] Changes after doing an export database
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
Asier Martirena <[email protected]> null
Fixed junit test that contains a deprecated method
src-test/src/org/openbravo/test/cancelandreplace/CancelAndReplaceTest.java
Asier Martirena <[email protected]> null
Merged from PI
Eduardo Becerra <[email protected]> null
[Cashup] Include a new field in OBPOSPaymentcashupEvents to register
related transaction (Create new Selector)
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
Aaron Calero <[email protected]> null
[Payment method enhancement for WebPOS] Fixed deprecation messages
src/org/openbravo/common/actionhandler/SetNewBPCurrency.java
Eduardo Argal Guibert <[email protected]> null
[Payment method enhancement for WebPOS] Fixes FIN_PaymentProcess not to use
isPOSOrder property
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_PaymentProcess.java
src/org/openbravo/common/actionhandler/SetNewBPCurrency.java
src/org/openbravo/erpCommon/businessUtility/CancelAndReplaceUtils.java
Changes for Build #1814
Armaignac <[email protected]> null
Fixes issue 34992: Voiding an invoice which is prepaid via sales order
When a prepaid invoice via sales order was voided the payment plan tab is empty,
the prepayment amount was wrong for both invoices and the created reversed
invoice
paid state was also incorrect
Now a new method was created in ProcessInvoice to fix wrong data, the original
and
reverse invoice prepayment amount it's 0, the reversal invoice is mark as paid,
also a dummy payment is created and processed for a 0 amount, including two
lines,
one line related to the invoice (+50.00) and the other one related to the
reverse
invoice (-50.00)
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/ProcessInvoice.java
Last 20 lines of the console output:
[...truncated 19386 lines...]
Total time: 2 seconds
executing script 'Tomcat stop'
[int-basic-oracle] $ /bin/bash /tmp/build_step_template2529575684259929862.sh
ENABLE
DEBUG: Tomcat stop called with parameters: ENABLED=ENABLE
* Stopping Tomcat servlet engine for Openbravo tomcat
...done.
executing script 'Check openbravo log'
[int-basic-oracle] $ /bin/bash /tmp/build_step_template5236203946270722973.sh
ENABLE
DEBUG: Check openbravo log called with parameters: ENABLED=ENABLE
Check log: openbravo log (artifact: int-basic-oracle.log) is clean
Recording test results
Archiving artifacts
Checking \] ERROR|\] WARN
Email was triggered for: Fixed
Trigger Success was overridden by another trigger and will not send an email.
Sending email for trigger: Fixed
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-builds mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-builds
