TAAS

SQL

SELECT fk_main_ledger_id,
        fk_ledger_id,
        TO_CHAR(dat_transaction, 'Month') AS str_month,
        TO_CHAR(dat_transaction, 'YYYY') AS str_year,
        SUM(dbl_ledg_cur_debit) AS dbl_debit,
        SUM(dbl_ledg_cur_credit) AS dbl_credit
    FROM transaction.tbl_transaction
    WHERE sin_posting_status = 1
        AND sin_transaction_status = 1
        AND sin_document_status = 1
        AND vhr_ledg_currency = 'QAR'
        ...
    GROUP BY fk_main_ledger_id, fk_ledger_id, str_month, str_year;

* Base1 Currency case
SUM(dbl_base_cur_debit) AS dbl_debit,
        SUM(dbl_base_cur_credit) AS dbl_credit
-No filter Currency wise

TESTING DONE