TAAS

GUI Changes
1) Account - title=Income and Expense Account Only
2) Menu move to Management report Last
3) Add Grouping Selectbox in Grid Title bar -
-No Grouping
-Module Wise(Default)
List Data
1) SQL

 SELECT tr.vhr_sys_module_name,
         tr.fk_ledger_id,
         MIN(ac.vhr_account_code) AS vhr_account_code,
        MIN(ac.vhr_account_name) AS vhr_account_name,

        SUM(tr.dbl_ledg_cur_debit) AS dbl_ledg_cur_debit,
        SUM(tr.dbl_ledg_cur_credit) AS dbl_ledg_cur_credit,

        SUM(tr.dbl_base_cur_debit) AS dbl_base_cur_debit,
        SUM(tr.dbl_base_cur_credit) AS dbl_base_cur_credit,

        SUM(tr.dbl_cons_cur_debit) AS dbl_cons_cur_debit,
        SUM(tr.dbl_cons_cur_credit) AS dbl_cons_cur_credit
FROM transaction.tbl_transaction tr
LEFT JOIN accounts.tbl_account ac
    ON tr.fk_ledger_id = ac.pk_account_id
WHERE tr.sin_posting_status = 1
    AND tr.sin_transaction_status = 1
    AND tr.sin_document_status  = 1
    AND tr.dat_transaction BETWEEN '2023-01-01' AND '2023-12-31'
    AND tr.fk_branch_id IN (1)
    AND tr.fk_department_id IN (1)
        AND tr.vhr_ledg_currency =
    AND ac.sin_ac_category IN (3,4)
        ....
GROUP BY vhr_sys_module_name, fk_ledger_id

- Amount Filed use based on selected currency
- Where change based on inputs

TESTING DONE

issues fixed
1.on new button click status field becomes empty
2. searching with all branches causes {} symbol error to occur

TESTING DONE

TESTING DONE