Feature #248
openAncillary Sales Reports
Added by Anil KV over 1 year ago. Updated about 2 months ago.
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:
Subtasks
Related issues
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
Updated by Anil KV over 1 year ago
- Status changed from New to Open
- % Done changed from 0 to 10
Updated by Junaid M over 1 year ago
- Assignee changed from travvise Admin to Arjun V
Updated by Junaid M over 1 year ago
- Assignee changed from Arjun V to Shahil Haris
Updated by Junaid M over 1 year ago
- Assignee changed from Shahil Haris to travvise Admin
Updated by Anil KV about 1 year ago
- Assignee changed from travvise Admin to Vivekp V
Updated by Anil KV about 1 year ago
- Status changed from Open to Ready for Coding
- % Done changed from 10 to 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
Updated by Theja Ponon 2 months ago
- Status changed from New Changes to Reopen Bugs
Updated by Augustin Jose 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 2 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90