Feature #156
openTransaction Summary Report
Added by Anil KV about 2 years ago. Updated 20 days ago.
70%
Subtasks
Related issues
Updated by Junaid M almost 2 years ago
- Assignee changed from Junaid M to Christy Saint
Updated by Christy Saint almost 2 years ago
- Status changed from New to Coding Started
- % Done changed from 0 to 40
On holding
Updated by Junaid M almost 2 years ago
- Status changed from Coding Started to Open
- Assignee changed from Christy Saint to Junaid M
- % Done changed from 40 to 10
Updated by Anil KV over 1 year ago
- Status changed from Open to New
- Assignee changed from Junaid M to travvise Admin
- % Done changed from 10 to 0
Updated by Junaid M over 1 year ago
Query
SELECT fk_main_ledger_id, MIN(pk_account_id) AS pk_account_id, MIN(pk_transaction_id) AS pk_transaction_id, vhr_account_code,vhr_account_name, vhr_code as vhr_ml_code, vhr_name as vhr_ml_name, vhr_display_name, SUM(dbl_amount_dr) AS dbl_amount_dr, SUM(dbl_amount_cr) AS dbl_amount_cr, SUM(dbl_amount_ob_dr) AS dbl_amount_ob_dr, SUM(dbl_amount_ob_cr) AS dbl_amount_ob_cr FROM (SELECT ac.pk_account_id, ac.vhr_account_code, ac.vhr_account_name, tr.pk_transaction_id, tr.vhr_ledg_currency, tr.vhr_base_currency, tr.vhr_cons_currency, tr.fk_main_ledger_id, coa.vhr_code, coa.vhr_name, ac.vhr_display_name, 0.00 AS dbl_amount_dr, 0.00 AS dbl_amount_cr, tr.dbl_ledg_cur_debit AS dbl_amount_ob_dr, tr.dbl_ledg_cur_credit AS dbl_amount_ob_cr FROM transaction.tbl_transaction AS tr LEFT JOIN accounts.tbl_account AS ac ON tr.fk_ledger_id = ac.pk_account_id LEFT JOIN accounts.tbl_chart_of_ac AS coa ON coa.pk_chart_of_ac_id = tr.fk_main_ledger_id LEFT JOIN document.tbl_documents AS doc ON doc.pk_documents_id = tr.fk_documents_id --WHERE CONDITION OB DATA (Only Date Filter is different) UNION ALL SELECT ac.pk_account_id, ac.vhr_account_code, ac.vhr_account_name, tr.pk_transaction_id, tr.vhr_ledg_currency, tr.vhr_base_currency, tr.vhr_cons_currency, tr.fk_main_ledger_id, coa.vhr_code, coa.vhr_name, ac.vhr_display_name, dbl_ledg_cur_debit AS dbl_amount_dr, dbl_ledg_cur_credit AS dbl_amount_cr, 0.00 AS dbl_amount_ob_dr, 0.00 AS dbl_amount_ob_cr FROM transaction.tbl_transaction as tr LEFT JOIN accounts.tbl_account as ac ON tr.fk_ledger_id = ac.pk_account_id LEFT JOIN accounts.tbl_chart_of_ac as coa ON coa.pk_chart_of_ac_id = tr.fk_main_ledger_id LEFT JOIN document.tbl_documents as doc ON doc.pk_documents_id = tr.fk_documents_id --WHERE CONDITION CURRENT DATA ) As tmp GROUP BY fk_main_ledger_id, vhr_account_code, vhr_account_name, vhr_code, vhr_name, vhr_display_name ORDER BY pk_account_id, fk_main_ledger_id
Updated by Anil KV over 1 year ago
- Status changed from New to Open
- % Done changed from 0 to 10
Updated by Junaid M over 1 year ago
- Assignee changed from travvise Admin to Amal Siby
Updated by Amal Siby over 1 year ago
- Status changed from Open to Coding Started
- % Done changed from 10 to 40
Updated by Amal Siby over 1 year ago
- 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
ISSUE FOUNDED
1.SHOWING OPENING BALANCE US NET IN GRID
2.MAIN LEDGER FILTER TAB NOT WORKING
3.ACCOUNT CATEGORY WISE FILTER NOT WORKING
4.SHOWING ALL BALANCE AMOUNT US NET AMOUNT IN PRINT
Updated by Amal Siby over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Reported Bug Fixed.
Updated by unnikannan S over 1 year ago
- Subject changed from Financial Summary to Transaction Summary Report
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 DATA AS PER CHOOSEN ACCOUNT CATEGORY
2.SHOW NO DATA FOUND MESSAGE
Updated by Junaid M over 1 year ago
- Assignee changed from Amal Siby to Shahil Haris
Updated by Shahil Haris 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.SHOW VALID DATA AS PER ACCOUNT CATEGORY FILTER SEARCH
Updated by Shahil Haris 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
Updated by Shahil Haris 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.SHOWING PRINT AS BLANK WHILE GROUPING WITH MAIN LEDGER
2.SHOW DATA AS PER CHOOSEN TRANSACTION DATE
Updated by Shahil Haris 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
Updated by Anil KV over 1 year ago
- Assignee changed from Shahil Haris to Athul P
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
ISSUE FIXED
1.SHOWING PRINT AS BLANK WHILE GROUPING WITH MAIN LEDGER
2.SHOW DATA AS PER CHOOSEN TRANSACTION DATE
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUNDED
1.ADJUST ALLIGMENTS BETWEEN UI FIELDS IN CASE OF EXPANDING
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
ISSUE FIXED
1.ADJUST ALLIGMENTS BETWEEN UI FIELDS IN CASE OF EXPANDING
Updated by Theja Ponon 21 days ago
- Status changed from Testing Done to New Changes
- % Done changed from 90 to 50
New Change
-----------
1)Remove ledger from grouping type
2)Add Mainledger/coa , no grouping(show in defualt) in grouping type