Fixes Issue 32218:Payment In & Out Window Lines Tab Order Payment Plan Field
navigation fails

Direct Navigation Rule applied to
- Window:Payment In, Tab:Lines, Field:Order Payment Plan navigate to
Sales Order | Payment Plan Tab
- Window:Payment Out, Tab:Lines, Field:Order Payment Plan navigate to
Purchase Order | Payment Plan Tab

fixes issue 32227: Mark MS Edge as supported browser

fixes issue 32292: access error in Field tab with specific role when saving

The problem is caused because the Field tab has a field for the Creation audit column. This field should be removed as audit columns should not have a field in the AD. They are generated automatically.

related to issue 32231: check if values are null

Fixes issue 32023 & Fixes issue 32190: Improve PriceDifference performance

Some improvements have been done in CostingUtils.getCurrentValuedStock, CostAdjustmentUtils.getValuedStockOnMovementDateByAttrAndLocator, CostAdjustmentUtils.getValuedStockOnTransactionDate and CostingMigrationProcess.getCurrentValuedStock methods:
- Use TransactionCost.PROPERTY_ACCOUNTINGDATE field instead of coalesce(ShipmentInOut.PROPERTY_ACCOUNTINGDATE, MaterialTransaction.PROPERTY_MOVEMENTDATE) to avoid join with ShipmentInOutLine and ShipmentInOut tables.
- Use a scroll instead of looping through a list.
- Loop can not be avoid due to the need of calculate conversion rate recursively.
- Clear every 100 loops will not be done as DAL objects will not be loaded in memory and to avoid session cleared errors.
Retrieve only one or two results in some queries where more results were not needed.
Use isEmpty() instead of size().
Retrieve only lineno field instead of full object in CostAdjustmentUtils.getNewLineNo method.
Improve CostAdjustmentUtils.getTrxCost method.
Do a clear every 100 loops in PriceDifferenceProcess.processPriceDifference method to improve performance.

Related to Issue 32060: Updated year in copyright.

Fixes issue 32060: Wrong Goods Receipt button status under some circumstances

Column process_goods_java inside M_INOUT table was updated correctly inside the process of a Pending Goods Receipts.
The button show the expected text.

fixes issue 32287: Selection can be lost in P&E grids under some circumstances

If we refresh the grid, after selecting a record in a page different from the first one, Smartclient internally prepares the request to retrieve the records surrounding the selected one, in order to try to keep the position of the scroll.

This behavior in P&E can cause the losing of the selected records, because they are always loaded on the first page. In order to prevent this, we detect this situation in P&E grids before performing the request, and in that case we adapt it to force the retrieval of the first page which contains all the selected records.

fixes issue 32193: Fix selection in P&E grids having filter on change disabled

Having filter on change disabled, the filtering is not performed until enter is pressed or the focus is moved out of the text filter. In this second case, there could be problems if the focus is lost when checking a pick and edit grid record: the filtering request is performed and at the same time the actions related to the record selection are fired. This can cause the selection actions not work as expected.

This problem also affects to numeric and date filters, because they always perform the filtering after losing the focus.

To avoid this problem a new mechanism has been included for pick and edit grids, the blur method for the filter elements is overridden to prevent the selection immediately after losing the focus.

related to issue 32275: fixes typo

fixed issue 32275: jUnit: add capability to assert on logs

TestLogAppender can be used in test cases extending OBBaseTest to perform
assertions on what is logged.

Removing File BLOB reference from core

Fixes Issue 31349:Mongolian language added in reference data.

fixed issue 32261: implement a typed version of OBDal.getProxy

New getProxy method returns a typed instance of the desired entity, making
unnecessary to cast it.

fixed bug 32244: ORA error in log when setting an AD column to not null

Prevented trying to disable not-null constraints in case the column was already
set as nullable in DB.

Merging Backed out changeset 8d06deadd164

Backed out changeset 8d06deadd164

Fixes Issue 32136:Wrong warehouse combo validation in the 'Create Purchase
Orders popup in the Purchasing Plan window

Fixes Issue 32134:Price Including taxes is not supported by the Purchasing
Plan (Create Purchase Orders process)

Removing File BLOB reference from core

Fixed bug 32216: Cash VAT tab with prepaid invoice

The C_INVOICETAX_CASHVAT_V view, which populates the Sales/Purchase Invoice | Cash VAT tab, has been rewritten to properly manage the scenarios of prepaid invoices where the invoice amount is lower than the original order, either because of a partial invoice or because of a cheaper invoice.

The view has been split in 2 queries merged with an union all to improve the performance:
1. The first one searches the Cash VAT records linked to a payment. In this part we only filter by the records linked to the invoice's FPS, which fixes the scenarios raised by the issue.
2. The second one searches the Cash VAT records linked to a manual cash vat settlement. In this part there is no need to join with the payment tables, so the global performance is better.

fixes issue 32231: wrong number comparison when checking field access of a role

When checking the access of a numeric field, if it is an integer, the client sends the value without decimal places. This value is compared with the current value stored in the database which already stores the value with decimals. So, the comparison of the string values determines that they are different as for example we are comparing '100' with '100.00'.

To solve the problem, for this type of fields now the numeric value is compared instead of using its string representation.

Fixes issue 31952: Avoid negative reservations

Set quantity to zero in case quantity + p_qty is less than zero when updating current m_reservation_stock in M_RESERVE_STOCK_MANUAL, to avoid create negative reservations.

Fixes issue 32040: The ExportSampledata task can be extended

The task can now be extended by:
- Defining the dataset to be exported
- Defining how to manage the where clause of the dataset tables
- Defining the DatabaseDataIO implementation to use to export a table to XML
- Defining the folder where the data should be exported to

It is also supported to define a table several times in the same dataset, and each of the dataset tables will be exported to their own xml file.

Fixes Issue 32147: Transaction Type and Payment are set read only when the
transaction is processed.

In Transaction tab of Financial Account window, once the transaction is processed
the fields Transaction Type and Payment are set read only.
The Read Only logic of those fields was set to @Processed@='Y'

Related to Issue 31354. Updates copyright Issue.

Fixed bug 32206: Invoice reactivation with Manual Cash VAT Settlement

Avoid to reactivate an invoice linked to a Manual Cash VAT Settlement

Fixed bug 32100: Reactivation control of a prepaid cash vat invoice

When an invoice is linked to a payment, the system currently avoids to reactivate it. You first need to reactivate the payment, so the cash vat information is deleted, and then you can reactivate the invoice.
However for prepaid invoices, the system does allow to reactivate the invoice, but the cash vat information is wrongly kept.

Now we delete all the cash vat info records linked to a prepayment for this invoice at invoice reactivation time. When the invoice is latter on processed, the cash vat records will be calculated again.

related to issue 32110: include version in fop library name

Related to issue 31354: Adapt TestCosting

Fix foreign currency debit, foreign currency credit and currency checks for ReceiptInvoiceMatch document in assertDocumentPost method in testCostingMC444 and testCostingMC445 tests.