Project

General

Profile

Edit Copy Actions

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
Priority:
Normal
Assignee:
Target version:
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:

Description

Coding Airline Sales and Refund


Add

Subtasks


Add

Related issues

Actions #1

Updated by Junaid M over 1 year ago

  • Assignee changed from travvise Admin to Amal Pious
Actions #2

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

Actions #4

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

Actions #8

Updated by Anil KV over 1 year ago

  • Assignee changed from Amal Pious to Athul P
Actions #9

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

Actions #11

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

TESTING DONE

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

Actions #14

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 Arathy PS 6 months ago

  • 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

Actions #16

Updated by Athul P 6 months ago

  • Status changed from Reopen Bugs to New Changes
Actions #17

Updated by Anonymous 6 months ago

  • Subject changed from Airline Sales and Refund to Airline Sales and Refund Report
  • Assignee changed from Athul P to Nithin PM
Actions #18

Updated by Anil KV 5 months ago

  • Status changed from New Changes to Reopen Bugs
Actions #19

Updated by Nithin PM 5 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

Updated by Arathy PS 5 months ago

  • 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

Actions #21

Updated by Nithin PM 4 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions #22

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
Edit Copy Actions

Also available in: Atom PDF