Thu, 05 Dec 2019 16:02:05 -0500Fixes BUG-42426: Financial account window performance for LASTRECON and default tip
Armaignac <collazoandy4@gmail.com> [Thu, 05 Dec 2019 16:02:05 -0500] rev 36865
Fixes BUG 42426: Financial account window performance for LASTRECON and
APRM_LASTREC auxiliary inputs

The perfomance for LASTRECON and APRM_LASTREC auxiliary inputs is bad with high
volume of records in fin_reconciliation window because a sequence scan is made
while filtering by created

A new Index for created and fin_financial_account_id columns was created in
fin_reconciliation table

Thu, 12 Dec 2019 12:10:47 +0100Related to Issue 42352. Format changes in the Query to follow
David Miguelez <david.miguelez@openbravo.com> [Thu, 12 Dec 2019 12:10:47 +0100] rev 36864
Related to Issue 42352. Format changes in the Query to follow
standard conventions

Thu, 12 Dec 2019 10:28:07 +0100Fixes Issue 42352: Error voiding sales invoice
David Miguelez <david.miguelez@openbravo.com> [Thu, 12 Dec 2019 10:28:07 +0100] rev 36863
Fixes Issue 42352: Error voiding sales invoice

The function use to get the invoice status from shipment was not taking into account
the invoice document status

Now the invoice document status is taked into account while computing the status from
shipment

Thu, 12 Dec 2019 21:56:32 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Thu, 12 Dec 2019 21:56:32 +0000] rev 36862
CI: merge back from main

Thu, 12 Dec 2019 21:42:11 +0000CI: update AD_MODULE to version 36860
RM packaging bot <staff.rm@openbravo.com> [Thu, 12 Dec 2019 21:42:11 +0000] rev 36861
CI: update AD_MODULE to version 36860

Thu, 12 Dec 2019 06:09:26 +0000Merge back from main
RM packaging bot <staff.rm@openbravo.com> [Thu, 12 Dec 2019 06:09:26 +0000] rev 36860
Merge back from main

Thu, 12 Dec 2019 06:06:10 +0000Merge temporary head for 3.0PR19Q4
RM packaging bot <staff.rm@openbravo.com> [Thu, 12 Dec 2019 06:06:10 +0000] rev 36859
Merge temporary head for 3.0PR19Q4

Mon, 02 Dec 2019 06:26:02 +0000Added signature for changeset aa80c1095a9a
RM packaging bot <staff.rm@openbravo.com> [Mon, 02 Dec 2019 06:26:02 +0000] rev 36858
Added signature for changeset aa80c1095a9a

Mon, 02 Dec 2019 06:26:02 +0000Added tag 3.0PR19Q4 for changeset befde545395e
RM packaging bot <staff.rm@openbravo.com> [Mon, 02 Dec 2019 06:26:02 +0000] rev 36857
Added tag 3.0PR19Q4 for changeset befde545395e

Mon, 02 Dec 2019 06:26:02 +0000Update AD_MODULE version to 3.0PR19Q4 3.0PR19Q4
RM packaging bot <staff.rm@openbravo.com> [Mon, 02 Dec 2019 06:26:02 +0000] rev 36856
Update AD_MODULE version to 3.0PR19Q4

Thu, 31 Oct 2019 09:05:28 +0100fixed bug 42161: grid timeout returns unclear message
Asier Lostalé <asier.lostale@openbravo.com> [Thu, 31 Oct 2019 09:05:28 +0100] rev 36855
fixed bug 42161: grid timeout returns unclear message

When a query timeout occurs fetching grid data, the message displayed in
UI is not user friendly.

This is caused by different exception thrown after Hibernate upgrade.

Wed, 30 Oct 2019 12:03:22 +0100Fixes issue 42152: The list of supported/recommended browsers should be updated
Pablo Lujan <pablo.lujan@openbravo.com [Wed, 30 Oct 2019 12:03:22 +0100] rev 36854
Fixes issue 42152: The list of supported/recommended browsers should be updated

Wed, 30 Oct 2019 11:57:05 +0100Fixes issue 42151: The list of supported/recommended browsers should be updated
Pablo Lujan <pablo.lujan@openbravo.com [Wed, 30 Oct 2019 11:57:05 +0100] rev 36853
Fixes issue 42151: The list of supported/recommended browsers should be updated

Wed, 16 Oct 2019 16:04:15 +0200Fixes issue 42028: C_PeriodControl table's C_Period_ID column's is_child_property_in_parent flag set to Yes
Iñigo Lerga <inigo.lerga@openbravo.com> [Wed, 16 Oct 2019 16:04:15 +0200] rev 36852
Fixes issue 42028: C_PeriodControl table's C_Period_ID column's is_child_property_in_parent flag set to Yes

It sets C_PeriodControl table's C_Period_ID column's is_child_property_in_parent flag = Yes, so that child property i.e financialMgmtPeriodControlList is included in its parent i.e FinancialMgmtPeriod

Mon, 07 Oct 2019 21:31:45 -0300Fixes issue 41936: Take into account total paid when calculating the outstanding
Mark Molina <mark.molina@doceleguas.com> [Mon, 07 Oct 2019 21:31:45 -0300] rev 36851
Fixes issue 41936: Take into account total paid when calculating the outstanding
amount of lines when using the Modify Payment Plan feature.

In some cases, using the Modify Payment Plan feature was shoing that the Outstanding Amount
was invalid because the total invoice amount was considered when validating the Outstanding Amount
but wasn't taking into account the other payment plans already paid.
The issue on this situation was to to get the received amount from records shown in
the grid, as those lines already paid are not shown in the pop up grid, the amount
don'tr match and an error is shown to the user.

To fix this issue is validated that the total Outstanding amount is exactly the difference
between the invoice grand total and the total invoice amount already paid

Mon, 09 Dec 2019 15:47:18 +0100fixes BUG-42450: Removes uneeded clause from user_tab_columns view definition
Augusto Mauch <augusto.mauch@openbravo.com> [Mon, 09 Dec 2019 15:47:18 +0100] rev 36850
fixes BUG 42450: Removes uneeded clause from user_tab_columns view definition

The 'a.*' part at the end of the select clause was not needed. All fields referenced
by the AD_TABLE_IMPORT function are already included in the select clause.

Wed, 04 Dec 2019 16:14:22 +0100related to BUG-42429: minor UI adjustments
Asier Lostalé <asier.lostale@openbravo.com> [Wed, 04 Dec 2019 16:14:22 +0100] rev 36849
related to BUG 42429: minor UI adjustments

For Discount > Order tab, Discount field:
- Do not show it in grid as it's the link to the parent
- Make it readonly

Wed, 04 Dec 2019 16:04:05 +0100fixed BUG-42429: Discount Organization can add rows to incorrect header
Asier Lostalé <asier.lostale@openbravo.com> [Wed, 04 Dec 2019 16:04:05 +0100] rev 36848
fixed BUG 42429: Discount Organization can add rows to incorrect header

If parent Discount header is inactive, when adding rows to Organization tab,
they were added to the first active Discount instead of to the proper parent.

This was caused because M_Offer_Organization.AD_Org_ID column is used to store
the organization the discount is applicable for instead of just row's organization.

AD_Org columns have an special treatment, when they are changed, a
virtual callout is executed to refresh all combos. Mandatory combos
take the first available value in case their default is not available,
which is the case if it is inactive. As M_Offer_ID column had a
TableDir reference, it was treated as a combo, if its parent was
inactive, first active record was taken in place.

A proper solution would be not to use AD_Org_ID column to store the
actual value but to use instead a new column. This change would be
much more aggressive being an API change that would require of
updating existing data. That's why, the problem has been fixed by
replaciing TableDir reference with Search without selector, in this
way FK reltionship is preserved, but only the value is used in UI
instead of creating a combo.

Tue, 26 Nov 2019 18:58:41 +0100fixes BUG-42399: toolbar reports should not use read-only pool
Carlos Aristu <carlos.aristu@openbravo.com> [Tue, 26 Nov 2019 18:58:41 +0100] rev 36847
fixes BUG 42399: toolbar reports should not use read-only pool

The reports generated with the print toolbar button which are based in
the PrintController engine, should not make use of the read-only pool.
This is because more than reports they are rendering information of the
transactional data.

This should have been fixed as part of [1], but that fix is missing the
part of the Report information retrieval.

[1] https://issues.openbravo.com/view.php?id=37933

Thu, 05 Dec 2019 15:06:14 +0100Fixes BUG-42398: When validating a new costing rule, physical inventories should
Armaignac <collazoandy4@gmail.com> [Thu, 05 Dec 2019 15:06:14 +0100] rev 36846
Fixes BUG 42398: When validating a new costing rule, physical inventories should
be created in the warehouse's organization

The warehouse organization is not taked into account when the inventory count is created
in the costing rule validation process

Now the warehouse organization is used to create the physical inventories when validating
a new costing rule

Thu, 05 Dec 2019 08:21:58 +0100fixed BUG-42477: too verbose log in export.database in Oracle
Asier Lostalé <asier.lostale@openbravo.com> [Thu, 05 Dec 2019 08:21:58 +0100] rev 36845
fixed BUG 42477: too verbose log in export.database in Oracle

Mon, 02 Dec 2019 10:14:23 +0100Fixes BUG-42421: Exception in Run Order Confirmation process
Álvaro Ferraz <alvaro.ferraz@openbravo.com> [Mon, 02 Dec 2019 10:14:23 +0100] rev 36844
Fixes BUG 42421: Exception in Run Order Confirmation process

The Run Order Confirmation process throw an exception when the Business Partner
does not belongs to the same Order organization

The check was updated to take into account the transaction organization.

Thu, 14 Nov 2019 15:47:30 +0100Fixes issue 42285: Apply new HQL Style to AccessTypeInjector and implementors
Cristian Berner <cristian.berner@openbravo.com> [Thu, 14 Nov 2019 15:47:30 +0100] rev 36843
Fixes issue 42285: Apply new HQL Style to AccessTypeInjector and implementors

Tue, 08 Oct 2019 11:48:18 +0200Fixes issue 41942: Apply new HQL Style to platform classes
Cristian Berner <cristian.berner@openbravo.com> [Tue, 08 Oct 2019 11:48:18 +0200] rev 36842
Fixes issue 41942: Apply new HQL Style to platform classes

StringBuffers and StringBuilders have been changed to String.
Some queries have been modified to use PreparedStatement, as this is not
prone to SQL Injection.
Some dynamic HQL queries have been modified to remove possible injections. Behaviour is the same as before.

Some refactoring was made in older classes.
New HQL convention has been applied to all modified classes.

Wed, 20 Nov 2019 17:29:27 +0100Fixes issue 41977: Allows subqueries in Log Clean Up Configuration hql clause
Cristian Berner <cristian.berner@openbravo.com> [Wed, 20 Nov 2019 17:29:27 +0100] rev 36841
Fixes issue 41977: Allows subqueries in Log Clean Up Configuration hql clause

A new column and field has been added to OBULOG_CONFIG and Log Clean Up Configuration respectively.
This "Entity Alias" column and field sets the alias that will be used to reference the main table in the hql where clause. By default it is empty.

Thu, 28 Nov 2019 10:27:46 +0100Related to Issue 42430. Changed validation in Trigger
David Miguelez <david.miguelez@openbravo.com> [Thu, 28 Nov 2019 10:27:46 +0100] rev 36840
Related to Issue 42430. Changed validation in Trigger

The validation in the trigger did not allow to do any change to an
already processed or posted inoutline.

The change done is to allow to modify some columns and to control
which ones can not be changed. For example, the updated column
can be modified after this change even if the inoutline is already
posted or processed.

Wed, 27 Nov 2019 22:40:08 +0100Fixes issue 42042: Adds support for materialized views
Augusto Mauch <augusto.mauch@openbravo.com> [Wed, 27 Nov 2019 22:40:08 +0100] rev 36839
Fixes issue 42042: Adds support for materialized views

Dbsourcemanager supports now the definition of materialized views.

For more information check out the wiki entry:
http://wiki.openbravo.com/wiki/Projects:Support_Materialized_Views_In_DBSourceManager

Wed, 27 Nov 2019 19:11:02 +0100[reporting] Override validateDatabase to prevent API change
Augusto Mauch <augusto.mauch@openbravo.com> [Wed, 27 Nov 2019 19:11:02 +0100] rev 36838
[reporting] Override validateDatabase to prevent API change

Tue, 19 Nov 2019 17:40:39 +0100Merged PI
Martin Taal <martin.taal@openbravo.com> [Tue, 19 Nov 2019 17:40:39 +0100] rev 36837
Merged PI

Mon, 18 Nov 2019 16:08:25 +0100[reporting] Updates dbsm: model management extension & materialized views
Augusto Mauch <augusto.mauch@openbravo.com> [Mon, 18 Nov 2019 16:08:25 +0100] rev 36836
[reporting] Updates dbsm: model management extension & materialized views

The update dbsourcemanager.jar file contains the changes of these two reporting projects:
- CreateDatabase and ExportDatabase processes are extensible to support loading/creating data from/to
a database other than the one where Openbravo is installed
- Materialized View support