TAAS

Customer Case:-

SELECT subtr.fk_account_id,
        ac.vhr_account_code,
        ac.vhr_account_name,
        subtr.dbl_net_balance,
        cu.dbl_credit_limit,
        subex.dbl_extra_limit,
        (subtr.dbl_net_balance*100/cu.dbl_credit_limit) AS dbl_credit_limit_perc
FROM accounts.tbl_customer cu
    INNER JOIN accounts.tbl_account ac
        ON cu.fk_account_id = ac.pk_account_id
    INNER JOIN (
        SELECT str.fk_ledger_id AS fk_account_id,
               SUM(str.dbl_base_cur_debit - str.dbl_base_cur_credit) AS dbl_net_balance
        FROM transaction.tbl_transaction str
            INNER JOIN accounts.tbl_account sac
                ON str.fk_ledger_id = sac.pk_account_id
            INNER JOIN accounts.tbl_customer scu
                ON sac.pk_account_id = scu.fk_account_id
        WHERE str.dat_transaction <= ???
            AND str.fk_branch_id = ???
            AND str.fk_department_id = ???
            AND str.fk_ledger_id = ???
            AND str.sin_posting_status = ???[1=Active, Cosider 0 record also then remove the condition]
            AND scu.dbl_credit_limit > 0
        GROUP BY fk_ledger_id) AS subtr
            ON ac.pk_account_id = subtr.fk_account_id
    LEFT JOIN (SELECT fk_account_id,
                   SUM(dbl_extra_limit) AS dbl_extra_limit
              FROM creditlimit.tbl_extra_limit
              WHERE dat_effective_to <= ???
               AND ??? = ANY(arb_fk_branch_ids)
               AND ??? = ANY(arb_fk_department_ids)
               AND fk_account_id = ???
               AND dbl_credit_limit > 0
              GROUP BY fk_account_id) subex
        ON ac.pk_account_id = subex.fk_account_id
WHERE (subtr.dbl_net_balance*100/cu.dbl_credit_limit) >= ???

Supplier Case:- **
Replace accounts.tbl_customer to accounts.tbl_supplier

ISSUE FOUNDED

1.NAN IN PERCENTAGE FIELD WHILE ADDING LETTTERS AND SEARCH FIXED
2.SHOW DEFAULT PRINT BUTTON FIXED
2.ERROR WHILE ADDING PERCENTAGE MORE THAN A LIMIT FIXED