Project

General

Profile

Edit Copy Actions
Copy link

Feature #137

open

Outstanding Document Report

Added by Anil KV about 2 years ago. Updated 7 days ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Sreeranjini T
Target version:
22.12
Start date:
02/02/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Outstanding Document Report
Tested By:
unnikannan S
Code Reviewed By:
Quote

Description

Coding Outstanding Document Report

Files

Download all files
SQL-OUTSTANDING-DOCUMENT.SQL (1.39 KB) SQL-OUTSTANDING-DOCUMENT.SQL Junaid M, 02/21/2023 08:51 PM
clipboard-202503061146-otdpe.png (75.6 KB) clipboard-202503061146-otdpe.png Arathy PS, 03/06/2025 11:46 AM
Add

Subtasks

Add

Related issues

Actions
Copy link
 #1

Updated by Junaid M about 2 years ago

Actions
Copy link
 #2

Updated by Junaid M about 2 years ago

  • Assignee changed from Junaid M to Akash B
Actions
Copy link
 #3

Updated by Akash B about 2 years ago

  • Status changed from Open to Coding Started
  • % Done changed from 10 to 40
Actions
Copy link
 #4

Updated by Akash B about 2 years ago

  • Status changed from Coding Started to Particialy Coding Done
Actions
Copy link
 #5

Updated by Akash B about 2 years ago

  • Status changed from Particialy Coding Done to Coding Done
  • % Done changed from 40 to 60
QuoteActions
Copy link
 #6

Updated by Amal Cyriac about 2 years ago

  • Status changed from Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to Amal Cyriac

ISSUE FOUND *****
1.Rearrange coloumns
(customer= CODE:NAME)
2.Document code must be display in grid
3.Fix bugs on currency
(42601: syntax error at or near "GREATEST") base 1 & 2
4.Resize columns

Actions
Copy link
 #7

Updated by Akash B about 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #8

Updated by Amal Cyriac about 2 years ago

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

ISSUE FOUND *****
1.Debit & Credit check box filters not working
(Report must be sorted depend on check box)

Actions
Copy link
 #9

Updated by Akash B about 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #10

Updated by Amal Cyriac about 2 years ago

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

ISSUE FOUND *****
1.Debit & Credit check box filters not working
(Report must be sorted depend on check box)
2.Fix error while choosing Base 1 & 2 currency (TS.)
3.Add precision on grid

QuoteActions
Copy link
 #11

Updated by Akash B almost 2 years ago

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

Bug Fixed

QuoteActions
Copy link
 #12

Updated by Junaid M almost 2 years ago

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

Modify Amount Column as
Opening Balance | Dr Outstanding | Cr Outstanding | Matched | Net Balance | Closing Balance

QuoteActions
Copy link
 #13

Updated by Akash B almost 2 years ago

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

Changes Applied...

QuoteActions
Copy link
 #14

Updated by unnikannan S over 1 year ago

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

1.while Searching Column 'fk_documents_id' does not belong to table Table.

QuoteActions
Copy link
 #15

Updated by Akash B over 1 year ago

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

outstanding Document report query changes
Select query MIN As fk_documents_id, added
binTransactionId in TS Model Changes to binDocumentId
Status On Where Query changes----posting status and document number added on where condition

QuoteActions
Copy link
 #16

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.1.ADD DR,CR IN NET BALANCE CLOSING BALANCE AND OPENING BALANCE (-VE AMOUNT-CR,+VE AMOUNT DR)

QuoteActions
Copy link
 #17

Updated by Akash B over 1 year ago

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

bugs Fixed

QuoteActions
Copy link
 #18

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.CORRECT THE ALLIGMENT OPENING BALANCE LEFT TO RIGHT
2.NOT SHOWING NET BALANCE
3.SHOWING ALL AMOUNT US DEBIT

QuoteActions
Copy link
 #19

Updated by Akash B over 1 year ago

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

Bugs Fixed

QuoteActions
Copy link
 #20

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.Issue In Amount Matched
2.Not Showing Data While Adding Blank Option
3.Show Data That Act Us Customer And Supplier In Filteration Tab

Actions
Copy link
 #21

Updated by Akash B over 1 year ago

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

Updated by Junaid M over 1 year ago

GUI CHANGE -> Remove Ob Column

QuoteActions
Copy link
 #23

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.ENQUIRY,XO WISE SEARCH FILTERING NOT WORKING

Actions
Copy link
 #24

Updated by Junaid M over 1 year ago

  • Assignee changed from Akash B to Vivekp V
QuoteActions
Copy link
 #25

Updated by Vivekp V over 1 year ago

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

issues fixed
1.ENQUIRY,XO WISE SEARCH FILTERING NOT WORKING, THIS FILTERING WAS REMOVED

QuoteActions
Copy link
 #26

Updated by unnikannan S over 1 year ago

TESTING DONE

QuoteActions
Copy link
 #27

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 AMOUNT IN MATCHED

QuoteActions
Copy link
 #28

Updated by Vivekp V over 1 year ago

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

ISSUE FIXED

1.SHOWING AMOUNT IN MATCHED

QuoteActions
Copy link
 #29

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.SHOW DOCUMENTS US PER CHOOSEN MODULES IN FILTER

Actions
Copy link
 #30

Updated by Vivekp V over 1 year ago

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

Updated by unnikannan S over 1 year ago

TESTING DONE

QuoteActions
Copy link
 #32

Updated by unnikannan S about 1 year ago

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

ISSUE FOUNDED

FIXED - 1.CLEAR THOSE DOCUMENTS THERE FULL SETTLEMENT IS DONE
FIXED - 2.CORRECT THE NET BALANCE AMOUNT AFTER MATCHING
FIXED - 3.SHOW MATCHING COLUMN IN PRINT LIST
FIXED - 4.HIDE RESET BUTTON AND SHOW IT IN CASE OF SHOWING LIST IN UI

Actions
Copy link
 #33

Updated by Junaid M about 1 year ago

  • Assignee changed from Vivekp V to Baseem Shan
Actions
Copy link
 #34

Updated by Baseem Shan about 1 year ago

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

Updated by unnikannan S about 1 year ago

TESTING DONE

QuoteActions
Copy link
 #36

Updated by unnikannan S about 1 year ago

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

ISSUE FOUNDED

FIXED - 1.CONSIDER ACT AS CUSTOMER,SUPPLIER ACCOUNTS IN FILTER FIELD

Actions
Copy link
 #37

Updated by Baseem Shan about 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #38

Updated by unnikannan S about 1 year ago

TESTING DONE

QuoteActions
Copy link
 #39

Updated by Avinash MS 7 months ago

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

GUI Change
-----------------------------------------------------------------
FIXED - Service Date As on [Checkbox(Untick) + Date Picker(Disable)
FIXED - Date Picker and table title -> Travel Date done before The Date
FIXED - Checkbox Title -> Tick then the date mandatory(Default Load To Date)

Actions
Copy link
 #40

Updated by Baseem Shan 6 months ago

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

Updated by Avinash MS 6 months ago

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

Updated by Arathy PS about 2 months ago

  • Assignee changed from Baseem Shan to Sreeranjini T
QuoteActions
Copy link
 #43

Updated by Arathy PS 12 days ago

ISSUE FOUND
-------------------------
1. Add redirection to the document no:
2. Doc no: of the party that had an AR sharing done is wrong.

Actions
Copy link
 #44

Updated by Sreeranjini T 7 days ago

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

Also available in: Atom PDF