TAAS

Trial Balance:-
===============
Input
------
-> Currency Mandatory[* red] - Base1(***)[Default], Base2(...)
-> Posting Status
- Rename Posting Status to Status[* red] 
- Items
  Posting Status[Group]
    Active[Tick]
    Active[Untick]
  Document Status[Group]
    Active[Tick]
    Active[Untick]
  Expected Transactions[Group]
        Paid Cheque Control Account Bank Posting[Untick]
-> Remove - Columns
-> Move Expand to Grid title section - Center
- Choose Custome then need a Entrybox - Expand <Selectbox><Entrybox-Somal><Refresh button - only icon> - Group the items(without label)
- Upto a word
- Add 'No Expand' item in the selectbox
- Custome Choose then show the entrybox
- Default Select - Upto Main Ledger
- Rename "Upto Ledger" to "Upto Main Ledger Sub Items" and View Main Ledger Sub Items check box is untick then desable the item
-> Move Expand to Grid title section - Center
-> Add Checkbox - "Debit or Credit Net Amount Only"[Title:- Each Section(OB, Current, Closing) Columns(Debit and Credit) Showing Net Amount(Net Amount Credit then Show Dr Column, Net Amount Cr then Show Cr Column)] before "View Main Ledger Sub Items" checkbox
List:-
------
-> Add *Net* 3 Columns after each Credit Column
-> Need Total[Expand items]
-> Add View Details Icon Last -> Load Ledger Stmt or Main Ledger Stmt

View Main Ledger Sub Items Checkbox OFF case

SELECT ca.pk_chart_of_ac_id,
        ca.vhr_code,
        ca.vhr_name,
        ca.vhr_display_name,
        ca.fk_parent_chart_of_ac_id,
        ca.sin_chart_of_ac_category,
        ca.sin_chart_of_ac_type,
        ca.sin_main_ledger_category,
        ca.sin_default_main_ledger,

        tr.fk_main_ledger_id,
        tr.dbl_ob_debit,
        tr.dbl_ob_credit,
        tr.dbl_debit,
        tr.dbl_credit
FROM accounts.tbl_chart_of_ac ca
    LEFT JOIN ( SELECT fk_main_ledger_id,

               SUM(dbl_ob_debit) AS dbl_ob_debit,
               SUM(dbl_ob_credit) AS dbl_ob_credit,

               SUM(dbl_debit) AS dbl_debit,
               SUM(dbl_credit) AS dbl_credit

            FROM (SELECT fk_main_ledger_id,

                    dbl_ledg_cur_debit AS dbl_ob_debit,
                    dbl_ledg_cur_credit AS dbl_ob_credit,

                    0.00 AS dbl_debit,
                    0.00 AS dbl_credit
                FROM transaction.tbl_transaction
                WHERE sin_posting_status = 1
                    AND sin_transaction_status = 1
                    AND sin_document_status  = 1
                    AND dat_transaction < '2023-01-01'
                    AND fk_branch_id IN (1)
                    AND fk_department_id = 1

                UNION ALL 

                SELECT fk_main_ledger_id,

                    0.00 AS dbl_ob_debit,
                    0.00 AS dbl_ob_credit,

                    dbl_ledg_cur_debit AS dbl_debit,
                    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 dat_transaction BETWEEN '2023-01-01' AND '2023-12-31'
                    AND fk_branch_id IN (1)
                    AND fk_department_id = 1) AS tr1
              GROUP BY fk_main_ledger_id) AS tr

            ON ca.pk_chart_of_ac_id = tr.fk_main_ledger_id;

View Main Ledger Sub Items Checkbox ON case

SELECT ca.pk_chart_of_ac_id,
        ca.vhr_code,
        ca.vhr_name,
        ca.vhr_display_name,
        ca.fk_parent_chart_of_ac_id,
        ca.sin_chart_of_ac_category,
        ca.sin_chart_of_ac_type,
        ca.sin_main_ledger_category,
        ca.sin_default_main_ledger,

        ac.pk_account_id,
        ac.vhr_account_code,
        ac.vhr_account_name,
        ac.vhr_display_name,

        tr.fk_main_ledger_id,
        tr.fk_ledger_id,
        tr.dbl_ob_debit,
        tr.dbl_ob_credit,
        tr.dbl_debit,
        tr.dbl_credit
FROM accounts.tbl_chart_of_ac ca
    LEFT JOIN ( SELECT fk_main_ledger_id,
               fk_ledger_id,

               SUM(dbl_ob_debit) AS dbl_ob_debit,
               SUM(dbl_ob_credit) AS dbl_ob_credit,

               SUM(dbl_debit) AS dbl_debit,
               SUM(dbl_credit) AS dbl_credit

            FROM (SELECT fk_main_ledger_id,
                    fk_ledger_id,

                    dbl_ledg_cur_debit AS dbl_ob_debit,
                    dbl_ledg_cur_credit AS dbl_ob_credit,

                    0.00 AS dbl_debit,
                    0.00 AS dbl_credit
                FROM transaction.tbl_transaction
                WHERE sin_posting_status = 1
                    AND sin_transaction_status = 1
                    AND sin_document_status  = 1
                    AND dat_transaction < '2023-01-01'
                    AND fk_branch_id IN (1)
                    AND fk_department_id = 1

                UNION ALL 

                SELECT fk_main_ledger_id,
                    fk_ledger_id,

                    0.00 AS dbl_ob_debit,
                    0.00 AS dbl_ob_credit,

                    dbl_ledg_cur_debit AS dbl_debit,
                    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 dat_transaction BETWEEN '2023-01-01' AND '2023-12-31'
                    AND fk_branch_id IN (1)
                    AND fk_department_id = 1) AS tr1
              GROUP BY fk_main_ledger_id, fk_ledger_id) AS tr

        ON ca.pk_chart_of_ac_id = tr.fk_main_ledger_id
    LEFT JOIN accounts.tbl_account ac
        ON tr.fk_ledger_id = ac.pk_account_id;

TESTING DONE

TESTING DONE