Fri, 08 Apr 2016 10:40:36 +0200related to bug 32605: removed some duplication
Asier Lostalé <asier.lostale@openbravo.com> [Fri, 08 Apr 2016 10:40:36 +0200] rev 28865
related to bug 32605: removed some duplication

hql where clause was converted to lower case several times

Thu, 07 Apr 2016 11:26:17 +0200Related to Issue 32341: Prevents infinite loop if organization is null
David Miguelez <david.miguelez@openbravo.com> [Thu, 07 Apr 2016 11:26:17 +0200] rev 28864
Related to Issue 32341: Prevents infinite loop if organization is null

Wed, 02 Mar 2016 10:18:21 +0100Fixes issue 32341: Performance problem in ResetAccounting
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Wed, 02 Mar 2016 10:18:21 +0100] rev 28863
Fixes issue 32341: Performance problem in ResetAccounting

Modify ad_org_getperiodcontrolallow function to make it recursive and improve its query.
Execute query only once in ResetAccounting.java and for every orgIds instead of for each orgId in orgIds. Query will be done in SQL instead of HQL to avoid errors when executing PostDocumentTest.

Wed, 06 Apr 2016 11:12:42 +0200Related issue 32584: Code review and improvements
Inigo Sanchez <inigo.sanchez@openbravo.com> [Wed, 06 Apr 2016 11:12:42 +0200] rev 28862
Related issue 32584: Code review and improvements

Now WSWithNoActiveDalObjects works with Currency entity instead of
Organization entity in order to avoid some problems that appears
in this test in Oracle. (int-checks-oracle).

Besides it have been added small changes to improve legibility.

Tue, 05 Apr 2016 17:33:10 +0200Related to issue 32536: Code review improvements
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Tue, 05 Apr 2016 17:33:10 +0200] rev 28861
Related to issue 32536: Code review improvements

Avoid using orglist column also in SL_ProductPrice_PriceListVersion class.

Mon, 04 Apr 2016 10:41:45 +0530Fixes Issue 32536: Organizations not available in BalanceSheet and PL Structure
Atul Gaware <atul.gaware@openbravo.com> [Mon, 04 Apr 2016 10:41:45 +0530] rev 28860
Fixes Issue 32536: Organizations not available in BalanceSheet and PL Structure

Organization list is fetched using query instead of column orglist

Tue, 05 Apr 2016 18:08:46 +0200Related to issue 32539: Update copyright
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Tue, 05 Apr 2016 18:08:46 +0200] rev 28859
Related to issue 32539: Update copyright

Tue, 05 Apr 2016 18:49:43 +0530Fixes issue 32539: Fixed wrong calculation in acct with operands
Sanjota <sanjota.nelagi@promantia.com> [Tue, 05 Apr 2016 18:49:43 +0530] rev 28858
Fixes issue 32539: Fixed wrong calculation in acct with operands

Use #AccessibleOrgTree instead of #User_Org.

Tue, 05 Apr 2016 17:50:00 +0200Related to bug 32584: fix a problem related to context in a test.
Inigo Sanchez <inigo.sanchez@openbravo.com> [Tue, 05 Apr 2016 17:50:00 +0200] rev 28857
Related to bug 32584: fix a problem related to context in a test.

Tue, 05 Apr 2016 17:13:38 +0200fixed bug 32605: widgets summary field not displayed if HQL has group by clause
Asier Lostalé <asier.lostale@openbravo.com> [Tue, 05 Apr 2016 17:13:38 +0200] rev 28856
fixed bug 32605: widgets summary field not displayed if HQL has group by clause

When calculating in backend summary function, group by clause must be removed
from the query as all values should be aggregated without grouping.

Tue, 05 Apr 2016 17:12:02 +0200related to bug 32605: widget summary not displayed if HQL has group by clause
Asier Lostalé <asier.lostale@openbravo.com> [Tue, 05 Apr 2016 17:12:02 +0200] rev 28855
related to bug 32605: widget summary not displayed if HQL has group by clause

Added log in case exception is thrown when executing summary query.

Tue, 05 Apr 2016 16:50:22 +0200Related to bug 32584: Added test cases covering this regression
Inigo Sanchez <inigo.sanchez@openbravo.com> [Tue, 05 Apr 2016 16:50:22 +0200] rev 28854
Related to bug 32584: Added test cases covering this regression

Tue, 05 Apr 2016 16:26:21 +0200fixed bug 32604: Stock by Warehouse widget logs error message
Asier Lostalé <asier.lostale@openbravo.com> [Tue, 05 Apr 2016 16:26:21 +0200] rev 28853
fixed bug 32604: Stock by Warehouse widget logs error message

Quantiy on hand summary was incorrectly defined.

This summary has been removed because functionally it does not make sense to
sum quantities of different products and it would add performance degradation.

Tue, 05 Apr 2016 14:53:57 +0200Fixed bug 32584: fetch method does not retrieves data with a non active entity
Inigo Sanchez <inigo.sanchez@openbravo.com> [Tue, 05 Apr 2016 14:53:57 +0200] rev 28852
Fixed bug 32584: fetch method does not retrieves data with a non active entity

The problem here was that fetch method does not retrieves data with a non active
entity. (e.g., if it is tried to obtain a non active organization). It is not take
into account non active entities.

Now, the issues has been fixed by adding setFilterOnActive(false); to take into
account non active entities too.

Tue, 05 Apr 2016 12:21:35 +0200related to issue 32519: updated javadoc
Asier Lostalé <asier.lostale@openbravo.com> [Tue, 05 Apr 2016 12:21:35 +0200] rev 28851
related to issue 32519: updated javadoc

Tue, 22 Mar 2016 08:23:42 +0100fixed 32519: Openbravo.properties can be overriden from an absolute path
Asier Lostalé <asier.lostale@openbravo.com> [Tue, 22 Mar 2016 08:23:42 +0100] rev 28850
fixed 32519: Openbravo.properties can be overriden from an absolute path

It is now possible to override some properties by defining an abosolute path
to a properties file through properties.path system property.

Mon, 04 Apr 2016 18:22:09 +0200Related to issue 32281: Add coalesce to avoid null value in v_reservationqty
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Mon, 04 Apr 2016 18:22:09 +0200] rev 28849
Related to issue 32281: Add coalesce to avoid null value in v_reservationqty

Thu, 25 Feb 2016 09:46:02 -0500Fixed issue 32281: Wrong movement quantity of the picking list without enough stock available
Rafael Queralta Pozo <rqueralta@nauta.cu> [Thu, 25 Feb 2016 09:46:02 -0500] rev 28848
Fixed issue 32281: Wrong movement quantity of the picking list without enough stock available

Now, movement quantity of the picking list if stock available is not enough is equal to stock avilable - manual reservation qty

Wed, 30 Mar 2016 15:32:26 +0530Fixes Issue 32463: "Total payment" not correct in ReportRegisterByVatJR report
Atul Gaware <atul.gaware@openbravo.com> [Wed, 30 Mar 2016 15:32:26 +0530] rev 28847
Fixes Issue 32463: "Total payment" not correct in ReportRegisterByVatJR report

IsSale value in the data file was compared with different name as in jrxml query to negate tax line values in case of sales or purchase transaction in variable calculation. Now they are kept uniform in both jrxml as well as data xsql file.

Mon, 28 Mar 2016 16:16:15 +0530Fixes issue 32440: Same currency in Simple G/L Journal header and lines
Sanjota <sanjota.nelagi@promantia.com> [Mon, 28 Mar 2016 16:16:15 +0530] rev 28846
Fixes issue 32440: Same currency in Simple G/L Journal header and lines

Mon, 04 Apr 2016 11:59:06 +0200Related to issue 32392: Remove unused variables and methods
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Mon, 04 Apr 2016 11:59:06 +0200] rev 28845
Related to issue 32392: Remove unused variables and methods

Mon, 28 Mar 2016 12:44:57 -0400Fixes issue 32392: Wrong value in qtyreserved column of m_storage_pending in sales quotation.
Mark <m.molina@nectus.com> [Mon, 28 Mar 2016 12:44:57 -0400] rev 28844
Fixes issue 32392: Wrong value in qtyreserved column of m_storage_pending in sales quotation.

When the "Create Order process" was launched from a Sales Quotation that generates pending storage, the ordered quantity in the M_STORAGE_PENDING was the double than the original for a recently created product. It was caused because a double call of the M_UPDATE_STORAGE_PENDING PL. Inside the C_ORDER_POST PL (it creates the entry inside the M_STORAGE_PENDING with the quantity reserved), and then the lines were processed again, the M_UPDATE_STORAGE_PENDING was called again and it updates the previously created entry increasing the quantity reserved once more time.
The process is working as expected now.

Mon, 04 Apr 2016 11:52:47 +0200fixed bug 32576: connection leak when printing Requisition report
Asier Lostalé <asier.lostale@openbravo.com> [Mon, 04 Apr 2016 11:52:47 +0200] rev 28843
fixed bug 32576: connection leak when printing Requisition report

Ensure methods used by Requisition subreports close DAL transaction after using
it so that the connection is returned back to the pool.

Fri, 01 Apr 2016 14:45:21 +0200fixed bug 28586: error logged showing translatable identifier
Asier Lostalé <asier.lostale@openbravo.com> [Fri, 01 Apr 2016 14:45:21 +0200] rev 28842
fixed bug 28586: error logged showing translatable identifier

Having at least one translation installed in the system, whenever a DAL
identifier composed by translatable properties when retrieved, an error was
logged in case the translation entity for that property was not granted to
current role.

This is fixed by executing the query to retrieve translation in admin mode.

If the base property is granted at least in referred mode, its translations
should be accessible, so it is not problematic to set admin.

Fri, 01 Apr 2016 10:08:39 +0200Fixes issue 32553: Constraints and fks can be reenabled for a given table
Augusto Mauch <augusto.mauch@openbravo.com> [Fri, 01 Apr 2016 10:08:39 +0200] rev 28841
Fixes issue 32553: Constraints and fks can be reenabled for a given table

The method PlatformImplBase.enableCheckConstraintsForTable was not implemented properly, as it was trying to disable the constraints of a table instead of to enable it.

Also the enableAllFkForTable method was only defined in PostgreSqlPlatform, it should also be defined in enableAllFkForTable.

Wed, 23 Mar 2016 20:52:00 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Wed, 23 Mar 2016 20:52:00 +0000] rev 28840
CI: merge back from main

Wed, 23 Mar 2016 20:37:56 +0000CI: update AD_MODULE to version 28838
RM packaging bot <staff.rm@openbravo.com> [Wed, 23 Mar 2016 20:37:56 +0000] rev 28839
CI: update AD_MODULE to version 28838

Wed, 23 Mar 2016 16:10:06 +0100fixes issue 32541: invoice report can not be printed by manual roles
Carlos Aristu <carlos.aristu@openbravo.com> [Wed, 23 Mar 2016 16:10:06 +0100] rev 28838
fixes issue 32541: invoice report can not be printed by manual roles

Now the Window object is retrieved using admin mode.

Wed, 23 Mar 2016 01:00:40 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Wed, 23 Mar 2016 01:00:40 +0000] rev 28837
CI: merge back from main

Wed, 23 Mar 2016 00:46:37 +0000CI: update AD_MODULE to version 28834
RM packaging bot <staff.rm@openbravo.com> [Wed, 23 Mar 2016 00:46:37 +0000] rev 28836
CI: update AD_MODULE to version 28834