Temp Projects

Rijas P wrote:

Dear Ijas,

We need to void this charge invoice but showing the payment reconciled.

Rijas P Try now

euro=# select c_payment_id,documentno,c_order_id,c_invoice_id,payamt,docstatus,isreconciled from c_payment where c_invoice_id=1074544;
c_payment_id | documentno | c_order_id | c_invoice_id | payamt | docstatus | isreconciled
--------------+------------+------------+--------------+------------+-----------+--------------
1081202 | 3034580 | 1080812 | 1074544 | 240884.400 | CO | Y
(1 row)

euro=# select c_invoice_id,documentno,grandtotal from c_invoice where documentno ='1020418';
c_invoice_id | documentno | grandtotal
--------------+------------+------------
1074544 | 1020418 | 240884.400
(1 row)

euro=# update c_payment set c_order_id=NULL,c_invoice_id=NULL where c_payment_id=1081202;
UPDATE 1
euro=# select c_payment_id,documentno,c_order_id,c_invoice_id,payamt,docstatus,isreconciled from c_payment where c_payment_id=1081202;
c_payment_id | documentno | c_order_id | c_invoice_id | payamt | docstatus | isreconciled
--------------+------------+------------+--------------+------------+-----------+--------------
1081202 | 3034580 | | | 240884.400 | CO | Y
(1 row)

euro=#

Found fixed