Wed, 11 Mar 2015 13:23:31 +0100Related to issue 29110: Added a clear inside the loop
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Wed, 11 Mar 2015 13:23:31 +0100] rev 26165
Related to issue 29110: Added a clear inside the loop

Added a clear inside the loop to avoid performance problems

Wed, 11 Mar 2015 11:48:22 +0530Fixes Issue 29110:It is not possible to change currency in header tab in G/L
Atul Gaware <atul.gaware@openbravo.com> [Wed, 11 Mar 2015 11:48:22 +0530] rev 26164
Fixes Issue 29110:It is not possible to change currency in header tab in G/L
Journal

As there is trigger mutating error, updation of gl journal line currency and
currency rate is moved to a event handler from gl_journal_trg trigger.

Wed, 11 Mar 2015 15:19:41 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Wed, 11 Mar 2015 15:19:41 +0000] rev 26163
CI: merge back from main

Wed, 11 Mar 2015 15:01:31 +0000CI: update AD_MODULE to version 26159
RM packaging bot <staff.rm@openbravo.com> [Wed, 11 Mar 2015 15:01:31 +0000] rev 26162
CI: update AD_MODULE to version 26159

Wed, 11 Mar 2015 13:56:36 +0100Fixes issue 29245: An email related with the alert is sent to inactive users
Javier Etxarri <javier.echarri@openbravo.com> [Wed, 11 Mar 2015 13:56:36 +0100] rev 26161
Fixes issue 29245: An email related with the alert is sent to inactive users

Wed, 11 Mar 2015 10:42:05 +0100Fixed issue 28968: When installing a module the rebuild takes long to start.
Inigo Sanchez <inigo.sanchez@openbravo.com> [Wed, 11 Mar 2015 10:42:05 +0100] rev 26160
Fixed issue 28968: When installing a module the rebuild takes long to start.

The problem was that when installing a module the rebuild takes long to start.
This happened on environments with a lot of rows (Tested with 260.000 rows) on
the ad_session table.The result was this:

explain UPDATE AD_SESSION SET SESSION_ACTIVE='N' WHERE CREATEDBY<>'100'
Update on ad_session (cost=0.00..21546.15 rows=266303 width=147)

-> Seq Scan on ad_session (cost=0.00..21546.15 rows=266303 width=147)
Filter: ((createdby)::text <> '100'::text)
Approx time execution: 30000 ms

The new SQL Query to update is this:

explain UPDATE AD_SESSION SET SESSION_ACTIVE='N' WHERE CREATEDBY<>'100' and SESSION_ACTIVE='Y'
Update on ad_session (cost=0.42..4.44 rows=1 width=147)

-> Index Scan using ad_session_active_idx on ad_session (cost=0.42..4.44 rows=1 width=147)
Index Cond: (session_active = 'Y'::bpchar)
Filter: ((createdby)::text <> '100'::text)
Approx time execution: 30 ms

Adding the new condition "SESSION_ACTIVE = 'Y'" has been achieved to improve the performance.

Wed, 11 Mar 2015 09:17:00 +0100Related bug 28999: The i index is wrong.
Inigo Sanchez <inigo.sanchez@openbravo.com> [Wed, 11 Mar 2015 09:17:00 +0100] rev 26159
Related bug 28999: The i index is wrong.

Wed, 11 Mar 2015 07:13:25 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Wed, 11 Mar 2015 07:13:25 +0000] rev 26158
CI: merge back from main

Wed, 11 Mar 2015 06:51:47 +0000CI: update AD_MODULE to version 26156
RM packaging bot <staff.rm@openbravo.com> [Wed, 11 Mar 2015 06:51:47 +0000] rev 26157
CI: update AD_MODULE to version 26156

Wed, 11 Mar 2015 01:02:42 +0100Related bug 28999: Grant access to buttons is not working fine in some cases.
Inigo Sanchez <inigo.sanchez@openbravo.com> [Wed, 11 Mar 2015 01:02:42 +0100] rev 26156
Related bug 28999: Grant access to buttons is not working fine in some cases.

The issue had three parts to fix. The part that has been fixed is number two:
The problem was to grant access to buttons when "Secured_process" preference
was "Yes". This problem caused a bad behavior in access to buttons in child tabs.

This bad behavior is reproduced when inherit buttons are created in a non-active
child tab.The buttons are created from "actionToolbarButtons" not in
"toolBar.rightMembers". This was a problem because actionToolbarButtons did not
have "readOnlyIf" property. This property makes accessibility to a process work
correctly.

To solve this problem it has been set the property "readOnlyIf" in
"actionToolbarButtons" at the same time that in "toolBar.rightMembers".Thus when
inherit buttons are created in a child tab, the property "readOnlyIf" exists.
This will keep the same behavior on the inherited buttons in the child tabs.

Tue, 10 Mar 2015 21:49:47 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Tue, 10 Mar 2015 21:49:47 +0000] rev 26155
CI: merge back from main

Tue, 10 Mar 2015 21:31:04 +0000CI: update AD_MODULE to version 26153
RM packaging bot <staff.rm@openbravo.com> [Tue, 10 Mar 2015 21:31:04 +0000] rev 26154
CI: update AD_MODULE to version 26153

Tue, 10 Mar 2015 15:56:33 +0100related to issue 29124
Sandra Huguet <sandra.huguet@openbravo.com> [Tue, 10 Mar 2015 15:56:33 +0100] rev 26153
related to issue 29124

If total selected amount is less than bank statement line amount,
the actual payment should be the bank statement line amount
and the difference should be consider overpayment.

Tue, 10 Mar 2015 13:01:12 +0100fixed bug 29216: can't prevent filtering FK by identifier from Grid Configuration
Asier Lostalé <asier.lostale@openbravo.com> [Tue, 10 Mar 2015 13:01:12 +0100] rev 26152
fixed bug 29216: can't prevent filtering FK by identifier from Grid Configuration

It was not possible to prevent filtering FKs by identifier using Grid Configuration
because the js code added to ensure backwards compatibility for manual datasources
was trying to find this property in an incorrect place which was undefined, causing
a js exception which prevented the flow to continue.

Tue, 10 Mar 2015 12:20:08 +0100Fixes issue 29212: Filtering multiple products work in Return from/to P&E
Augusto Mauch <augusto.mauch@openbravo.com> [Tue, 10 Mar 2015 12:20:08 +0100] rev 26151
Fixes issue 29212: Filtering multiple products work in Return from/to P&E

The problem was that the HQL WHERE clause built by the AdvancedQueryBuilder was not proper, as it where using join aliases that where not present in the FROM clause. This happened when the AdvancedQueryBuilder was used in the HQLDataSourceService class, because that class uses the WHERE clause returned by the AdvancedQueryBuilder, and the HQL FROM clause defined in the application dictionary. The resulting HQL query was like this:

SELECT iol.id as id, ...
FROM OrderLine AS ol LEFT JOIN ol.salesOrder AS o
WHERE ...
AND (( join_0.id = :alias_0 or join_0.id = :alias_1 ) )

The first two lines are built using the HQL transformers based on the HQL defined in the application dictionary, and the last two lines are built using the AdvancedQueryBuilder. The WHERE clause uses a join alias (join_0) that is not defined in the FROM clause

The new join alias was created in the resolveJoins method, that was invoked when the criteria contained an OR operator. To fix this issue, a new flag, creatingJoinsInWhereClauseIsPrevented, has been added. If this flag is true, instead of creating a new join alias for the where clause, the clause will be built using the entity main alias and the property name. As for now this new flag is only set to true in the HqlDataSourceService class.

Tue, 10 Mar 2015 03:26:29 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Tue, 10 Mar 2015 03:26:29 +0000] rev 26150
CI: merge back from main

Tue, 10 Mar 2015 03:08:53 +0000CI: update AD_MODULE to version 26148
RM packaging bot <staff.rm@openbravo.com> [Tue, 10 Mar 2015 03:08:53 +0000] rev 26149
CI: update AD_MODULE to version 26148

Tue, 17 Feb 2015 01:11:53 +0530Fixes Issue 28035:Cannot pay a purchase order if it is invoiced with more
Atul Gaware <atul.gaware@openbravo.com> [Tue, 17 Feb 2015 01:11:53 +0530] rev 26148
Fixes Issue 28035:Cannot pay a purchase order if it is invoiced with more
orders and then reactivated and booked again

Fin_Payment_Scheduledetails are updated with fin_payment_schedule_order
only when found null. And only such schedule detail amounts are used to
calculate pending amount.

Mon, 09 Mar 2015 16:48:06 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Mon, 09 Mar 2015 16:48:06 +0000] rev 26147
CI: merge back from main

Mon, 09 Mar 2015 16:26:11 +0000CI: update AD_MODULE to version 26143
RM packaging bot <staff.rm@openbravo.com> [Mon, 09 Mar 2015 16:26:11 +0000] rev 26146
CI: update AD_MODULE to version 26143

Fri, 06 Mar 2015 15:14:41 +0100Related to 29124: Code Review.
Unai Martirena <unai.martirena@openbravo.com> [Fri, 06 Mar 2015 15:14:41 +0100] rev 26145
Related to 29124: Code Review.

When opening Add Payment window from Match Statement popup, if the totalselected amount is equal to Zero, the amount coming from bank statement line should be added to Actual Amount. In case the Actual Amount is different to Zero, then it should not be added. In this last case it was replacing the actual payment by bank statement line amount, and it is wrong.

Mon, 09 Mar 2015 16:51:31 +0100fixed issue 29201: Modify 'generate invoices' process to add the posibility to group SO with different orgs in a unique SI with a parent org.
Naiara Martinez <naiara.martinez@openbravo.com> [Mon, 09 Mar 2015 16:51:31 +0100] rev 26144
fixed issue 29201: Modify 'generate invoices' process to add the posibility to group SO with different orgs in a unique SI with a parent org.

New parameter 'Include child orgs' is added in the 'generate invoice' process, to group pending
Sales Order into one Sales Invoice with parent org.

Tue, 03 Mar 2015 18:19:16 +0100Related to bug 27313: Duns field in AD_ORGINFO will not be filled automatically
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Tue, 03 Mar 2015 18:19:16 +0100] rev 26143
Related to bug 27313: Duns field in AD_ORGINFO will not be filled automatically

AD_ORG_TRG trigger has been modified in order not to set automatically '?' value to duns column in AD_ORGINFO table

Fri, 07 Nov 2014 23:24:39 -0500Fixed bug 27313: D-U-N-S number should not be mandatory
Reinaldo Guerra <reinaldo.guerra@peoplewalking.com> [Fri, 07 Nov 2014 23:24:39 -0500] rev 26142
Fixed bug 27313: D-U-N-S number should not be mandatory

D-U-N-S number column in organization's information table was changed to non mandatory.
Now when introducing data in organization's information tab it is not necessary to fill D-U-N-S number as it is something that is not used in all the goberments/companies.

Fri, 06 Mar 2015 17:03:04 +0100Fixes issue 28939
Eduardo Argal Guibert <eduardo.argal@openbravo.com> [Fri, 06 Mar 2015 17:03:04 +0100] rev 26141
Fixes issue 28939
Perfromance problem running module script in environments with large amount of transactions (invoices and orders).
New index is added in postgres environments when this is not present. Problem comes from table recreation, so impacts those who update from a version that requires invoice table rebuilding.

Fri, 06 Mar 2015 16:52:17 +0100Related to issue 28909
Eduardo Argal Guibert <eduardo.argal@openbravo.com> [Fri, 06 Mar 2015 16:52:17 +0100] rev 26140
Related to issue 28909
Change variable definition to public to be able to retrieve the value

Fri, 06 Mar 2015 15:03:31 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Fri, 06 Mar 2015 15:03:31 +0000] rev 26139
CI: merge back from main

Fri, 06 Mar 2015 14:42:49 +0000CI: update AD_MODULE to version 26133
RM packaging bot <staff.rm@openbravo.com> [Fri, 06 Mar 2015 14:42:49 +0000] rev 26138
CI: update AD_MODULE to version 26133

Fri, 06 Mar 2015 11:31:38 +0100Related to issue 28909
Eduardo Argal Guibert <eduardo.argal@openbravo.com> [Fri, 06 Mar 2015 11:31:38 +0100] rev 26137
Related to issue 28909
can't create orders in Oracle. Created StockUtils class to enable calls to M_GET_STOCK_PARAM procedure
getting out params

H : Enter commit message. Lines beginning with 'HG:' are removed.

Fri, 06 Mar 2015 11:21:26 +0100Fixes issue 29168
Eduardo Argal Guibert <eduardo.argal@openbravo.com> [Fri, 06 Mar 2015 11:21:26 +0100] rev 26136
Fixes issue 29168
getCallableResult broken when using null parameters. Removed TEST value for default