Feature #243
open
Airline Sales and Refund Report
Added by Anil KV over 1 year ago.
Updated 4 months ago.
Status:
Reopen Bugs Testing Done
Module:
Airline Sales and Refund
Description
Coding Airline Sales and Refund
- Assignee changed from travvise Admin to Amal Pious
- Status changed from New to Coding Started
- Start date changed from 07/09/2023 to 08/08/2023
- % Done changed from 0 to 40
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
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
- 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
- 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
- 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
- Assignee changed from Amal Pious to Athul P
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
- 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
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
- 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
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
------------------
Items from against sale is also getting added
- Status changed from Reopen Bugs to New Changes
- Subject changed from Airline Sales and Refund to Airline Sales and Refund Report
- Assignee changed from Athul P to Nithin PM
- Status changed from New Changes to Reopen Bugs
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
---------------------------------------------
1. No data showing on summary tab upon grouping them customer wise
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90
Also available in: Atom
PDF