Project

General

Profile

Edit Copy Actions

Feature #218

open

Paid Cheque Query

Added by Junaid M over 1 year ago. Updated 2 days ago.

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

70%

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

Description

Coding Paid Cheque Query


Files

clipboard-202502271154-kdfpk.png (60.8 KB) clipboard-202502271154-kdfpk.png Theja Ponon, 02/27/2025 11:54 AM

Add

Subtasks


Add

Related issues

Updated by Anil KV 8 months ago

GUI Change:-

-> Remove General Tab, Move General Tab Table to Document Tab 1st widget 
-> Cheque No - mandatory - need red star
-> Paid Cheque Search GUI popup like Paid Cheque Return - All status need
-> Remove drop down widget after cheque no

Updated by Anil KV 8 months ago

Work Flow:-

-> Select a Cheque from Search popup then ID based get
- Cheque no direct enter in inputbox then data get based on Cheque no(Some cheque no more than one then get last cheque based on cheque date)

Updated by Anil KV 8 months ago

General Tab:-

Cheque Number               Current Status
Cheque Date                 Issued Bank
Cheque Book Number          Cheque On Name
Currency                    Cleared Date
Amount                      Reconciliation Number
FOP Account                 Direct Deposit[Yes or No]
Expected Cleared Date

Root Document               Root Document Date
Party                       Branch
Sub Customer                Cash Counter
Root Cheque Status         Created By [with Created  Date & Time]
Remark           

SQL
- Document Tab Result -> sin_cheque_action_level == 0 record only

Updated by Anil KV 8 months ago

Document Tab
Table Columns

#
Document No
Date
Action
Cheque Status
Amount([Base Currency Code])
Party
Reference
Narration
Created By
Modified By
[Edit Icon]

SQL
SELECT
...
paidcheque.tbl_paid_cheque_details 
LEFT JOIN paidcheque.tbl_paid_cheque
LEFT JOIN paidcheque.tbl_cheque_leaf
LEFT JOIN document.tbl_documents
...
WHERE int_sys_action_id > 0
AND [pk_paid_cheque_id == ? or vhr_cheque_no == ?]
...
ORDER BY pk_paid_cheque_details_id

Updated by Anil KV 8 months ago

Log
GUI

#
Document No
Date
Cheque No
Cheque Date
Issued Bank
Currency
Amount
ROE
Amount In ([Base1 Currency code])
Cheque Status
Cheque Name
Action [Create, Modified, Deleted]
Action User           

SQL

Actions #6

Updated by Anil KV 8 months ago

  • Status changed from New to Ready for Coding
  • % Done changed from 0 to 20
Actions #7

Updated by Junaid M 8 months ago

  • Assignee changed from travvise Admin to Bertin Joseph
Actions #8

Updated by Bertin Joseph 8 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions #9

Updated by Bertin Joseph 8 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60

Updated by Arathy PS 8 months ago

  • Status changed from Coding Done to Testing Started

ISSUE FOUNDED:
1)FIXED - FIX THE ISSUE WITH LOG TAB
2)FIXED - REFRESH THE DATA ON CLICKING THE NEW BUTTON
3)FIXED - CLEAR THE POP UP SEARCH FIELD UPON CLOSING IT

Updated by Arathy PS 7 months ago

  • Status changed from Testing Started to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to Arathy PS

ISSUE FOUNDED
1)FIXED - ADJUST THE ALIGNMENT OF LOG DETAILS IN LOG TAB
2)FIXED - MAKE THE TITLES OF LOG DETAILS BOLD IN THE PRINT
3)FIXED - ADJUST THE SPACING OF TITLES IN PRINT
4)FIXED - REMOVE THE EXTRA TABLE TITLES APPEARING ON THE PRINT
5)FIXED - CHANGE DOCUMENT NO: TO DOC NO IN DOCUMENT DETAILS TAB

Updated by unnikannan S 7 months ago

ISSUE FOUNDED

1.FIXED - Show Print Pop Up Data List Wise
(Reffer Other Querys)

Actions #13

Updated by Bertin Joseph 6 months ago

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

Updated by Arathy PS 6 months ago

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

GUI ENHANCEMENT
------------------------
The search pop up should be disabled and after clicking search button and data appears the search button should change to reset button.
DONE - Pop Up-UI set as Shared module

Actions #15

Updated by Bertin Joseph 5 months ago

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

Updated by unnikannan S 5 months ago

  • Status changed from New Changes Coding Done to Reopen Bugs
  • % Done changed from 70 to 50
  • Tested By changed from Arathy PS to unnikannan S

ISSUE FOUNDED

1)FIXED - Freeze The Cheque No Field In Search Pop Up After Shown Data
2)FIXED - Correct The Search Pop Up Alignment Refer(Received Cheque Query)
3)(Requires data to be received from Bank Reconciliation) - Show Clear Date,Reco No In UI

Actions #17

Updated by Bertin Joseph 5 months ago

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

Updated by Theja Ponon 5 months ago

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

Updated by Theja Ponon 5 months ago

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

Updated by Theja Ponon 5 months ago

  • Status changed from Coding Done to Reopen Bugs Coding Done
  • % Done changed from 60 to 70
Actions #21

Updated by Theja Ponon 4 months ago

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

Updated by Arathy PS 3 months ago

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

ISSUE FOUND
--------------------------------------------------
1.Reco details not get removed after removing the cheque from reco document.--need to fix bank reconcillation module

Actions #23

Updated by Arathy PS 3 months ago

  • Assignee changed from Bertin Joseph to Sreeranjini T
Actions #24

Updated by Sreeranjini T 3 months ago

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

Updated by Theja Ponon 3 months ago

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

Updated by Arathy PS 2 months ago

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

NEW CHANGES
--------------------------------------------
1. Add redirection to the cheque no: and related documents in document tab.

Actions #27

Updated by Sreeranjini T 2 months ago

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

Updated by Theja Ponon 2 months ago

  • Status changed from New Changes Coding Done to New Changes Testing Done
  • % Done changed from 70 to 90

Updated by Arathy PS 27 days ago

  • Status changed from New Changes Testing Done to New Changes
  • % Done changed from 90 to 50

NEW CHANGES DONE
---------------------------
1. Add a new drop down label near the search field and in the drop down show NO:, Date, Issued bank (Doc no:, Doc date, Amount) of how many cheques are there with same cheque no:

Actions #30

Updated by Sreeranjini T 21 days ago

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

Updated by Theja Ponon 20 days ago

Issue Fixed
-----------
1)on searching

Actions #32

Updated by Sreeranjini T 19 days ago

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

Updated by Arathy PS 8 days ago

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

ISSUE FIXED
----------------------
1. No data appearing in log tab (two same cheque no: with different banks-no log for both of them)
2. Data of other cheque (with same cheque no: but different bank) is also showing in the document tab.

Actions #34

Updated by Sreeranjini T 2 days 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