Project

General

Profile

Edit Copy Actions

Feature #132

open

Cheque Holding Report

Added by Anil KV about 2 years ago. Updated 3 months ago.

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

90%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Cheque Holding Report
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Cheque Holding Report


Add

Subtasks


Add

Related issues

Updated by Anil KV almost 2 years ago

Input Changes
1) Status Multi Select - Default ON HOLD
2) Customer - Code and Name entry option
3) Currency - like Ledger Statement
4) Add Cheque Date(2 Date picker - like priod), Default blank

- Column Width Re-set

Updated by Anil KV almost 2 years ago

SELECT doc1.pk_documents_id,
    doc1.dat_document,
    doc1.vhr_document_no,
    rc.vhr_cheque_no,
    rc.dat_cheque,
    rc.vhr_issued_bank,
    rc.vhr_name_on_cheque,
    rc.vhr_ledg_currency,
    rc.dbl_ledg_cur_amount,
    rc.vhr_base_currency,
    rc.dbl_base_cur_amount,
    rc.chr_current_cheque_status,
    rc.vhr_id_number,
    tmp.int_record_no,
    tmp.fk_cheque_ac_id,
    tmp.fk_cheque_posting_ac_id,
    tmp.chr_cheque_status,
    tmp.dat_document,
    tmp.fk_received_cheque_id,
    tmp.fk_cr_customer_id
FROM (SELECT row_number() OVER (PARTITION BY rcd.fk_received_cheque_id
    ORDER BY rcd.pk_rec_cheque_details_id DESC) as int_record_no,
        fk_cheque_ac_id,
        fk_cheque_posting_ac_id,
        rcd.chr_cheque_status,
        doc.dat_document,
        rcd.fk_received_cheque_id,
        rcd.fk_cr_customer_id
    FROM receivedcheque.tbl_rec_cheque_details rcd
        LEFT JOIN document.tbl_documents doc 
            ON rcd.fk_documents_id = doc.pk_documents_id
        LEFT JOIN accounts.tbl_account ac1 
            ON rcd.fk_cheque_posting_ac_id = ac1.pk_account_id
        LEFT JOIN accounts.tbl_account ac2 
            ON rcd.fk_cheque_ac_id = ac2.pk_account_id
                AND doc.int_sys_action_id != -1 
    WHERE doc.dat_document <= *<<As On Date>>) AS tmp

    LEFT JOIN receivedcheque.tbl_received_cheque rc 
        ON  tmp.fk_received_cheque_id = rc.pk_received_cheque_id AND tmp.int_record_no =1
    LEFT JOIN document.tbl_documents doc1 
        ON doc1.pk_documents_id = rc.fk_received_doc_id AND doc1.int_sys_action_id != -1
WHERE tmp.int_record_no = 1 
    AND *<All filter except <As On Date>>

Actions #3

Updated by Anil KV almost 2 years ago

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

Updated by Junaid M almost 2 years ago

  • Assignee changed from Junaid M to Karthika V Anand
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 unnikannan S over 1 year ago

ISSUE FOUNDED

1.REMOVE LIST FROM GRID

Actions #8

Updated by unnikannan S over 1 year ago

  • Status changed from Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to unnikannan S
Actions #9

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

TESTING DONE

Updated by unnikannan S over 1 year ago

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

ISSUE FOUNDED

1.SHOWING PARTY US UNDEFINED

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 Amal Siby

Updated by unnikannan S over 1 year ago

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

ISSUE FOUNDED

Fixed. 1.SHOW DATA US PER CHOOSEN FILTERS-CURRENCY,CASH COUNTER,CREATED USER
Fixed 2.SHOW BASE 1 QAR WISE CHANGE IN AMOUNT FIELD IF ANY OTHER CURRENCY IN LIST RATHER THAN QAR
Fixed. 3.SHOW DEFAULT PRINT IN UI
Fixed. 4.ADD BLANK OPTION IN CASH COUNTER

Actions #15

Updated by Amal Siby over 1 year ago

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

Updated by unnikannan S about 1 year ago

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

ISSUE FOUNDED

Fixed 1.MISSING DATA WHILE CHOOSING PRINT
Fixed 2.SHOWING ALL CHEQUE STATUS AS HOLD IN PRINT / DIFFERENT IN UI
Fixed 3.SHOW DATA IN CASE OF ADDING BLANK OPTION IN CURRENCY FIELD
Fixed 4.Rename Customer To Party

Actions #17

Updated by Amal Siby about 1 year ago

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

Updated by unnikannan S about 1 year ago

TESTING DONE

Actions #19

Updated by Junaid M 11 months ago

  • Assignee changed from Amal Siby to Vivekp V
Actions #20

Updated by unnikannan S 3 months ago

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

Also available in: Atom PDF