TAAS

Solution

*GUI CHanges
-Add Mege Checkbox like #234->Supplier Sale & Refund Report
-List Changes like #234->Supplier Sale & Refund Report
* Check DSR Sumary #222 and Details #221
1) GUI Changes
-Add Transaction Date(Default) in period
-Supplier label set title Main Supplier  and add blue *
*sale.tbl_ta_mod_of_sale->dat_posting
- Status changed to Consider and default Ticked items - Sale, Void(From Refund GUI), Refund
2) Summary Data 
-Remove Currency Column
-Add No Of Sales Items, No Of Refund Items, Net Items after Net Count
-Grouping Need a empty item - Default
-add Grouping Sel item -> Services
-Calculated based on Details Data
3) Details Data
Like DSR Details
Consider service.tbl_supp_doc_no->jsn_related_data field also
Customer where (sale.tbl_mod_of_sale->fk_customer_ac_id = 1 OR sale.tbl_mod_of_sale->fk_actual_customer_ac_id = 1)
4) SQL
Mainly focused -> service.tbl_supp_doc_no->jsn_related_data

IF CONSIDER SALE THEN
SELECT ....
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
ORDER BY spd.dat_sale

IF CONSIDER REFUND or VOID(FROM REFUND GUI) THEN
UNION ALL
[REFUND]

IF CONSIDER ISSUE THEN
UNION ALL
SELECT 'Issue/Sale' AS str_type,
       sudn.sin_sys_sale_side_status,
    sudn.sin_sys_refund_side_status,
    ...
        sudn.jsn_related_data
FROM service.tbl_supp_doc_no sudn
    LEFT JOIN service.tbl_supp_doc_fare sudf
            ON sudn.fk_issue_base_fare_id = sudf.pk_supp_doc_fare_id --*1
WHERE sudn.sin_sys_sale_side_status = 1

IF CONSIDER CANCEL or VOID(Direct) THEN
UNION ALL
SELECT 'Cancel/Refund' AS str_type,
       sudn.sin_sys_sale_side_status,
    sudn.sin_sys_refund_side_status,
    ...
        sudn.jsn_related_data
FROM service.tbl_supp_doc_no sudn
    LEFT JOIN service.tbl_supp_doc_fare sudf
            ON sudn.fk_cancel_base_fare_id = sudf.pk_supp_doc_fare_id --*2
WHERE sin_sys_refund_side_status IN (1,3) -- 

TESTING DONE

TESTING DONE

TESTING DONE

TESTING DONE

1. Sup Conf No not showing in the grid column.
2. Supplier charge not showing in the grid column (also refund charge).