Project

General

Profile

Edit Copy Actions

Feature #223

open

Refund/Void Report

Added by Anil KV over 1 year ago. Updated 8 days ago.

Status:
Reopen Bugs Testing Done
Priority:
Normal
Assignee:
Target version:
Start date:
07/09/2023
Due date:
% Done:

90%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Void Report
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Void Report


Files


Add

Subtasks


Add

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

Actions #3

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
Actions #4

Updated by Shanto Shaji over 1 year ago

  • Status changed from Open to Coding Started
  • % Done changed from 10 to 40
Actions #5

Updated by Junaid M over 1 year ago

  • Assignee changed from Shanto Shaji to Baseem Shan
Actions #6

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

Actions #8

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 unnikannan S 10 months ago

TESTING DONE

Actions #10

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

Actions #12

Updated by Baseem Shan 4 months ago

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

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.

Actions #15

Updated by Baseem Shan 3 months ago

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

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
Actions #17

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:

Actions #19

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

Actions #21

Updated by Nawal Sidique about 1 month ago

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

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

Actions #24

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 14 days ago

Issue Found
-----------
1)blank page in print - FIXED

Actions #26

Updated by Nawal Sidique 13 days ago

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

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

Also available in: Atom PDF