related to bug 32605: removed some duplication

hql where clause was converted to lower case several times

Related to Issue 32341: Prevents infinite loop if organization is null

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.

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.

Related to issue 32536: Code review improvements

Avoid using orglist column also in SL_ProductPrice_PriceListVersion class.

Fixes Issue 32536: Organizations not available in BalanceSheet and PL Structure

Organization list is fetched using query instead of column orglist

Related to issue 32539: Update copyright

Fixes issue 32539: Fixed wrong calculation in acct with operands

Use #AccessibleOrgTree instead of #User_Org.

Related to bug 32584: fix a problem related to context in a test.

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.

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.

Related to bug 32584: Added test cases covering this regression

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.

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.

related to issue 32519: updated javadoc

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.

Related to issue 32281: Add coalesce to avoid null value in v_reservationqty

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

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.

Fixes issue 32440: Same currency in Simple G/L Journal header and lines

Related to issue 32392: Remove unused variables and methods

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.

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.

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.

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.

CI: merge back from main

CI: update AD_MODULE to version 28838

fixes issue 32541: invoice report can not be printed by manual roles

Now the Window object is retrieved using admin mode.

CI: merge back from main

CI: update AD_MODULE to version 28834