Project

General

Profile

Edit Copy Actions
Copy link

Feature #165

open

Bank Reconciliation

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

Status:
Reopen Bugs
Priority:
Normal
Assignee:
Vivekp V
Target version:
22.12
Start date:
02/25/2023
Due date:
% Done:

50%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Bank Reconciliation
Tested By:
unnikannan S
Code Reviewed By:
Quote

Description

Coding Bank Reconciliation

Files

Download all files
BANK-RECO-SUMMARY.SQL (8.24 KB) BANK-RECO-SUMMARY.SQL Junaid M, 05/26/2023 05:38 PM
clipboard-202411271151-rbigd.png (114 KB) clipboard-202411271151-rbigd.png unnikannan S, 11/27/2024 11:51 AM
clipboard-202412111202-z80nr.png (105 KB) clipboard-202412111202-z80nr.png Arathy PS, 12/11/2024 12:03 PM
clipboard-202502281507-kxqfd.png (133 KB) clipboard-202502281507-kxqfd.png Arathy PS, 02/28/2025 03:07 PM
clipboard-202503171650-d8iqm.png (122 KB) clipboard-202503171650-d8iqm.png Arathy PS, 03/17/2025 04:50 PM
Add

Subtasks

Add

Related issues

Actions
Copy link
 #1

Updated by Junaid M almost 2 years ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions
Copy link
 #2

Updated by Junaid M almost 2 years ago

  • File QUERY-BANK-RECO-MASTER-SUMMARY.sql added
Actions
Copy link
 #3

Updated by Junaid M almost 2 years ago

  • Status changed from Open to New
  • Assignee changed from Junaid M to Akash B
  • % Done changed from 10 to 0
Actions
Copy link
 #4

Updated by Akash B almost 2 years ago

  • Status changed from New to Coding Started
  • % Done changed from 0 to 40
Actions
Copy link
 #5

Updated by Junaid M almost 2 years ago

  • File deleted (QUERY-BANK-RECO-MASTER-SUMMARY.sql)
Actions
Copy link
 #7

Updated by Junaid M over 1 year ago

  • Assignee changed from Akash B to Aparna Mathew
Actions
Copy link
 #8

Updated by Aparna Mathew 7 months ago

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

Updated by unnikannan S 7 months ago

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

ISSUE FOUNDED

1.Error On Deletion
2.Freeze Doc no Part After Save
3.Validate Doc Date And Status
4.Allow Numbers Only In Amount Field
5.Change Name OB To Opening Balance In List
6.Clear Date Show As DD/MM/YEAR Format In List
7.Show Amount In List As Right Allign
8.Precision Value Missing On Update

Actions
Copy link
 #10

Updated by Aparna Mathew 7 months ago

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

Updated by unnikannan S 7 months ago

TESTING DONE

QuoteActions
Copy link
 #12

Updated by unnikannan S 7 months ago

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

ISSUE FOUNDED

1.Error On Updation While Adding Decimal Value On Summary
2.Not Working Attachment File Upload
3.Missing Reco No From Cleared Doc

Actions
Copy link
 #13

Updated by Aparna Mathew 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 unnikannan S 5 months ago

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

ISSUE FOUNDED

1.Load Branch Default On UI

Actions
Copy link
 #15

Updated by Aparna Mathew 5 months ago

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

Updated by Anil KV 5 months ago

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

Recode the module
some issues in work flow

QuoteActions
Copy link
 #17

Updated by Aparna Mathew 5 months ago

Summary Tab -> Items:

1.Opening Balance (OB)
- 2.Debit
3.Credit
4.Closing Balance
5.Expected Posting(Paid Cheque Control Account)
6.Uncleared Received Cheque
7.Uncleared Paid Cheque
-------------------
Summary Tab -> Cleared:

Cleared + Current Document Ticked Items
(Cleared means Already cleared from other documents)

ISSUE FOUND
--------------------
1.Clear Date,Reconciliation no should received from reco to paid cheque query
2.delete option is only needed in edit mode

Actions
Copy link
 #18

Updated by Anil KV 4 months ago

  • Assignee changed from Aparna Mathew to Vivekp V
QuoteActions
Copy link
 #19

Updated by Vivekp V 4 months ago

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

bug fix done
Summary Tab -> Items:

1.Opening Balance (OB)
- 2.Debit
3.Credit
4.Closing Balance
5.Expected Posting(Paid Cheque Control Account)
6.Uncleared Received Cheque
7.Uncleared Paid Cheque
-------------------
Summary Tab -> Cleared:

Cleared + Current Document Ticked Items
(Cleared means Already cleared from other documents)

ISSUE FOUND
--------------------
1.Clear Date,Reconciliation no should received from reco to paid cheque query
2.delete option is only needed in edit mode

Actions
Copy link
 #20

Updated by unnikannan S 4 months ago

Actions
Copy link
 #21

Updated by Vivekp V 4 months ago

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

Updated by Arathy PS 3 months ago

ISSUE FIXED
----------------------------------------
1. Data showing in cleared tab for a document no: that is reco first then the said reco is deleted.

2. Status of the cleared documents not changing to previous one when we remove the document in edit mode.

Actions
Copy link
 #23

Updated by Vivekp V 3 months ago

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

Updated by Arathy PS 3 months ago

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

NEW CHANGES DONE
-----------------------------------------
copy vhr_reco_no, dat_clear from
received cheque details and paid cheque details to received cheQue and paid cheque tables and update them through bank reco.

Actions
Copy link
 #25

Updated by Vivekp V 3 months ago

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

Updated by unnikannan S 3 months ago

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

Updated by Arathy PS 2 months ago

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

ISSUE FIXED
----------------------
1. Bank name is not showing in the document search modules party column.

Actions
Copy link
 #28

Updated by Vivekp V about 2 months ago

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

Updated by Arathy PS 18 days ago

ISSUE FIXED
---------------------
1. Error message not clearing after showing data.
2. Upon deleting a reco amount in difference is not clearing.
3. Can save a reco without any data in it.

Actions
Copy link
 #30

Updated by Vivekp V 15 days ago

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

Updated by Arathy PS 1 day ago

ISSUE FOUND
----------------------------
1. Data not showing in the 'Uncleared Paid Cheque'.
2. Data in difference section

Edit Copy Actions
Copy link

Also available in: Atom PDF