Temp Projects

Rijas P wrote:

Please see we tried to edit the below PO, but getting an error page. Please check and resolve.

PO NO: HP220240

Vendor: Happy Inn household

There is a prepayment against this order which is already in reconciled status
Document No: 3030021
So while editing the PO the system will try to void the related payment also, and it fails due to the payment is in reconciled state

Mohamed Suhail wrote:

Rijas P wrote:

Please see we tried to edit the below PO, but getting an error page. Please check and resolve.

PO NO: HP220240

Vendor: Happy Inn household

There is a prepayment against this order which is already in reconciled status
Document No: 3030021
So while editing the PO the system will try to void the related payment also, and it fails due to the payment is in reconciled state

Removed orderID from 5 payments

c_payment_id 
--------------
      1064192
      1064361
      1064966
      1064501
      1065027

euro=# update c_payment set posted='N',isprepayment='N',c_order_id=NULL where c_payment_id in (select c_payment_id from c_payment where isprepayment ='Y' and c_order_id is not null and isreceipt='N' and c_payment_id not in (1065473));
UPDATE 5

Please try PO edit now

Found fixed