Feature #259
openLedger Comparison Report
Start date:
07/09/2023
Due date:
% Done:
90%
Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Ledger Comparison Report
Tested By:
unnikannan S
Code Reviewed By:
Files
Subtasks
Related issues
Updated by Anil KV over 1 year ago
- File Ledger Comparison Report_GUI_CHANGE.jpeg Ledger Comparison Report_GUI_CHANGE.jpeg added
- Status changed from New to Open
- Assignee changed from travvise Admin to Baseem Shan
- % Done changed from 0 to 10
GUI Change
-Check the attachment image
Updated by Anil KV over 1 year ago
SQL
SELECT fk_main_ledger_id, fk_ledger_id, TO_CHAR(dat_transaction, 'Month') AS str_month, TO_CHAR(dat_transaction, 'YYYY') AS str_year, SUM(dbl_ledg_cur_debit) AS dbl_debit, SUM(dbl_ledg_cur_credit) AS dbl_credit FROM transaction.tbl_transaction WHERE sin_posting_status = 1 AND sin_transaction_status = 1 AND sin_document_status = 1 AND vhr_ledg_currency = 'QAR' ... GROUP BY fk_main_ledger_id, fk_ledger_id, str_month, str_year; * Base1 Currency case SUM(dbl_base_cur_debit) AS dbl_debit, SUM(dbl_base_cur_credit) AS dbl_credit -No filter Currency wise
Updated by Baseem Shan over 1 year ago
- Status changed from Open to Coding Started
- % Done changed from 10 to 40
Updated by Baseem Shan over 1 year ago
- Description updated (diff)
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
Updated by unnikannan S over 1 year ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to unnikannan S
Updated by Baseem Shan 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
FIXED - 1.SHOWING CREDIT AMOUNT AS DEBIT
FIXED - 2.SHOWING INCORRECT MONTHLY QUARTER AMOUNT
FIXED - 3.CLEAR ACCOUNT FILTER DATA WHILE SELECTING DROP DOWN
FIXED - 4.SHOWING FALSE AMOUNT WHILE SEARCH WITH BASE 1 CURRENCY
5.DONT FREEZE SEARCH BUTTON (Already Freezing Drop Downs After Getting Data So Dont Need To Disable The Button)
Updated by Baseem Shan about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60