Mon, 13 Mar 2017 11:02:48 +0000Update AD_MODULE version to 3.0PR17Q1 3.0PR17Q1
RM packaging bot <staff.rm@openbravo.com> [Mon, 13 Mar 2017 11:02:48 +0000] rev 32039
Update AD_MODULE version to 3.0PR17Q1

Fri, 10 Mar 2017 11:11:58 -0500Fixes issue 35491:Error creating an Order from a Requisition To Order.
Miguel <martencobasmiguel@gmail.com> [Fri, 10 Mar 2017 11:11:58 -0500] rev 32038
Fixes issue 35491:Error creating an Order from a Requisition To Order.

In AUM project the Constraint c_orderline_check1 was modified, to only allow creation
of order lines whith QUANTITYORDER and M_PRODUCT_UOM_ID values null or not null at same time.
When they were created from the Requisition to Order process, the Order line's QUANTITYORDER
was created with 0 in the case it had a NULL value, instead of maintain the value as NULL.
Because of it the constraint was failing because a QUANTITYORDER=0 and a M_PRODUCT_UOM_ID=NULL.

To solve this problem was modified the linesToOrder query in RequisitionToOrder_data.xsql, to
retrieve the correct value of QUANTITYORDER, including NULL if there are no qty in the second
UOM.

Thu, 09 Mar 2017 14:22:29 -0500Fixes issue 35371: Wrong orders shown in "Create Invoices From Orders" window
Miguel <martencobasmiguel@gmail.com> [Thu, 09 Mar 2017 14:22:29 -0500] rev 32037
Fixes issue 35371: Wrong orders shown in "Create Invoices From Orders" window

Fixed the C_INVOICE_CANDIDATE_V view, changing the condition to not take into account
the sales orders different than 'ON' AND 'OB' AND 'WR' instead of using an incorrect
OR condition as suggested in the proposed solution.

Also were included some performances in the view replacing OR and AND conditions with they
respectively translations to IN and NOT IN clauses.

Fri, 10 Mar 2017 12:14:46 +0100Fixes Issue 35479. Fixes problem while setting alias in a subquery in Oracle.
David Miguelez <david.miguelez@openbravo.com> [Fri, 10 Mar 2017 12:14:46 +0100] rev 32036
Fixes Issue 35479. Fixes problem while setting alias in a subquery in Oracle.

Fri, 10 Mar 2017 10:24:11 +0100Fixed issue 35464: Adaptive filtering does not work for Table references.
Inigo Sanchez <inigo.sanchez@openbravo.com> [Fri, 10 Mar 2017 10:24:11 +0100] rev 32035
Fixed issue 35464: Adaptive filtering does not work for Table references.

The problem was that adaptive filtering (filter in client when all data is locally available) did
not work for Table references when filtering by text instead of by selecting a value in the drop
down list. The issue that causes this regression was not taking into account adaptive filtering.

This problem has been fixed by taking into account this case in getDisplayProperty method. Now
getDisplayProperty method manages properly when all the data are in the client (Adaptive filtering).

Thu, 09 Mar 2017 13:08:47 +0100fixed bug 35467: views with several IN or NOT IN clasues fail in PG
Asier Lostalé <asier.lostale@openbravo.com> [Thu, 09 Mar 2017 13:08:47 +0100] rev 32034
fixed bug 35467: views with several IN or NOT IN clasues fail in PG

In PG, views that contain more than one IN or NOT IN clauses were not correctly
exported.

The regexps that parses and PG IN and NOT IN clauses was including from the begining
of 1st clause till the end of the last one.

These regexps have been fixed to be more restrictive so that they stop looking
for the IN contents on first ].

Tue, 14 Mar 2017 17:48:14 +0100Fixes issue 35241: Random failure in TestCosting when executing it in Oracle
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Tue, 14 Mar 2017 17:48:14 +0100] rev 32033
Fixes issue 35241: Random failure in TestCosting when executing it in Oracle

Fix testCostingGM5 adding new sleeps.

Sat, 11 Mar 2017 00:46:09 +0530Fixes Issue 35137: Concurrency problem: current balance wrongly calculated
Atul Gaware <atul.gaware@openbravo.com> [Sat, 11 Mar 2017 00:46:09 +0530] rev 32032
Fixes Issue 35137: Concurrency problem: current balance wrongly calculated
when 2 transactions are processed at same time

Lock added at database level for financial account being used while processing
or reactivating transaction.

Tue, 14 Mar 2017 16:55:41 +0100fixes bug 35509: OBQuery without an alias and a select clause is not working
Carlos Aristu <carlos.aristu@openbravo.com> [Tue, 14 Mar 2017 16:55:41 +0100] rev 32031
fixes bug 35509: OBQuery without an alias and a select clause is not working

Mon, 13 Mar 2017 14:22:51 +0100Fixed issue 35489: Wrong priority between different possible translations
Inigo Sanchez <inigo.sanchez@openbravo.com> [Mon, 13 Mar 2017 14:22:51 +0100] rev 32030
Fixed issue 35489: Wrong priority between different possible translations

The problem was when you have an especific translation for a static text in a report (registered
in ad_textinterfaces with the filename column pointing to the repport) and there was a general
translation for the same static text. In this situation, the query that returns the possible
translations prioritizes the general translation over the specific translation.

The problem has been fixed by edit the query and prioritizes a especific translation for a static
text in a report instead of the general translation. Besides it have been removed some unnecessary
lines of code.