TAAS

Input Changes
1) Status Multi Select - Default ON HOLD
2) Customer - Code and Name entry option
3) Currency - like Ledger Statement
4) Add Cheque Date(2 Date picker - like priod), Default blank

- Column Width Re-set

SELECT doc1.pk_documents_id,
    doc1.dat_document,
    doc1.vhr_document_no,
    rc.vhr_cheque_no,
    rc.dat_cheque,
    rc.vhr_issued_bank,
    rc.vhr_name_on_cheque,
    rc.vhr_ledg_currency,
    rc.dbl_ledg_cur_amount,
    rc.vhr_base_currency,
    rc.dbl_base_cur_amount,
    rc.chr_current_cheque_status,
    rc.vhr_id_number,
    tmp.int_record_no,
    tmp.fk_cheque_ac_id,
    tmp.fk_cheque_posting_ac_id,
    tmp.chr_cheque_status,
    tmp.dat_document,
    tmp.fk_received_cheque_id,
    tmp.fk_cr_customer_id
FROM (SELECT row_number() OVER (PARTITION BY rcd.fk_received_cheque_id
    ORDER BY rcd.pk_rec_cheque_details_id DESC) as int_record_no,
        fk_cheque_ac_id,
        fk_cheque_posting_ac_id,
        rcd.chr_cheque_status,
        doc.dat_document,
        rcd.fk_received_cheque_id,
        rcd.fk_cr_customer_id
    FROM receivedcheque.tbl_rec_cheque_details rcd
        LEFT JOIN document.tbl_documents doc 
            ON rcd.fk_documents_id = doc.pk_documents_id
        LEFT JOIN accounts.tbl_account ac1 
            ON rcd.fk_cheque_posting_ac_id = ac1.pk_account_id
        LEFT JOIN accounts.tbl_account ac2 
            ON rcd.fk_cheque_ac_id = ac2.pk_account_id
                AND doc.int_sys_action_id != -1 
    WHERE doc.dat_document <= *<<As On Date>>) AS tmp

    LEFT JOIN receivedcheque.tbl_received_cheque rc 
        ON  tmp.fk_received_cheque_id = rc.pk_received_cheque_id AND tmp.int_record_no =1
    LEFT JOIN document.tbl_documents doc1 
        ON doc1.pk_documents_id = rc.fk_received_doc_id AND doc1.int_sys_action_id != -1
WHERE tmp.int_record_no = 1 
    AND *<All filter except <As On Date>>

ISSUE FOUNDED

1.REMOVE LIST FROM GRID

TESTING DONE

TESTING DONE