Feature #220
openProfit Flow Report
70%
Subtasks
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
Updated by Anil KV over 1 year ago
- Status changed from New to Open
- % Done changed from 0 to 10
Updated by Anil KV over 1 year ago
- Assignee changed from travvise Admin to Karthika V Anand
Updated by Karthika V Anand over 1 year ago
- Status changed from Open to Coding Started
- % Done changed from 10 to 40
Updated by Karthika V Anand over 1 year ago
- Status changed from Coding Started to Particialy Coding Done
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)
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 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 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 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.
Updated by Sreeranjini T about 1 month ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70