Project

General

Profile

Edit Copy Actions

Feature #220

open

Profit Flow Report

Added by Anil KV over 1 year ago. Updated about 1 month ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Target version:
Start date:
07/09/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Profit Flow Report
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Profit Flow Report


Add

Subtasks


Add

Related issues

Updated by Anil KV over 1 year ago

GUI Changes
1) Account - title=Income and Expense Account Only
2) Menu move to Management report Last
3) Add Grouping Selectbox in Grid Title bar -
-No Grouping
-Module Wise(Default)
List Data
1) SQL

 SELECT tr.vhr_sys_module_name,
         tr.fk_ledger_id,
         MIN(ac.vhr_account_code) AS vhr_account_code,
        MIN(ac.vhr_account_name) AS vhr_account_name,

        SUM(tr.dbl_ledg_cur_debit) AS dbl_ledg_cur_debit,
        SUM(tr.dbl_ledg_cur_credit) AS dbl_ledg_cur_credit,

        SUM(tr.dbl_base_cur_debit) AS dbl_base_cur_debit,
        SUM(tr.dbl_base_cur_credit) AS dbl_base_cur_credit,

        SUM(tr.dbl_cons_cur_debit) AS dbl_cons_cur_debit,
        SUM(tr.dbl_cons_cur_credit) AS dbl_cons_cur_credit
FROM transaction.tbl_transaction tr
LEFT JOIN accounts.tbl_account ac
    ON tr.fk_ledger_id = ac.pk_account_id
WHERE tr.sin_posting_status = 1
    AND tr.sin_transaction_status = 1
    AND tr.sin_document_status  = 1
    AND tr.dat_transaction BETWEEN '2023-01-01' AND '2023-12-31'
    AND tr.fk_branch_id IN (1)
    AND tr.fk_department_id IN (1)
        AND tr.vhr_ledg_currency =
    AND ac.sin_ac_category IN (3,4)
        ....
GROUP BY vhr_sys_module_name, fk_ledger_id

- Amount Filed use based on selected currency
- Where change based on inputs

Actions #2

Updated by Anil KV over 1 year ago

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

Updated by Anil KV over 1 year ago

  • Assignee changed from travvise Admin to Karthika V Anand
Actions #4

Updated by Karthika V Anand over 1 year ago

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

Updated by Karthika V Anand over 1 year ago

  • Status changed from Coding Started to Particialy Coding Done
Actions #6

Updated by Karthika V Anand over 1 year ago

  • Status changed from Particialy Coding Done 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 DATA WITHOUT ADDING MANDATORY FIELD (STATUS)

Actions #8

Updated by Karthika V Anand 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

Actions #10

Updated by Junaid M over 1 year ago

  • Assignee changed from Karthika V Anand to Vivekp V

Updated by Vivekp V over 1 year ago

issues fixed
1.on new button click status field becomes empty
2. searching with all branches causes {} symbol error to occur

Updated by unnikannan S over 1 year ago

TESTING DONE

Updated by Seema Mathew over 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By changed from unnikannan S to Seema Mathew

ISSUE FOUNDED****

1.NOT SHOWING QAR IN PRINT.
2.MISSING PRECISION IN LIST

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.NOT SHOWING QAR IN PRINT.
2.MISSING PRECISION IN LIST

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 Seema Mathew to unnikannan S

ISSUE FOUNDED

1.ERROR WHILE CHOOSING PRINT AFTER SEARCH WITH FILTER DATAS

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.ERROR WHILE CHOOSING PRINT AFTER SEARCH WITH FILTER DATAS

Updated by Anonymous over 1 year ago

TESTING DONE

Updated by unnikannan S 12 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUNDED

1.FIX BUGS ON PRINT
2.SHOW DATA AS PER THE SELECTED STATUS IN THE UI

Updated by Vivekp V 12 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

ISSUE FIXED

1.FIX BUGS ON PRINT
2.SHOW DATA AS PER THE SELECTED STATUS IN THE UI

Actions #20

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 Arathy PS about 1 month ago

  • Status changed from Testing Done to Reopen Bugs
  • Assignee changed from Vivekp V to Sreeranjini T
  • % Done changed from 90 to 50

ISSUE FOUND
-----------------------
1. Data related to sale tab is showing only when we select other option in consider field.
2. Not filtering data based on status.

Actions #22

Updated by Sreeranjini T about 1 month ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Edit Copy Actions

Also available in: Atom PDF