Update Transaction Refactor
If upgrading your instance to 3.0PR14Q4 you have obtained the following error:
You cannot update your instance, because a pre-validation fails.
It is not allowed to upgrade to this version having transactions with null Transaction Date and/or null Accounting Date.
To fix this problem in your instance, have a look to generated alerts (Transactions with Missing Data) and identify the affected transactions.
If you have a transaction like that, fix the problem filling Transaction Date and/or Accounting Date.
It can be very helpful to visit http://wiki.openbravo.com/wiki/Update_Transaction_Refactor
This means that you have transactions with Payment Amount and Deposit Amount of ZERO and/or null Transaction Date and/or null Accounting Date, you should fix it to update to 3.0PR14Q4 and these querys can be very helpful.
update fin_finacc_transaction set dateacct=statementdate where dateacct IS NULL
set statementdate=payment.paymentdate, dateacct=payment.paymentdate
from (select fp.paymentdate from fin_payment fp where fin_payment_id=fp.fin_payment_id) as payment
where statementdate is null and dateacct is null and fin_payment_id is not null