{"status":"success","message":"No records found","test":"SELECT tprt.debit_note_receipt,tprt.transaction_date,tpp.party_name, tprt.bill_no,tprt.bill_date, SUM(tprt.return_net_amt) AS final_bill_amt,\n                SUM(tprt.adjust_amount) AS final_adjust_amt,SUM(tprt.tcs_amt) AS final_tcs_amt,SUM(tprt.discount_on_total) AS final_disc,tprt.insert_datetime AS checkflag\n                FROM tbl_purchase_return_transaction tprt INNER JOIN tbl_purchase_party tpp  ON tprt.party_id = tpp.purchase_party_id\n                WHERE tprt.distributor_id = '' AND tprt.party_id = '' AND tprt.debit_note = 'Yes' AND tprt.debit_note_status = 'Pending' GROUP BY tprt.debit_note_receipt, tprt.unique_bill"}