View source | Discuss this page | Page history | Printable version   
Main Page
Upload file
What links here
Recent changes

PDF Books
Add page
Show collection (0 pages)
Collections help


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,228 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.