TAAS

Solution
-Check SOA, Ledger Stament, Overdue Reports

1) GUI Change
-Rmove Issue Date
- Add Currency - Empty allowed (Default), Base1(***), QAR, SQR,...
-Sub Customer to Customer
- Add Consider Matching Done After To Date Checkbox - Default Tick
-Add Customer column in list after Issue Date
-Add Grouping in list title - No Grouping, Responsible Staff, Customer
2) SQL
if ((matched, Oustanding) or Consider Matching Done After To Date) then 
SELECT tr.fk_ledger_id,
    ac.vhr_account_code,
    ac.vhr_account_name,
    ac.vhr_display_name,

    tr.vhr_ledg_currency,
    tr.dbl_ledg_cur_debit,
    0.00 AS dbl_ledg_cur_matched,
    tr.dbl_base_cur_debit,
    0.00 AS dbl_base_cur_matched,

    doc.vhr_document_no,
    doc.dat_document,
    doc.dat_due
FROM transaction.tbl_transaction tr
    LEFT JOIN document.tbl_documents doc 
        ON tr.fk_documents_id = doc.pk_documents_id
            AND doc.int_sys_action_id != -1
    LEFT JOIN accounts.tbl_account AS ac
        ON tr.fk_ledger_id = ac.pk_account_id
WHERE tr.sin_record_type IN (3, 4)
    AND tr.vhr_sys_module_name = 'SALE'
    AND (doc.fk_responsible_user_id IS NOT NULL OR doc.fk_responsible_emp_id IS NOT NULL)
    AND tr.dbl_ledg_cur_debit > 0
    --...
ORDER BY doc.vhr_document_no, doc.dat_document
else
** JOIN Settlement LISKE SOA and Ledger stmt 

--Consider jsn_related_data - Take Ticket/Voucher No, Issue Date etc...
--if (overdue tick):
-- AND doc.dat_due < <TO_DATE>
--fk_responsible_emp_id -> Employee and Account

TESTING DONE

TESTING DONE

ENHANCEMENT
---------------
Title Staff responsible sales ---> staff responsible sales report (ask junaid)