Project

General

Profile

Edit Copy Actions

Feature #248

open

Ancillary Sales Reports

Added by Anil KV over 1 year ago. Updated about 2 months ago.

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

90%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Ancillary Sales Reports
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Ancillary Sales Reports


Add

Subtasks


Add

Related issues

Actions #1

Updated by Anil KV over 1 year ago

  • Assignee set to travvise Admin

Updated by Shanto Shaji over 1 year ago

Note **
Ancillary Column Dynamic Service or Ancillary Service based on Grouping Selection

Updated by Anil KV over 1 year ago

Solutions

1) GUI Change
-Status label change to Consider, Default Tick all
-Add Currency - Default Base1(***), 
-Summary:-
*Group By Default Ancillary Service
*Columns-> Ancillary Service/Service(Based on Broup by), Sale->Count, Cost, Price, Profit(Sub Columns), Refund(Count, Cost, Price, Profit(Sub Columns), Net(Count, Cost, Price, Profit(Sub Columns)
-Details
-Add No Grouping(default) item in Group By 
-Ticket/Voucher, Issue/Cancel Date, Doc No, Doc Date, Service, Ancillary Service, Cost, Price, Profit
2) SQL
SELECT 'Issue/Sale' AS str_type,
    supd.vhr_supp_doc_no,
    supd.sin_supp_doc_category,
    supd.fk_service_id,
    supd.sin_sys_sale_side_status,
    supd.sin_sys_refund_side_status,
    sups.sin_record_type,
    sups.fk_ancillary_service_id,
    COALESCE(supf.dbl_supplier_amount, 0.00) AS dbl_supplier_amount,
    COALESCE(supf.dbl_customer_price, 0.00) AS dbl_customer_price,
    COALESCE(supf.dbl_actual_profit, 0.00) AS dbl_actual_profit
    --...
FROM service.tbl_supp_doc_no supd
    LEFT JOIN service.tbl_supp_doc_ap_sup_sharing sups
        ON supd.pk_supp_doc_no_id = sups.fk_supp_doc_no_id
    LEFT JOIN service.tbl_supp_doc_fare supf
        ON sups.fk_supp_doc_sup_ledg_fare_id = supf.pk_supp_doc_fare_id -- sups.fk_supp_doc_sup_base_fare_id Based on input currency
    LEFT JOIN service.tbl_service srv
        ON supd.fk_service_id = srv.pk_service_id
    LEFT JOIN service.tbl_ancillary_service ancs
        ON sups.fk_ancillary_service_id = ancs.pk_ancillary_service_id
WHERE supd.sin_last_action != 0 
    AND supd.sin_sys_sale_side_status > 0
    AND sups.fk_ancillary_service_id IS NOT NULL
    --...
UNION ALL

SELECT 'Cancel/Refund' AS str_type,
    supd.vhr_supp_doc_no,
    supd.sin_supp_doc_category,
    supd.fk_service_id,
    supd.sin_sys_sale_side_status,
    supd.sin_sys_refund_side_status,
    sups.sin_record_type,
    sups.fk_ancillary_service_id,
    COALESCE(supf.dbl_supplier_amount, 0.00) AS dbl_supplier_amount,
    COALESCE(supf.dbl_customer_price, 0.00) AS dbl_customer_price,
    COALESCE(supf.dbl_actual_profit, 0.00) AS dbl_actual_profit
    --...
FROM service.tbl_supp_doc_no supd
    LEFT JOIN service.tbl_supp_doc_ap_sup_sharing sups
        ON supd.pk_supp_doc_no_id = sups.fk_supp_doc_no_id
    LEFT JOIN service.tbl_supp_doc_fare supf
        ON sups.fk_supp_doc_sup_ledg_fare_id = supf.pk_supp_doc_fare_id -- sups.fk_supp_doc_sup_base_fare_id Based on input currency
    LEFT JOIN service.tbl_service srv
        ON supd.fk_service_id = srv.pk_service_id
    LEFT JOIN service.tbl_ancillary_service ancs
        ON sups.fk_ancillary_service_id = ancs.pk_ancillary_service_id
WHERE supd.sin_last_action != 0 
    AND supd.sin_sys_refund_side_status > 0
    AND sups.fk_ancillary_service_id IS NOT NULL
    --...
* Refund Fare showing -ve

Actions #4

Updated by Anil KV over 1 year ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions #5

Updated by Junaid M over 1 year ago

  • Assignee changed from travvise Admin to Arjun V
Actions #6

Updated by Junaid M over 1 year ago

  • Assignee changed from Arjun V to Shahil Haris
Actions #7

Updated by Junaid M over 1 year ago

  • Assignee changed from Shahil Haris to travvise Admin
Actions #8

Updated by Anil KV about 1 year ago

  • Assignee changed from travvise Admin to Vivekp V
Actions #9

Updated by Anil KV about 1 year ago

  • Status changed from Open to Ready for Coding
  • % Done changed from 10 to 20
Actions #10

Updated by Junaid M 8 months ago

  • Assignee changed from Vivekp V to Amal Ck
Actions #11

Updated by Amal Ck 8 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions #12

Updated by Amal Ck 8 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60
Actions #13

Updated by unnikannan S 7 months ago

  • Status changed from Coding Done to Testing Started
  • Tested By set to unnikannan S

Updated by unnikannan S 7 months ago

  • Status changed from Testing Started to Reopen Bugs
  • % Done changed from 60 to 50

ISSUE FOUNDED

1.Clear All Selection From Details Tab
2.Not Clearing Data While Clearing Added Airline Code And Search

Actions #15

Updated by Amal Ck 7 months ago

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

Updated by unnikannan S 6 months ago

  • Status changed from Reopen Bugs Coding Done to Testing Done
  • % Done changed from 70 to 90

Updated by Arathy PS 4 months ago

  • Status changed from Testing Done to Reopen Bugs
  • % Done changed from 90 to 50

ISSUE FOUND
--------------------------------------------
1. Increase the column width of Ancillary services in summary tab.

Updated by Amal Ck 4 months ago

grid width issue in multiple tab ui (refer: #277 (5))

Actions #19

Updated by Amal Ck 4 months ago

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

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 2 months ago

  • Status changed from Reopen Bugs Testing Done to New Changes
  • Assignee changed from Amal Ck to Augustin Jose
  • % Done changed from 90 to 50

New Change
----------------
1)Add redirection to document number and ticket/voucher number

Issue found
------------
1)Sold ticket on redirection load in Issue module
2)Issue date is not correct in document tab

Actions #22

Updated by Theja Ponon 2 months ago

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

Updated by Augustin Jose about 2 months ago

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

Updated by Theja Ponon about 2 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