View source | Discuss this page | Page history | Printable version   

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

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

 update fin_finacc_transaction 
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

Retrieved from ""

This page has been accessed 1,272 times. This page was last modified on 1 October 2014, at 08:15. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.