Project

General

Profile

Edit Copy Actions

Feature #260

open

Sales Comparison Report

Added by Anil KV over 1 year ago. Updated 5 months ago.

Status:
New Changes Coding Done
Priority:
Normal
Assignee:
Target version:
Start date:
07/09/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Sales Comparison Report
Tested By:
Code Reviewed By:

Description

Coding Sales Comparison Report


Files


Add

Subtasks


Add

Related issues

Updated by Anil KV over 1 year ago

  • File Sales Comparison Report_GUI_CHANGE.jpeg added

GUI Change
All inputs check DSR report


->Consider - Mutileslectbox - Sale, Refund -> Tick All Default
->Currency items - All Currency code, + Base1(***)
->Year* to Financial Year* MultiSelectbox and load all Financial Year DESC - tick Current and previous 2 years
->Pax Name to Pax Name~ and set default - down option Pax Profile
->Value move to List title
-Price, Supplier Amount, profit keep 3 attributes
->Remove # Column
->Add Sub Grouping selectbox in List title
-No Grouping, Mode Of Sale, Customer, Supplier, Cash Counter, Cost Centre, Service

Updated by Anil KV over 1 year ago

SQL
Discus with Shanto and Junide

---- Based on Consider SALE -input
SELECT TO_CHAR('2023-12-31'::DATE, 'Month') AS str_month;
SELECT 'Sale' AS str_type,
    mofsm.sin_mod_of_sale_type,
    mofsm.fk_customer_ac_id,
    mofsm.fk_cash_counter_id,
    sm.fk_cost_centre_id,
    spd.fk_supplier_id,
    spd.fk_service_id,
    TO_CHAR(spd.dat_sale, 'Month') AS str_month, --Dynamically set spd.dat_issue or spd.dat_sale based on 
    TO_CHAR(spd.dat_sale, 'YYYY') AS str_year -- Dynamically set spd.dat_issue or spd.dat_sale based on 
    doc.fk_branch_id,
    SUM(spdf.dbl_supplier_amount) AS dbl_supplier_amount,
    SUM(spdf.dbl_customer_price) AS dbl_customer_price,
    SUM(spdf.dbl_normal_profit) AS dbl_normal_profit
FROM sale.tbl_mod_of_sale mofsm
    LEFT JOIN sale.tbl_sale_master sm
        ON mofsm.fk_sale_master_id = sm.pk_sale_master_id
    LEFT JOIN document.tbl_documents doc
        ON sm.fk_documents_id = doc.pk_documents_id
    LEFT JOIN sale.tbl_mod_of_sale_supp_doc mofsd
        ON mofsm.pk_mod_of_sale_id = mofsd.fk_mod_of_sale_id
    LEFT JOIN service.tbl_supp_doc_no spd
        ON mofsd.fk_supp_doc_no_id = spd.pk_supp_doc_no_id
    LEFT JOIN service.tbl_supp_doc_fare spdf 
        ON mofsd.fk_base_fare_id = spdf.pk_supp_doc_fare_id
WHERE doc.int_sys_action_id != -1
GROUP BY  mofsm.sin_mod_of_sale_type,
    mofsm.fk_customer_ac_id,
    mofsm.fk_cash_counter_id,
    sm.fk_cost_centre_id,
    spd.fk_supplier_id,
    spd.fk_service_id,
    str_month,
    str_year,
    doc.fk_branch_id
ORDER BY str_month --or dat_issue based on input

UNION ALL -- Based on Consider REFUND - input

*REFUND...
*.....
*....
* WHERE sin_sys_refund_side_status = 4 and/or 5
--       4 = Void(From Refund GUI)
--       5 = Refund
* Refund date or Cancel date use

- Base1 Currency
LEFT JOIN service.tbl_supp_doc_fare spdf 
        ON mofsd.fk_base_fare_id = spdf.pk_supp_doc_fare_id

- Other Currency Case
LEFT JOIN service.tbl_supp_doc_fare spdf 
        ON mofsd.fk_cus_ledg_fare_id = spdf.pk_supp_doc_fare_id

* Less refund amount from sales

Actions #3

Updated by Anil KV over 1 year ago

  • Status changed from New to Open
  • Assignee changed from travvise Admin to Baseem Shan
  • % Done changed from 0 to 10
Actions #4

Updated by Anil KV about 1 year ago

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

Updated by Anonymous 8 months ago

  • File deleted (Sales Comparison Report_GUI_CHANGE.jpeg)
Actions #7

Updated by Junaid M 8 months ago

  • Assignee changed from Baseem Shan to Nithin PM
Actions #8

Updated by Nithin PM 8 months ago

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

Updated by Nithin PM 8 months ago

  • Status changed from Coding Started to Particialy Coding Done
  • % Done changed from 30 to 40

status - coding partially done

blockers -
1. grid -
  • there is a grouping on the grid
  • data is visible on the list that given to the grid when it is consoled on ts, But grid is not responding to it.
  • Grid data preparing function name - fnSettingGridValues().
  • referred modules - Ledger-Comparison-Report and Currency-Comparison_report.
    2. Print has to be done.
    3. there is functions called fnSetFinancialYearsDefault() and fnSetFinancialYear() for setting default selected year it was working before but it's not working now
  • the function is called inside the onInit function and its not working, When I called it on inside of other functions its working.
    4. Exclude -
  • where condition on query not given. Not using transaction table on this query

Updated by Nithin PM 7 months ago

1.*Grid Issue*
->Dynamic column with Grid grouping not working properly
Referred modules - Ledger-Comparison-Report and Currency-Comparison_report. [These module has dynamic column, but no Grid grouping, hence it is working fine. In Sales comparison need Dynamic Column + Grid grouping].
2. Print has to be done.
3. there is functions called fnSetFinancialYearsDefault() and fnSetFinancialYear() for setting default selected year it was working before but it's not working now
the function is called inside the onInit function and its not working, When I called it on inside of other functions its working.
4. Exclude -
where condition on query not given. Not using transaction table on this query.

Actions #11

Updated by Anil KV 5 months ago

  • Status changed from Particialy Coding Done to New Changes Testing Started
  • % Done changed from 40 to 80
Actions #12

Updated by Anil KV 5 months ago

  • Status changed from New Changes Testing Started to Reopen Bugs
  • % Done changed from 80 to 50
Actions #13

Updated by Anil KV 5 months ago

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

Updated by Nithin PM 5 months ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70
Edit Copy Actions

Also available in: Atom PDF