Feature #137
openOutstanding Document Report
Added by Anil KV about 2 years ago. Updated 8 days ago.
70%
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 |
Subtasks
Related issues
Updated by Junaid M about 2 years ago
- File SQL-OUTSTANDING-DOCUMENT.SQL SQL-OUTSTANDING-DOCUMENT.SQL added
- Status changed from New to Open
- % Done changed from 0 to 10
Updated by Akash B about 2 years ago
- Status changed from Open to Coding Started
- % Done changed from 10 to 40
Updated by Akash B about 2 years ago
- Status changed from Coding Started to Particialy Coding Done
Updated by Akash B about 2 years ago
- Status changed from Particialy Coding Done to Coding Done
- % Done changed from 40 to 60
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
Updated by Akash B about 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
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)
Updated by Akash B about 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
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
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
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
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...
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.
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
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)
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
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
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
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
Updated by Akash B over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
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
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
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
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
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
Updated by Vivekp V over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
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
Updated by Junaid M about 1 year ago
- Assignee changed from Vivekp V to Baseem Shan
Updated by Baseem Shan about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
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
Updated by Baseem Shan about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
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)
Updated by Baseem Shan 6 months ago
- Status changed from New Changes to New Changes Coding Done
- % Done changed from 50 to 70
Updated by Arathy PS about 2 months ago
- Assignee changed from Baseem Shan to Sreeranjini T
Updated by Arathy PS 12 days ago
- File clipboard-202503061146-otdpe.png clipboard-202503061146-otdpe.png added
- Status changed from Testing Done to Reopen Bugs
- % Done changed from 90 to 50
ISSUE FOUND
-------------------------
1. Add redirection to the document no:
2. Doc no: of the party that had an AR sharing done is wrong.
Updated by Sreeranjini T 8 days ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70