Feature #223
openRefund/Void Report
Added by Anil KV over 1 year ago. Updated 8 days ago.
90%
Files
clipboard-202502131151-nwsok.png (60.7 KB) clipboard-202502131151-nwsok.png | Theja Ponon, 02/13/2025 11:51 AM | ||
clipboard-202503051412-afzzj.png (97.8 KB) clipboard-202503051412-afzzj.png | Theja Ponon, 03/05/2025 02:12 PM |
Subtasks
Related issues
Updated by Anil KV over 1 year ago
- Subject changed from Void Report to Refund/Void Report
Coding Refund/Void Report
Updated by Anil KV over 1 year ago
Solutions
1) Ticket Query SELECT spd.pk_supp_doc_no_id, spd.vhr_supp_doc_no, spd.dat_cancel, spd.dat_refund, spd.fk_service_id, tkt.fk_branch_id, tkt.fk_department_id, tkt.fk_supplier_ac_id, tkt.fk_ticket_type_id, tkt.vhr_class_chr, tkt.sin_class, tkt.vhr_return_class_chr, tkt.sin_return_class, tkt.fk_sector_remarks_id, tkt.vhr_sector, tkt.sin_no_of_segments, tkt.fk_customer_ac_id, tkt.fk_actual_customer_ac_id, tkt.fk_sub_customer_id, tkt.fk_pax_profile_id, tkt.vhr_pax_name, tkt.sin_no_of_adult, tkt.sin_no_of_child, tkt.sin_no_of_infant, tkg.fk_airline_master_id, tkg.fk_refunding_counter_staff_id, spdf.vhr_currency, spdf.dbl_fare, spdf.dbl_tax, spdf.dbl_sup_fee, spdf.dbl_sup_rfd_charge, spdf.dbl_supplier_amount, spdf.dbl_customer_price, spdf.dbl_actual_profit FROM airticket.tbl_ticket tkt INNER JOIN service.tbl_supp_doc_no spd ON tkt.fk_supp_doc_no_id = spd.pk_supp_doc_no_id AND tkt.sin_record_type = 2 AND tkt.int_sys_action_id != -1 INNER JOIN airticket.tbl_ticket_gen_data tkg ON tkg.fk_supp_doc_no_id = tkg.fk_supp_doc_no_id LEFT JOIN service.tbl_supp_doc_fare spdf ON tkt.fk_ticket_sup_ledg_fare_id = spdf.pk_supp_doc_fare_id -If Need(Not in filter) Join Service, Airline, Service, Account etc... 2) Hotel - SQL 3) Transfer 4) Visa 5) Hotel 6) Other 7) Summary -Creat a dctSummary - key service, Values a model - Summary grid columns
Updated by Anil KV over 1 year ago
- Status changed from New to Open
- Assignee changed from travvise Admin to Shanto Shaji
- % Done changed from 0 to 10
Updated by Shanto Shaji over 1 year ago
- Status changed from Open to Coding Started
- % Done changed from 10 to 40
Updated by Junaid M over 1 year ago
- Assignee changed from Shanto Shaji to Baseem Shan
Updated by Baseem Shan 10 months ago
- Status changed from Coding Started to Coding Done
- % Done changed from 30 to 60
Updated by unnikannan S 10 months ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to unnikannan S
ISSUE FOUNDED
FIXED - 1.Fix Bugs On Button In Case Without Selecting Any Data And Choosing To Refund
NOT A BUG - 2.Show Data As Per Selected Filter Fields In UI
Updated by Baseem Shan 10 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon 4 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90
Updated by Theja Ponon 4 months ago
- Status changed from Reopen Bugs Testing Done to Reopen Bugs
- % Done changed from 90 to 50
ISSUE FOUND
---------------
Fixed - 1)IF THE Ticket/Voucher No FIELD IS FILLED MAKE THE DATE FIELD OPTIONAL
Fixed - 2)IF THE FROM DATE IS TODAYS DATE OR PREVIOUS DATE SET THE TO DATE AS TODAYS DATE
Updated by Baseem Shan 4 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon 4 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90
Updated by Arathy PS 4 months ago
- Status changed from Reopen Bugs Testing Done to Reopen Bugs
- % Done changed from 90 to 50
ISUUE FOUND
----------------------------------------------
FIXED -- 1. Refunded documents are not redirecting to refund module.
NEW CHANGES
-----------------------------------------
FIXED -- 1. New tab for package vouchers.
Updated by Baseem Shan 3 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon 3 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90
Updated by Arathy PS about 2 months ago
- Assignee changed from Baseem Shan to Nawal Sidique
Updated by Arathy PS about 2 months ago
- Status changed from Reopen Bugs Testing Done to Reopen Bugs
- % Done changed from 90 to 50
ISSUE FOUND
------------------
FIXED - 1.Add redirection to document and voucher no:
Updated by Nawal Sidique about 2 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon about 1 month ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
Issue found
-----------
1)On redirection document is not load n sale module
2) By using redirection through edit icon , document is not load in refund module
Updated by Nawal Sidique about 1 month ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon about 1 month ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
Updated by Theja Ponon about 1 month ago
Issue found
-------------
1)issue on package tab print - FIXED
2)Sale document is not load in sale module - FIXED
Updated by Nawal Sidique 29 days ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon 13 days ago
- File clipboard-202503051412-afzzj.png clipboard-202503051412-afzzj.png added
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
Issue Found
-----------
1)blank page in print - FIXED
Updated by Nawal Sidique 13 days ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon 8 days ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90