Project

General

Profile

Edit Copy Actions

Feature #146

open

Credit Limit Exceed Report

Added by Anil KV about 2 years ago. Updated about 1 month ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Target version:
Start date:
02/02/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Credit Limit Exceed Report
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Credit Limit Exceed Report


Add

Subtasks


Add

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

Actions #2

Updated by Anil KV almost 2 years ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions #3

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
Actions #4

Updated by Junaid M almost 2 years ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions #5

Updated by Karthika V Anand almost 2 years ago

  • Status changed from Open to Coding Started
  • % Done changed from 10 to 40
Actions #6

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

Actions #8

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

Actions #10

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

Actions #12

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
Actions #13

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 Vivekp V 12 months ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70

CODING DONE

Updated by unnikannan S 9 months ago

  • Status changed from New Changes Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUNDED

1.Show Data In System Type On UI Selection

Updated by Vivekp V 9 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

ISSUE FIXED

1.Show Data In System Type On UI Selection

Actions #19

Updated by unnikannan S 6 months ago

  • Status changed from Reopen Bugs Coding Done to Testing Done
  • % Done changed from 70 to 90

Updated by unnikannan S 6 months ago

  • Status changed from Testing Done to Reopen Bugs
  • % Done changed from 90 to 50

ISSUE FOUNDED

1.Do Not Unfreeze UI While Choosing Print

Updated by Vivekp V 5 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

ISSUE FIXED

1.Do Not Unfreeze UI While Choosing Print

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

Actions #23

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

Actions #25

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
Actions #26

Updated by Theja Ponon about 2 months ago

  • Status changed from Reopen Bugs Testing Done to Reopen Bugs
  • % Done changed from 90 to 50
Actions #27

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.

Actions #29

Updated by Augustin Jose about 1 month ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Edit Copy Actions

Also available in: Atom PDF