TAAS

Solutions

1) GUI Changes
-Currency - Default Empty - Add BASE1(***),BASE2(***), All currency code
-Add status - like Ledger stmt
2) SQL
SELECT tr.dat_transaction
       --...
FROM transaction.tbl_transaction tr
    LEFT JOIN document.tbl_documents doc
        ON tr.fk_documents_id = doc.pk_documents_id
WHERE tr.sin_posting_status = 1
    AND tr.sin_transaction_status = 1
    AND tr.sin_document_status = 1
    AND tr.sin_posting_type != 4 
    AND tr.fk_ledger_id = 1 -- Input To branche Control account id
    AND doc.fk_branch_id IN (1, 2) -- Input from branches
    AND tr.dat_transaction BETWEEN '2023-09-01' AND '2023-09-30'
ORDER BY tr.dat_transaction;
*Input currency base amount choose