TAAS

Solutions

* Check Customer sales and Refund Report #228, DSR Sumary #222 and Details #221
1) GUI Changes
- Add transfer tab
-Add Transaction Date(Default) in period
- Merge checkbox move to under Consider
-Customer label set title Main Customer and add blue *
*Merge Tick then show Summary and details tabs only, Uptick then hide details tab
- Status changed to Consider and default Ticked items - Sale, Void(From Refund GUI), Refund
2) SQL
SELECT doc.vhr_main_document_no,
    doc.dat_document,
        ...
FROM sale.tbl_sale_master sm
    INNER JOIN sale.tbl_sale_details sd
        ON sd.fk_sale_master_id = sm.pk_sale_master_id
    INNER JOIN document.tbl_documents doc
        ON sm.fk_documents_id = doc.pk_documents_id
    INNER JOIN service.tbl_supp_doc_no spd
        ON sd.fk_supp_doc_no_id = spd.pk_supp_doc_no_id
    INNER JOIN service.tbl_supp_doc_ap_sup_sharing aps
        ON aps.fk_supp_doc_no_id = spd.pk_supp_doc_no_id
            AND aps.sin_record_type = 1
    INNER JOIN service.tbl_supp_doc_fare apsf 
        ON aps.fk_supp_doc_sup_ledg_fare_id = apsf.pk_supp_doc_fare_id
WHERE ...
ORDER BY dat_sharing
UNION ALL
[REFUND]
* Posting date = service.tbl_supp_doc_ap_sup_sharing->dat_sharing
* Supplier Check = service.tbl_supp_doc_ap_sup_sharing->fk_actual_supplier_id
* Consider service.tbl_supp_doc_no->jsn_related_data
3) 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
-Grouping Grouping Sel item -> Services
-Calculated based on Details Data

TESTING DONE

TESTING DONE

TESTING DONE

TESTING DONE

3. Sup Conf No not showing in the grid column.
4. Supplier charge not showing in the grid column