TAAS

Gui Changes ****
1-Add View Posting Button and Pop-up

*Need Posting (Dr, Cr Ticket Amounts)
*Insert In Transaction Reference Table

1)Search Query

SELECT
    CASE WHEN tr.dat_transaction < CAST('2023-12-01' AS DATE) THEN 1 ELSE 0 END AS sin_is_previous, -- FROM DATE
    tr.vhr_sys_module_name,
    tr.fk_documents_id,
    CASE WHEN tr.dbl_base_cur_debit > 0 THEN tr.dbl_base_cur_outstanding ELSE 0.00 END AS dbl_outstanding_debit,--dynamic column    
    CASE WHEN tr.dbl_base_cur_credit > 0 THEN tr.dbl_base_cur_outstanding ELSE 0.00 END AS dbl_outstanding_credit,--dynamic column
    CAST(tr.jsn_related_data->>'binAirlineMasterId' AS VARCHAR) AS bin_airline_master_id,
    CAST(tr.jsn_related_data->>'strAirlineNumCode' AS VARCHAR) AS vhr_airline_num_code,
    CAST(tr.jsn_related_data->>'strAirlineCharCode' AS VARCHAR) AS vhr_airline_char_code,
    CAST(tr.jsn_related_data->>'strAirlineName' AS VARCHAR) AS vhr_airlinename,
    CAST(tr.jsn_related_data->>'strSuppDocNo' AS VARCHAR) AS vhr_supp_doc_no,
    CAST(tr.jsn_related_data->>'datIssueOrCancel' AS VARCHAR) AS dat_issue_or_cancel,
    CAST(tr.jsn_related_data->>'strSector' AS VARCHAR) AS vhr_sector,
    CAST(tr.jsn_related_data->>'strSuppDocType' AS VARCHAR) AS vhr_supp_doc_type,
     tr.txt_narration
FROM transaction.tbl_transaction AS tr
LEFT JOIN document.tbl_documents AS doc
    ON tr.fk_documents_id = doc.pk_documents_id
WHERE tr.sin_transaction_status = 1 AND tr. sin_posting_status = 1 AND tr. sin_document_status = 1
    AND tr.dbl_base_cur_outstanding > 0
    AND tr.fk_supp_doc_no_id IS NOT NULL
    AND tr.fk_ledger_id = 59
    --...Remining ui filter where conditions

2) Load Doc

3) Posting - Total Amount
Supplier * Dr
Supplier * Cr

4) Internal Matching the Doc Dr and Selected docs and Inter Matching Selected Docs Dr and Cr
-Pending

TESTING DONE

TESTING DONE

-- 53 = BSP/NON BSP Supplier Reco - Dr - Internal matched Debit or Credit Record
-- 54 = BSP/NON BSP Supplier Reco - Cr - Internal matched Oposit Debit or Credit

Use Record Type

Delete Pending (matching restoration is pending) DONE

NEW CHANGES DONE
---------------------------------------------
1. Add a new column 'Current' and show the selected documents from other tabs there while the system column should show all datas on the ledger.
2)ADD FIELD FOR HOTEL FILTERING
3)IF HOTEL FILTERING APPLIED ONLY SHOW HOTEL AND PREVIOUS TABS OTHER SHOULD BE HIDDEN
4)ADD PACKAGE