Feature #132
openCheque Holding Report
Added by Anil KV about 2 years ago. Updated 3 months ago.
90%
Subtasks
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>>
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
- Assignee changed from Junaid M to Karthika V Anand
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 unnikannan S over 1 year ago
ISSUE FOUNDED
1.REMOVE LIST FROM GRID
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
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
ISSUE FOUNDED
1.SHOWING PARTY US UNDEFINED
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 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
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
Updated by Amal Siby about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70