Fixes issue 22689: Dropdown with more than 1000 fire a warning in the log.

CI: merge back from main

CI: update AD_MODULE to version 19854

fixes issue 22914: Wrong calculation of Planned Order Date in
Manufacturing Plan process

Fixes issue 22596: When you try to create a product with attribute value,
first you have to save the register with attribute.

Related to issue 19728: Do more JS code formatting

Related to issue 23159: apply feedback

Fixes Issue 22757: In sales order report the dateordered field is not truncated

backout of issue 22862: It is not possible to do a return
to vendor when the client is configured allowing negative stock

Related to Issue 23179. Fixes DBCons.

Fixes bug 22655, fixes bug 22851. Display logic works correct with one record.

When a record is clicked, it is selected and a call to the FIC is done in SETSESSION mode. This call returns with the form session variables. The problem is th
at when there is only one row in the grid, it is automatically selected and no call to the FIC is done in SETSESSION mode.

This was happening in this issue, so the button whose display logic used session variables was not working properly. Only when the grid was refreshed the call
to the FIC is SETSESSION mode was done.

This has been fixed by making a call to updateButtonState(false, false, true) when data is received from the dataset being returned only one row. This call wil
l result in a call to the fic in SETSESSION mode. The first argument ensures that the SETSESSION call is made, the second one is not used and the third one ens
ures that the call is made even if the view is being updated is not the active one.

Fixes issue 22792: Canvas field disappears after editing the record in grid view
Recompute the canvas components after hiding the row

Fixed bug 22888 Distributed amount properly in AddOrderOrInvoice

Fixes Issue 23179. Adds Expected Date filter and field.

Related to issue 23008: fix 'Column AS alias' to work in pgsql 8.3

CI: merge back from main

CI: update AD_MODULE to version 19840

Fixes issue 23207, related to issue 23157. Backouts fix of 23157

The fix of 23157 [1] is causing 23207 and making the automated tests fail. That fix is backed out so that the automated tests get fixed.

[1] https://code.openbravo.com/erp/devel/pi/rev/970beef83a50e1ee9e3d8372acf5f23fcb6d84de

Related to issue 23159: fixes int-dbcons-oracle - Build #3731

Fixes issue 23203: Filter works with DateTime fields

With the fix of https://issues.openbravo.com/view.php?id=22885, when a Date or DateTime column is filtered, plain Dates are send as criteria. This is done to prevent Date from being converted to its UTC format. The AdvancedQueryBuilder was not prepared for this change, and was expecting a full Date and Time value for DateTime columns. Now it first try to parse the value as a DateTime and if it's not possible it tries to parse the value as a Date.

Related to issue 23159. Fixes issue 22807. A_asset_post

Fixes issue 23159: Replace A_Asset_Post stored procedure by a Java process

Fixes Issue 0023206. When calling the Convert Currency function
it sends the client and organization.

Related to Issue 22797 : Code Refactoring

Modified code to retrieve getFields() before the loop.

Related to Issue 22707 : Backed out changeset

Backout changeset as it is the commit of issue 22797.

Fixes Issue 23161: Not possible to create standards for product not stockables

Fixes issue 23075: Not conversion rate defined message in Costing
Background Process is not correct.

Related to Issue 22707 : Code Refactoring

Related to issue 23008: add ad_elements

fixed bug 23008: Bom non-stocked is not working correctly