Temp Projects

Rijas P wrote:

Reminder...

Corrected

euro=# select cp.c_payment_id,cp2.c_payment_id,cp.docstatus,cp2.docstatus,cp.c_bpartner_id,cp.isprepayment,cp2.isprepayment,cp.payamt,cp2.payamt from c_payment cp join c_payment cp2 on cp.reversal_id=cp2.c_payment_id where cp.isprepayment <> cp2.isprepayment and cp.payamt <>0 and cp.c_payment_id < cp2.c_payment_id;
c_payment_id | c_payment_id | docstatus | docstatus | c_bpartner_id | isprepayment | isprepayment | payamt | payamt
--------------+--------------+-----------+-----------+---------------+--------------+--------------+--------+--------
1064517 | 1065888 | VO | RE | 1011596 | N | Y | 28114 | -28114
(1 row)

euro=# update c_payment set isprepayment ='N' where c_payment_id=1065888;
UPDATE 1

and reposted both payment and its allocation

Isprepayment was yes in the reversed payment where as in the original payment its value is no

Found fixed.