Feature #151
openTrial Balance
Added by Anil KV about 2 years ago. Updated about 1 month ago.
Start date:
02/21/2023
Due date:
% Done:
90%
Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Trial Balance
Tested By:
unnikannan S
Code Reviewed By:
Files
clipboard-202501301122-5ur3z.png (132 KB) clipboard-202501301122-5ur3z.png | Arathy PS, 01/30/2025 11:22 AM |
Subtasks
Related issues
Updated by Anil KV almost 2 years ago
Trial Balance:- =============== Input ------ -> Currency Mandatory[* red] - Base1(***)[Default], Base2(...) -> Posting Status - Rename Posting Status to Status[* red] - Items Posting Status[Group] Active[Tick] Active[Untick] Document Status[Group] Active[Tick] Active[Untick] Expected Transactions[Group] Paid Cheque Control Account Bank Posting[Untick] -> Remove - Columns -> Move Expand to Grid title section - Center - Choose Custome then need a Entrybox - Expand <Selectbox><Entrybox-Somal><Refresh button - only icon> - Group the items(without label) - Upto a word - Add 'No Expand' item in the selectbox - Custome Choose then show the entrybox - Default Select - Upto Main Ledger - Rename "Upto Ledger" to "Upto Main Ledger Sub Items" and View Main Ledger Sub Items check box is untick then desable the item -> Move Expand to Grid title section - Center -> Add Checkbox - "Debit or Credit Net Amount Only"[Title:- Each Section(OB, Current, Closing) Columns(Debit and Credit) Showing Net Amount(Net Amount Credit then Show Dr Column, Net Amount Cr then Show Cr Column)] before "View Main Ledger Sub Items" checkbox List:- ------ -> Add *Net* 3 Columns after each Credit Column -> Need Total[Expand items] -> Add View Details Icon Last -> Load Ledger Stmt or Main Ledger Stmt
Updated by Junaid M almost 2 years ago
- Assignee changed from Junaid M to Akash B
Updated by Anil KV almost 2 years ago
View Main Ledger Sub Items Checkbox OFF case
SELECT ca.pk_chart_of_ac_id, ca.vhr_code, ca.vhr_name, ca.vhr_display_name, ca.fk_parent_chart_of_ac_id, ca.sin_chart_of_ac_category, ca.sin_chart_of_ac_type, ca.sin_main_ledger_category, ca.sin_default_main_ledger, tr.fk_main_ledger_id, tr.dbl_ob_debit, tr.dbl_ob_credit, tr.dbl_debit, tr.dbl_credit FROM accounts.tbl_chart_of_ac ca LEFT JOIN ( SELECT fk_main_ledger_id, SUM(dbl_ob_debit) AS dbl_ob_debit, SUM(dbl_ob_credit) AS dbl_ob_credit, SUM(dbl_debit) AS dbl_debit, SUM(dbl_credit) AS dbl_credit FROM (SELECT fk_main_ledger_id, dbl_ledg_cur_debit AS dbl_ob_debit, dbl_ledg_cur_credit AS dbl_ob_credit, 0.00 AS dbl_debit, 0.00 AS dbl_credit FROM transaction.tbl_transaction WHERE sin_posting_status = 1 AND sin_transaction_status = 1 AND sin_document_status = 1 AND dat_transaction < '2023-01-01' AND fk_branch_id IN (1) AND fk_department_id = 1 UNION ALL SELECT fk_main_ledger_id, 0.00 AS dbl_ob_debit, 0.00 AS dbl_ob_credit, dbl_ledg_cur_debit AS dbl_debit, 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 dat_transaction BETWEEN '2023-01-01' AND '2023-12-31' AND fk_branch_id IN (1) AND fk_department_id = 1) AS tr1 GROUP BY fk_main_ledger_id) AS tr ON ca.pk_chart_of_ac_id = tr.fk_main_ledger_id;
Updated by Anil KV almost 2 years ago
View Main Ledger Sub Items Checkbox ON case
SELECT ca.pk_chart_of_ac_id, ca.vhr_code, ca.vhr_name, ca.vhr_display_name, ca.fk_parent_chart_of_ac_id, ca.sin_chart_of_ac_category, ca.sin_chart_of_ac_type, ca.sin_main_ledger_category, ca.sin_default_main_ledger, ac.pk_account_id, ac.vhr_account_code, ac.vhr_account_name, ac.vhr_display_name, tr.fk_main_ledger_id, tr.fk_ledger_id, tr.dbl_ob_debit, tr.dbl_ob_credit, tr.dbl_debit, tr.dbl_credit FROM accounts.tbl_chart_of_ac ca LEFT JOIN ( SELECT fk_main_ledger_id, fk_ledger_id, SUM(dbl_ob_debit) AS dbl_ob_debit, SUM(dbl_ob_credit) AS dbl_ob_credit, SUM(dbl_debit) AS dbl_debit, SUM(dbl_credit) AS dbl_credit FROM (SELECT fk_main_ledger_id, fk_ledger_id, dbl_ledg_cur_debit AS dbl_ob_debit, dbl_ledg_cur_credit AS dbl_ob_credit, 0.00 AS dbl_debit, 0.00 AS dbl_credit FROM transaction.tbl_transaction WHERE sin_posting_status = 1 AND sin_transaction_status = 1 AND sin_document_status = 1 AND dat_transaction < '2023-01-01' AND fk_branch_id IN (1) AND fk_department_id = 1 UNION ALL SELECT fk_main_ledger_id, fk_ledger_id, 0.00 AS dbl_ob_debit, 0.00 AS dbl_ob_credit, dbl_ledg_cur_debit AS dbl_debit, 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 dat_transaction BETWEEN '2023-01-01' AND '2023-12-31' AND fk_branch_id IN (1) AND fk_department_id = 1) AS tr1 GROUP BY fk_main_ledger_id, fk_ledger_id) AS tr ON ca.pk_chart_of_ac_id = tr.fk_main_ledger_id LEFT JOIN accounts.tbl_account ac ON tr.fk_ledger_id = ac.pk_account_id;
Updated by Anil KV almost 2 years ago
- Status changed from New to Open
- % Done changed from 0 to 10
Updated by Junaid M over 1 year ago
- Assignee changed from Akash B to travvise Admin
Updated by Junaid M over 1 year ago
- Assignee changed from travvise Admin to Amal Siby
Updated by Athul P over 1 year ago
- Status changed from Open to Coding Started
- % Done changed from 10 to 40
Updated by Athul P over 1 year ago
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
Updated by Seema Mathew over 1 year ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to Seema Mathew
ISSUE FOUNDED-
1.THERE IS NO HEADER FILTER,EXPORT PDF,EXPORT ALL DATA IN THE TRIAL BALANCE - GRID
Updated by Athul P 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
- Tested By changed from Seema Mathew to unnikannan S
ISSUE FOUNDED
1.NOT SHOWING DECIMAL VALUE
Updated by Athul P 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.ERROR WHILE CHOOSING PRINT WITHOUT DATA
Updated by Athul P over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by Arathy PS about 2 months ago
- File clipboard-202501301122-5ur3z.png clipboard-202501301122-5ur3z.png added
- Status changed from Testing Done to Reopen Bugs
- % Done changed from 90 to 50
ISSUE FOUND
----------------------
1. The order in which grouping data appearing is wrong
Updated by Augustin Jose about 2 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Arathy PS about 1 month ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90