fixes issue 31960: Incorrect posting data using postgresql jdbc connection pool


There was a problem in the binary transfer of Dates performed by the postgresql library version 9.4-1201. This problem is not happening on version 9.4-1207 because when the queries are executed it now includes a mechanism to identify if the fields of the query need to update their format to binary.

For this reason, to fix the problem the postgresql jdbc driver has been upgraded to version 9.4-1207

fixes issue 31946: Labels linked to a concrete file are not translated

The translation engine requires the base design path to retrieve the ad_textinterfaces linked to a particular report. This path was not being sent properly in ReportinUtils class. Now the path is generated correctly making use of a new method called getBaseDesignPath.

related to issue 31884: code review improvement

Fixes Issue 31896:Cannot save a G/L Journal header with the date of the
adjustment period if both periods are opened

c_chk_open_period returns value more than 1 in case standard period and
adjustment period is open in which the date of GL journal is included.
<> 1 check is failed in this case so check is changed to < 1 to show
error message in case period id not available

fixes issue 31889: some reports are not exported using JDK 8

The library which contains the JDT compiler from the Eclipse Foundation has been upgraded to version 4.4.2. This compiler is used to compile jrxml -> jasper.

Using JDK 8 with the previous library version caused an error when exporting some reports. With this upgrade reports are exported correctly using JDK 8.

fixes issue 31884: can not move tree nodes in classic mode

When moving tree nodes using the classic mode there is a point where the process tries to recover the tree type. This information is stored in the ADTable entity which can not be accessed by non system roles. To prevent this error now the part where the tree type is recovered is executed using the DAL admin mode.

Related to issue 31875: Updated copyright year

Fixes Issue 31875. Removes unnecessary code that makes the process fail with a NPE
if the global variable has not been initized yet.

Related to issue 31848: code review improvements

The old messages have been reverted because it could be used by external modules, so it could be considered as a functional API Change.
Create a new message instead and improve it to be more descriptive.

Modified pl/sql comment to reflect the new behavior and to avoid confusions in the future

Fixes issue 31848: Not possible to change product to stocked

Stocked flag in Product window will not be updatable in case product is present in any order, invoice or warehouse document.

Fixes issue 31813: Cannot void GoodsShipment if it has reservation associated

Generate uuid inside the loop to avoid create more than one M_Reservation with the same M_Reservation_ID in M_INOUT_POST.
Format code properly ("Add a reservation stock with the ordered quantity" section) in M_INOUT_POST.
Remove duplicated variable v_reservedqty in M_RESERVATION_POST to avoid set wrong Reservation Status to Order Line.
Take into account only Order Lines with qtyordered > 0 and with product of stocked and item type when setting Reservation Status to Order in M_RESERVATION_POST.
Set "Completely Reserved" reservation status to Order Line also when reservedqty > quantity in M_RESERVATION_POST and M_RESERVATION_TRG.

Merge temporary head for 3.0PR15Q4.4

Added signature for changeset f016ea545c92

Added tag 3.0PR15Q4.4 for changeset 70df4e4c5cab

Update AD_MODULE version to 3.0PR15Q4.4

Fixed issue 32333. Added method to check if importentry has status 'Error'

Fixes Issue 32328:"Generate invoice from receipt" button is not working

In case tax not included in price list, gross std price and list price
was set will null value which is not allowed by db table. now they are
initiated to value zero first.

fixed bug 32310: error on update if an observer loaded current object in memory

In case an entity observer loaded current object in memory (ie. observing orderLine)
doing orderLine.getSalesOrder().getOrderLineList() there were two different instances
in memory representing the same DB row. This caused problems when trying to evict it.
Causing an exception to be thrown when updating from UI in this case.

As solution eviction is no longer performed, object is forced to be fetched from DB by
executing a Criteria.

Fixes Issue 32299: Wrong payment status when unmatching bankstatement line
manually matched against an invoice

Incase a finTransaction is unmatched which has finPayment,status of finPayment
is also updated accordingly as per isReceipt flag

Related to issue 32220: fixed db consistency

Fixes Issue 32220: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

Merge temporary head for 3.0PR15Q4.3

Added signature for changeset 24d2967df096

Added tag 3.0PR15Q4.3 for changeset 9985680adffa

Update AD_MODULE version to 3.0PR15Q4.3

Fixes Issue 0032185: Not possible to sort by unit price in Return from
Customer p&e

In case of the Return From Customer for a numeric value of unit Price COALESCE
was being use with '' which should have been 0 instead, COALESCE for order no
was missing for RTC, additonal ReturnReasonLeftClause2 added to replace
EntityAlias.name in the transformeredHQL Query.

Fixes issue 31916 & Fixes issue 31908 & Fixes issue 31958: Cannot void shipment

Cannot void shipment related to reservation.
New reservation to replace the closed related one when voiding a shipment will be done after update m_storage_detail, in order to have voided shipment quantity available.
Reservation stock lines will be created with related shipment line movement quantity in case this quantity is less than pending order quantity.
Reservation will be created with the least quantity between ordered quantity and movement quantity.

Fixes issue 32086: Process Price Difference adjustment breaks menu

Were fixed the 3 problems of "Process Price Difference adjustment" menu entry found:

1. It is included into menu folder Warehouse Management | Setup
2. Was renamed to "Process Price Difference Adjustment" to follow the capitalization rule
3. Was included a description and help.

Fixes issue 32004: Costing Migration Process does not set isprocessed flag

Set transaction isprocessed flag as true in updateTrxLegacyCosts, updateWithZeroCostRemainingTrx and calculateCosts methods in CostingMigrationProcess class.
Set also transaction isprocessed flag as true in initializeOldTrx and updateInventoriesCostAndProcessInitInventories methods in CostingRuleProcess class.

Related to Issue 31998. Changed License year.