TAAS

Solutions

* Check Customer Sale & Refund Report #228
1) GUI Changes
-Add Transaction Date(Default) in period
*sale.tbl_ta_mod_of_sale->dat_posting
-Supplier label set title Main Supplier  and add blue *
-Add Reference Employee also in Issuing Staff drop down
- Add Sub Customer in Group By selectbox
-Remove Merge checkbox
- Status changed to Consider and default Ticked items - Sale, Void(From Refund GUI), Refund
-Add No Of Sales Items, No Of Refund Items, Net Items after Net Count

2) SQL
SELECT 'SALE' AS str_record_type,
    spd.fk_service_id,
    doc.fk_branch_id,
    doc.fk_department_id,
    COUNT(DISTINCT mofsm.fk_documents_id) AS int_document_count,
    mofsm.fk_sub_customer_id,
    COUNT(DISTINCT mofsd.fk_supp_doc_no_id) AS int_item_count,
    TO_CHAR(mofsm.dat_posting, 'Month-YYYY') AS str_month,--***Dynamic field dat_posting/dat_issue, dat_document[Refund]
    SUM(spdf.dbl_customer_price) AS dbl_amount,
    SUM(spdf.dbl_normal_profit) AS dbl_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
GROUP BY doc.fk_branch_id, doc.fk_department_id, spd.fk_service_id, str_month, mofsm.fk_sub_customer_id

UNION ALL

[REFUND]
***dat_posting/dat_cancel, dat_document[Refund]

*** Logic
-doc.fk_branch_id, doc.fk_department_id, spd.fk_service_id, str_month, mofsm.fk_sub_customer_id wise diff list return form CS 
-Each item(doc.fk_branch_id, doc.fk_department_id, spd.fk_service_id, str_month, mofsm.fk_sub_customer_id) and str_record_type wise total(count, amount, profit)

TESTING DONE

ISSUE FOUNDED

1.NOT CLEARING DELETED VOUCHERS DATA
2.NO DATA WHILE SEARCH WITH INDIVIDUAL CURRENCIES
3.NOT CLEARING DATAS IN GRID AND DROP DOWN OF CUSTOMER WHILE CHOOSING NEW BUTTON
4.ERROR IN ISSUE/CANCEL DATE WISE SEARCH

ISSUE FOUNDED

1.DONT SHOW ALREADY SOLD/REFUNDED VOUCHERS IN SALE ITEMS AND CANCEL ITEMS LIST COLUMNS

TESTING DONE