Feature #259
open
Added by Anil KV over 1 year ago.
Updated 6 months ago.
Module:
Ledger Comparison Report
Description
Module Widget Data Source Pending...
Files
GUI Change
-Check the attachment image
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
- Status changed from Open to Coding Started
- % Done changed from 10 to 40
- Description updated (diff)
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to unnikannan S
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
- 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)
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
- Status changed from Reopen Bugs Coding Done to Testing Done
- % Done changed from 70 to 90
Also available in: Atom
PDF