TAAS

Solutions:-

1) GUI Changes
-Currency - Not need base2 item and Add all currency
-Status - Tick only ISSUED and SOLD
2) SQL
SELECT spd.pk_supp_doc_no_id,
        spd.sin_supp_doc_category,
        spd.vhr_supp_doc_no,
        spd.sin_sys_current_status,
        spd.dat_issue,
        COALESCE(spd.vhr_pax_name, pxp.vhr_pax_name, '') AS vhr_pax_name,
        spd.sin_no_of_pax,
        tkg.vhr_deal_no,
        tkt.sin_record_type, --*2
        tkt.vhr_sector,
        tkt.vhr_class_chr,
        tkt.sin_class,
        tkt.txt_remarks,
        sfr.vhr_currency,
        sfr.dbl_fare,
        sfr.dbl_tax,
        sfr.dbl_commission,
        sfr.dbl_actual_cost,
        sfr.dbl_supplier_amount,
        sfr.dbl_customer_price,
        sfr.dbl_normal_profit
        --....
    FROM airticket.tbl_ticket tkt
        LEFT JOIN service.tbl_supp_doc_no spd
            ON tkt.fk_supp_doc_no_id = spd.pk_supp_doc_no_id
        LEFT JOIN airticket.tbl_ticket_gen_data tkg 
            ON spd.pk_supp_doc_no_id = tkg.fk_supp_doc_no_id
        LEFT JOIN service.tbl_supp_doc_fare sfr
            ON tkt.fk_ticket_cus_ledg_fare_id = sfr.pk_supp_doc_fare_id --*1
        LEFT JOIN pax.tbl_pax_profile pxp
            ON spd.fk_pax_profile_id = pxp.pk_pax_profile_id
        --LEFT JOIN airticket.tbl_airline_master air 
            --ON air.pk_airline_master_id = tkg.fk_airline_master_id  
    WHERE tkt.int_sys_action_id != -1
        --AND spd.sin_sys_current_status IN (1,2)
        --AND spd.dat_issue BETWEEN '2023-08-08' AND '2023-08-08'
        --...

unnikannan S wrote in #note-8:

ISSUE FOUNDED

1.FREEZE FILTERS WHILE LOADING DATA
2.BOOKING STAFF ISSUING STAFF WISE FILTER NOT WORKING
3.ERROR WHILE CLEAR DATE AND SEARCH
4.ERROR WHILE ADD DEAL CODE AND SEARCH
5.CHANGE PRINT HEADING TO (DEAL REPORT LIST)
6.CORRECT GRID,PRINT LABEL AIR TO AIRLINE
7.ISSUE IN CHANGING STATUS WISE SEARCH
8.ERASE & SEARCH (SECTOR/CLASS ) TOOL BAR NOT WORKING
9.REMOVE EDIT OPTION FROM PRINT
10.MISSING STATUS WHILE CHOOSING NEW
11.ADD SPACE BETWEEN HEADING IN PAGE
12.CORRECT THE ISSUE DATE FORMAT TO DD/MM/YYYY

Reported issues 1,3,5,6,11 solved.

ISSUE FOUNDED

1.DUPLICATION OF VOUCHERS IN LIST
2.SHOW CANCEL/REFUNDABLE AMOUNT AS NEGATIVE IN LIST
3.SHOW BOOKING STAFF/ISSUING STAFF WISE FILTER SEARCH
4.NO DATA WHILE SEARCH WITH DEAL NO

GUI CHANGE
---------------
1. Add grouping in Grid. Deal code wise group

TESTING DONE