Project

General

Profile

Edit Copy Actions
Copy link

Feature #218

open

Paid Cheque Query

Added by Junaid M almost 2 years ago. Updated about 1 month ago.

Status:
Reopen Bugs Testing Done
Priority:
Normal
Assignee:
Sreeranjini T
Target version:
22.12
Start date:
06/27/2023
Due date:
% Done:

90%

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

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

QuoteActions
Copy link
 #1

Updated by Anil KV 10 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

QuoteActions
Copy link
 #2

Updated by Anil KV 10 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)

QuoteActions
Copy link
 #3

Updated by Anil KV 10 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

QuoteActions
Copy link
 #4

Updated by Anil KV 10 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

QuoteActions
Copy link
 #5

Updated by Anil KV 10 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
Copy link
 #6

Updated by Anil KV 10 months ago

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

Updated by Junaid M 10 months ago

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

Updated by Bertin Joseph 10 months ago

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

Updated by Bertin Joseph 9 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60
QuoteActions
Copy link
 #10

Updated by Arathy PS 9 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

QuoteActions
Copy link
 #11

Updated by Arathy PS 9 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

QuoteActions
Copy link
 #12

Updated by unnikannan S 8 months ago

ISSUE FOUNDED

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

Actions
Copy link
 #13

Updated by Bertin Joseph 7 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #14

Updated by Arathy PS 7 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
Copy link
 #15

Updated by Bertin Joseph 7 months ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #16

Updated by unnikannan S 7 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
Copy link
 #17

Updated by Bertin Joseph 7 months ago

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

Updated by Theja Ponon 6 months ago

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

Updated by Theja Ponon 6 months ago

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

Updated by Theja Ponon 6 months ago

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

Updated by Theja Ponon 6 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90
QuoteActions
Copy link
 #22

Updated by Arathy PS 5 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
Copy link
 #23

Updated by Arathy PS 5 months ago

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

Updated by Sreeranjini T 5 months ago

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

Updated by Theja Ponon 5 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90
QuoteActions
Copy link
 #26

Updated by Arathy PS 4 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
Copy link
 #27

Updated by Sreeranjini T 4 months ago

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

Updated by Theja Ponon 4 months ago

  • Status changed from New Changes Coding Done to New Changes Testing Done
  • % Done changed from 70 to 90
QuoteActions
Copy link
 #29

Updated by Arathy PS 2 months 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
Copy link
 #30

Updated by Sreeranjini T 2 months ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #31

Updated by Theja Ponon 2 months ago

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

Actions
Copy link
 #32

Updated by Sreeranjini T 2 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #33

Updated by Arathy PS about 2 months 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
Copy link
 #34

Updated by Sreeranjini T about 2 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #35

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 FIXED
---------------------------
1.FIXED - No redirection from cheque no: when the document is reconciled.
2.FIXED- Reco no: is showing for document that doesn't have reconciliation done - Need to fix from payment

Actions
Copy link
 #36

Updated by Sreeranjini T about 1 month ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #37

Updated by Theja Ponon about 1 month ago

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

Issue fixed
---------
1)In the cheque search popup data will generate without checking the branch

Actions
Copy link
 #38

Updated by Sreeranjini T about 1 month ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #39

Updated by Theja Ponon about 1 month ago

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

Issue Fixed
-----------
1)Date is not showing in log tab

Actions
Copy link
 #40

Updated by Sreeranjini T about 1 month ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions
Copy link
 #41

Updated by Theja Ponon about 1 month ago

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

Also available in: Atom PDF