Project

General

Profile

Edit Copy Actions

Feature #156

open

Transaction Summary Report

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

Status:
New Changes Coding Done
Priority:
Normal
Assignee:
Target version:
Start date:
02/21/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Financial Summary
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Financial Summary


Add

Subtasks


Add

Related issues

Actions #1

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

Actions #3

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
Actions #4

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 
Actions #6

Updated by Anil KV over 1 year ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions #7

Updated by Junaid M over 1 year ago

  • Assignee changed from travvise Admin to Amal Siby
Actions #8

Updated by Amal Siby over 1 year ago

  • Status changed from Open to Coding Started
  • % Done changed from 10 to 40
Actions #9

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.

Actions #12

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

Actions #14

Updated by Junaid M over 1 year ago

  • Assignee changed from Amal Siby to Shahil Haris
Actions #15

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

TESTING DONE

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

Actions #18

Updated by Shahil Haris over 1 year ago

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

Updated by unnikannan S over 1 year ago

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

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

Actions #22

Updated by Shahil Haris over 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
Actions #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
Actions #24

Updated by Anil KV over 1 year ago

  • Assignee changed from Shahil Haris to Athul P
Actions #25

Updated by Junaid M about 1 year ago

  • Assignee changed from Athul P to Vivekp V

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

Actions #29

Updated by unnikannan S 6 months ago

  • Status changed from Reopen Bugs Coding Done to Testing Done
  • % Done changed from 70 to 90

Updated by Theja Ponon 20 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

Actions #31

Updated by Theja Ponon 20 days ago

  • Assignee changed from Vivekp V to Athira KK
Actions #32

Updated by Athira KK 19 days ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70
Edit Copy Actions

Also available in: Atom PDF