Feature #243
openAirline Sales and Refund Report
Start date:
08/08/2023
Due date:
% Done:
90%
Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Airline Sales and Refund
Tested By:
unnikannan S
Code Reviewed By:
Subtasks
Related issues
Updated by Junaid M over 1 year ago
- Assignee changed from travvise Admin to Amal Pious
Updated by Amal Pious over 1 year ago
- Status changed from New to Coding Started
- Start date changed from 07/09/2023 to 08/08/2023
- % Done changed from 0 to 40
Updated by Anil KV over 1 year ago
Solutions
*GUI CHanges -Add Mege Checkbox like #234->Supplier Sale & Refund Report -List Changes like #234->Supplier Sale & Refund Report -Issue Date to Issue/Cancel Date* SELECT ... dbl_fare dbl_fare_paid_agency_cc, dbl_fare_paid_cust_cc, dbl_fare_paid_pax_cc 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 WHERE tkt.int_sys_action_id != -1 --AND (spd.sin_sys_sale_side_status = IN (1,2) OR spd.sin_sys_refund_side_status IN (1,3)) --AND spd.dat_issue BETWEEN '2023-08-08' AND '2023-08-08' --AND (spd.vhr_pax_name ILIKE '*' OR pxp.vhr_pax_name ILIKE '*') ... * Consider sin_record_type * Fare Cash = dbl_fare_paid_agency_cc+ dbl_fare_paid_pax_cc+dbl_fare_paid_pax_cc * Fare Credit = dbl_fare - Fare Cash dbl_fare
Updated by Amal Pious over 1 year ago
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
Updated by unnikannan S over 1 year ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to unnikannan S
ISSUE FOUNDED
1.NO CHANGE IN AMOUNT FIELD WHILE SEARCH WITH BASE 1 QAR IF AN OTHER CURRENCY IN LISTS
2.SHOW REFUND DATA WISE CONSIDER
3.SHOW MANDATORY FIELD AIRLINE IN PRINT
Updated by Amal Pious over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
1.NO CHANGE IN AMOUNT FIELD WHILE SEARCH WITH BASE 1 QAR IF AN OTHER CURRENCY IN LISTS - Fixed
2.SHOW REFUND DATA WISE CONSIDER - Fixed
3.SHOW MANDATORY FIELD AIRLINE IN PRINT - Fixed
Updated by unnikannan S over 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUNDED
1.REMOVE ALL SELECT WHILE CHOOSING ONE ITEM IN DETAILS
Updated by Athul P about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUNDED
1.CORRECT THE WORK FLOW OF CONSIDER OPTIONS
2.NO DATA FROM VOID FROM CANCEL GUI
Updated by Athul P about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUNDED
1.SHOW DATA ON THE BASIS OF SUPPLIER SIDE CURRENCY
Updated by Athul P about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
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