Feature #146
openCredit Limit Exceed Report
70%
Subtasks
Related issues
Updated by Anil KV almost 2 years ago
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
Updated by Anil KV almost 2 years ago
- Status changed from New to Open
- % Done changed from 0 to 10
Updated by Junaid M almost 2 years ago
- Status changed from Open to New
- Assignee changed from Junaid M to Karthika V Anand
- % Done changed from 10 to 0
Updated by Junaid M almost 2 years ago
- Status changed from New to Open
- % Done changed from 0 to 10
Updated by Karthika V Anand almost 2 years ago
- Status changed from Open to Coding Started
- % Done changed from 10 to 40
Updated by Karthika V Anand almost 2 years ago
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
Updated by Amal Cyriac almost 2 years ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to Amal Cyriac
ISSUE FOUND
*****
1.Amounts/Percentage should be align to right
2.Add precision on percentage column
3.Fix bugs on "above" input box - Bugs while clear value
Updated by Karthika V Anand almost 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by Amal Cyriac over 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUND
*****
1.Fix calculation mistakes on report
2.Resize grid columns
Updated by Karthika V Anand over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by unnikannan S over 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By changed from Amal Cyriac to unnikannan S
ISSUE FOUNDED
1.NOT SHOWING DATAS OF THE ACT US CUSTOMER AND SUPPLIER
2.SHOWING ONLY ONE CREDIT LIMIT
Updated by Karthika V Anand over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by Junaid M over 1 year ago
- Assignee changed from Karthika V Anand to Vivekp V
Updated by unnikannan S over 1 year ago
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
Updated by Anil KV about 1 year ago
- Status changed from Reopen Bugs Coding Done to New Changes
- % Done changed from 70 to 50
New Changes ++
=> Customer and Supplier checkbox Remove => Add Dropdown label -> Customer | Multi Selectbox -> Customer Overdue Report->Consider(Ref) -> Supplier| Multi Selectbox -> Supplier Overdue Report->Consider(Ref) -> Consider Counter Staff(Own Account) -> Showing-Counter Staff Connected employee account- No input(Disable Counter staff inputs) -> Consider Counter Staff(Linked Ac) -> List Group Counter Staff->Linked Account wise - need Counter Staff input optional -> Consider Counter Staff(Non Linked Ac) -> Showing-Counter Staff wise - No input(Disable Counter staff inputs) =>Consider Not Approved DocumentsChange to Customer Overdue Report->Status(Ref) => Input order As On Date Status Type/Group/... Branch Department Customer /Supplier/Counter Staff(Own)/... Above %* **** Currency -> Credit limit Based on Currency - Ref Customer Master - Pls discus with anil
Updated by Theja Ponon about 2 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FIXED
--------------
1)DELETED EXTRA LIMIT ALSO SHOWS ON THE GRID
Updated by Vivekp V about 2 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon about 2 months ago
- Assignee changed from Vivekp V to Augustin Jose
ISSUE FOUND
-----------------
1)Change the As on date balance percentage calculation based on total limit
Updated by Theja Ponon about 2 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90
Updated by Theja Ponon about 2 months ago
- Status changed from Reopen Bugs Testing Done to Reopen Bugs
- % Done changed from 90 to 50
Updated by Augustin Jose about 2 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Arathy PS about 1 month ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
----------------------------
1. Data not showing according to the selected status. As on date acc balance should change based on status of the document or posting.
2. Add a space between 'Total inQAR' in print.
Updated by Augustin Jose about 1 month ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70