Fixes issue 23841: ScrollableResults objects are closed after being used

Fixes issue 23574: Return message of process is shown with grid grouped columns

After processing an order with a column grouped in the grid the record was not being refreshed and the return message was not being showed because there was a javascript exception.

The problem was that if the grid has grouped columns, its data property does not have the updateCacheData function. This has been fixed by only executing that part of the code if the grid.data property has the updateCacheData function.

Merge back from main

Fixes issue 23078: Updated the default value of AD_MODULE_ID columns

The ID of the default module is no longer stored in session, so now AD_MODULE_ID columns need this default value to be initialized with the default module: @SQL=SELECT MAX(AD_MODULE_ID) FROM AD_MODULE WHERE ISDEFAULT='Y'

This default value has been set to all mandatory, displayed columns that belong to non read only tabs.

Related to issue 23078: ID of the default module is no longer stored in session

When a module is set as default, its ID used to be stored in session with the @AD_MODULE_ID@ key. The problem is that when a validation uses the value of a module combo, and no option is selected in the combo, the validation will use the ID of the default module instead of the one selected in the combo (empty string in this case).

This has been solved by preventing the ID of the default module to be stored in session. Module fields can now be initialized to be initialized with the default module using its column default value.

Fixes Issue 23835. Deactivates Modify Button from Transaction
Tab in Financial Account Window.

Fixes Issue 0023824: Read only notes for read only windows.

Added a new preference Disable Notes For Read Only Tabs. When the preference is set to 'Y', notes section is not editable in read only windows.

Fixes issue 23758: Amount and price columns are properly rounded

When a numeric field loses the focus its value is going to be rounded using the number of decimal digits specified in its type instance. Then in the saveEditedValues of ob-view-grid, th
e new values are going to be recomputed to make sure the updated values are being retrieved.

fixed bug 23831: mobile sessions are killed when user limit is reached in erp

Fixes Issue 0023658: Problem Switching Views from a Saved View

Problem Switching Views from a Saved View that has a Grouping on a TimeStamp Field (Does not UnGroup)
Removed grouping before applying personalized view definition. The saved view has grouping information, which will be applied when applying the view.

Related to issue 19974 : Backed out changeset be142dce89dd

Fixes Issue 23074: In ExpenseSheet wrong organization and currency is used

Fixes issue 22859: Price list report title and valid from text are wrong.
Pdf version.

Fixes Issue 19974 : Selectors not updated when organization is changed

Related to bug 23801: Deprecates setLookForTranslatedIDs so API is not broken

Fixes issue 23801:Inserting several entities in one web service call works

It was not possible to insert in a same web service call an entity and one child. To support this, the classes DalWebService and EntityResolver have been modified. The approach using the lookForTranslatedIDs [1] has been reverted. Now, the EntityResolver.resolve method first tries to resolve the entity as it used to do it before the regression was introduced, and if it does not find the entity then it tries to fetch it using an OBCriteria without applying the organization filter, so that this issue [2] is not reproduced.

A new function has been created to search for the entity. It accepts a boolean that will be used to specify if the organization filter should be applied. The old doSearch method calls the new method passing true to this flag, so it keeps working as usual.

[1] https://code.openbravo.com/erp/devel/pi/rev/8525372a1fce7047ee3baead23e1ddfc208b6dd9
[2] https://issues.openbravo.com/view.php?id=21716

Related to issue 23801: Restore previous resolving mode after DALWebService

The original resolving mode of the EntityResolver is ResolvingMode.ALLOW_NOT_EXIST. The DalWebService changes it to ResolvingMode.MUST_EXIST if the change action is ChangeAction.UPDATE, but it never reverts it to its previous mode.

Fixes issue 23805: Fixes db consistency test

Fixes issue 22859: Price list report title and valid from text are wrong.

fixed bug 23767: weekly scheduled processes executed on misfire

Fixes issue 23807: Prevents NPE if request.getHeader("User-Agent") is null

Fixes issue 23805: Fixed wrong merge

The automated tests were failing because an entry in OBUISEL_SELECTOR.xml was duplicated due to a wrong merge.

Fixed bug 23032 combo of warehouse should only show the warehouse on hand

[DS Based Tables] Merge with pi

[DS Based Tables] Fixed AD_TABLE_TRG trigger to support Oracle

[DS Based Tables] Fixes database inconsistency

[DS Based Tables] Merge with pi

[DS Based Tables] Updates the Copyright date of files modified in this project

[DS Based Tables] Updated trigger to use name column as table name

[DS Based Tables] Support for SQL filter clause and SQL order by clause