Feature #165: Bank Reconciliation - TAAS - Redmine

Custom queries

All Works In Current Sprint
Issues assigned to me Clear
My Works In Current Sprint
Reported issues
Updated issues
Watched issues

Add

Watchers (7)

Junaid M Delete
Akash B Delete
Aparna Mathew Delete
unnikannan S Delete
Anil KV Delete
Vivekp V Delete
Arathy PS Delete

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

Issue # Delay: days Cancel

History
Notes
Property changes

Actions

Copy link

Updated by Junaid M almost 2 years ago

Status changed from New to Open
% Done changed from 0 to 10

Actions

Copy link

Updated by Junaid M almost 2 years ago

File QUERY-BANK-RECO-MASTER-SUMMARY.sql added

Actions

Copy link

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

Updated by Akash B almost 2 years ago

Status changed from New to Coding Started
% Done changed from 0 to 40

Actions

Copy link

Updated by Junaid M almost 2 years ago

File deleted (~~QUERY-BANK-RECO-MASTER-SUMMARY.sql~~)

Actions

Copy link

Updated by Junaid M almost 2 years ago

File BANK-RECO-SUMMARY.SQL BANK-RECO-SUMMARY.SQL added

Actions

Copy link

Updated by Junaid M over 1 year ago

Assignee changed from Akash B to Aparna Mathew

Actions

Copy link

Updated by Aparna Mathew 7 months ago

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

QuoteActions

Copy link

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:

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

File clipboard-202411271151-rbigd.png clipboard-202411271151-rbigd.png added
Status changed from Reopen Bugs Coding Done to Reopen Bugs
% Done changed from 70 to 50

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

File clipboard-202412111202-z80nr.png clipboard-202412111202-z80nr.png added
Status changed from Reopen Bugs Coding Done to Reopen Bugs
% Done changed from 70 to 50

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

File clipboard-202502281507-kxqfd.png clipboard-202502281507-kxqfd.png added
Status changed from Reopen Bugs Coding Done to Reopen Bugs
% Done changed from 70 to 50

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

File clipboard-202503171650-d8iqm.png clipboard-202503171650-d8iqm.png added
Status changed from Reopen Bugs Coding Done to Reopen Bugs
% Done changed from 70 to 50

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

Edit Copy Actions

Copy link

Edit

Notes

Files

(Maximum size: 5 MB)

Cancel

Also available in: Atom PDF

Project

General

Profile

TAAS

Custom queries

Watchers (7)

Feature #165

Bank Reconciliation

Updated by Junaid M almost 2 years ago

Updated by Junaid M almost 2 years ago

Updated by Junaid M almost 2 years ago

Updated by Akash B almost 2 years ago

Updated by Junaid M almost 2 years ago

Updated by Junaid M almost 2 years ago

Updated by Junaid M over 1 year ago

Updated by Aparna Mathew 7 months ago

Updated by unnikannan S 7 months ago

Updated by Aparna Mathew 7 months ago

Updated by unnikannan S 7 months ago

Updated by unnikannan S 7 months ago

Updated by Aparna Mathew 7 months ago

Updated by unnikannan S 5 months ago

Updated by Aparna Mathew 5 months ago

Updated by Anil KV 5 months ago

Updated by Aparna Mathew 5 months ago

Updated by Anil KV 4 months ago

Updated by Vivekp V 4 months ago

Updated by unnikannan S 4 months ago

Updated by Vivekp V 4 months ago

Updated by Arathy PS 3 months ago

Updated by Vivekp V 3 months ago

Updated by Arathy PS 3 months ago

Updated by Vivekp V 3 months ago

Updated by unnikannan S 3 months ago

Updated by Arathy PS 2 months ago

Updated by Vivekp V about 2 months ago

Updated by Arathy PS 18 days ago

Updated by Vivekp V 15 days ago

Updated by Arathy PS 1 day ago

Edit