Fri, 12 Feb 2016 15:13:04 +0100Fixed bug 32216: Cash VAT tab with prepaid invoice
Víctor Martínez Romanos <victor.martinez@openbravo.com> [Fri, 12 Feb 2016 15:13:04 +0100] rev 28607
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.

Tue, 16 Feb 2016 10:15:42 +0100fixes issue 32231: wrong number comparison when checking field access of a role
Carlos Aristu <carlos.aristu@openbravo.com> [Tue, 16 Feb 2016 10:15:42 +0100] rev 28606
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.

Fri, 05 Feb 2016 14:06:10 +0100Fixes issue 31952: Avoid negative reservations
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Fri, 05 Feb 2016 14:06:10 +0100] rev 28605
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.

Mon, 15 Feb 2016 19:01:37 +0100Fixes issue 32040: The ExportSampledata task can be extended
Augusto Mauch <augusto.mauch@openbravo.com> [Mon, 15 Feb 2016 19:01:37 +0100] rev 28604
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.

Tue, 09 Feb 2016 18:39:18 -0500Fixes Issue 32147: Transaction Type and Payment are set read only when the
Nono Carballo <f.carballo@nectus.com> [Tue, 09 Feb 2016 18:39:18 -0500] rev 28603
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'

Mon, 15 Feb 2016 18:51:09 +0100Related to Issue 31354. Updates copyright Issue.
David Miguelez <david.miguelez@openbravo.com> [Mon, 15 Feb 2016 18:51:09 +0100] rev 28602
Related to Issue 31354. Updates copyright Issue.

Thu, 11 Feb 2016 15:59:45 +0100Fixed bug 32206: Invoice reactivation with Manual Cash VAT Settlement
Víctor Martínez Romanos <victor.martinez@openbravo.com> [Thu, 11 Feb 2016 15:59:45 +0100] rev 28601
Fixed bug 32206: Invoice reactivation with Manual Cash VAT Settlement

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

Thu, 11 Feb 2016 13:42:35 +0100Fixed bug 32100: Reactivation control of a prepaid cash vat invoice
Víctor Martínez Romanos <victor.martinez@openbravo.com> [Thu, 11 Feb 2016 13:42:35 +0100] rev 28600
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.

Fri, 12 Feb 2016 11:04:34 +0100related to issue 32110: include version in fop library name
Carlos Aristu <carlos.aristu@openbravo.com> [Fri, 12 Feb 2016 11:04:34 +0100] rev 28599
related to issue 32110: include version in fop library name

Thu, 11 Feb 2016 09:50:00 +0100Related to issue 31354: Adapt TestCosting
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Thu, 11 Feb 2016 09:50:00 +0100] rev 28598
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.