Temp Projects

Please see some -ve payments showing in payment history. Kindly request you to clear all this payments. PFA excel

Also some -ve payments with decimal values not showing as over payments in payment history but showing as over payment in vendor settlement Eg: Payment No : 3000874 [Vendor : Liling Pengxing Ceramic Factory]. Please clear all these type -ve payments as well.

Rijas P wrote:

Please see some -ve payments showing in payment history. Kindly request you to clear all this payments. PFA excel

Also some -ve payments with decimal values not showing as over payments in payment history but showing as over payment in vendor settlement Eg: Payment No : 3000874 [Vendor : Liling Pengxing Ceramic Factory]. Please clear all these type -ve payments as well.

Cleared customer receipts with -ve available amount

euro=# update c_payment cp set discountamt=cp.discountamt-aa.dav from (select cp.created,c_payment_id,documentno,payamt,paymentavailable(c_payment_id),discountamt,discountavailable(c_payment_id) dav,cp.c_currency_id,isreceipt,docstatus,cb.name from c_payment cp join c_bpartner cb on cp.c_bpartner_id=cb.c_bpartner_id where discountavailable(c_payment_id) <> discountamt and discountavailable(c_payment_id) < 0 and cp.docstatus in ('CO','CL') and isreceipt='Y' and cp.ad_client_id=1000000) as aa where aa.c_payment_id=cp.c_payment_id and discountavailable(cp.c_payment_id) < 0 and cp.isreceipt='Y';
UPDATE 8

Closed...