SELECT Round(IFNULL(SUM(receivedamt),0)) PaidAmount FROM invoicemaster_onaccount io WHERE io.Panel_ID=1362 and io.iscancel=0 AND io.Type='ON ACCOUNT' ;