TAAS

UI CHANGES

1.ADD TOTAL PROFIT,EXPENSE,NET PROFIT IN UI
2.GRID GROUP BY (ACCOUNT CATEGORY) IN UI

IMPORATANT TEST CASE
------------------------------------
1. To do the test cases in 'ledger statement and merged ledger statement' the changes in this module has to implemented.
--Both in merged ledger statement and ledger statement to show data while using 'consider P&L' field.

=>Validation Check
->sin_posting_status= 0 or sin_transaction_status = 0 or sin_document_status = 0 the FY then ask Y/N, y then continue
=>Document Date is FY End Date
=>Transaction
-> SQL
SELECT MIN(pk_transaction_id) AS pk_transaction_id,
                                       vhr_ledg_currency,
                                       fk_branch_id,
                                       fk_department_id,
                                       fk_ledger_id,
                                       fk_main_ledger_id,
                                       SUM(dbl_ledg_cur_debit) AS dbl_ledg_cur_debit,    
                                       SUM(dbl_ledg_cur_credit) AS dbl_ledg_cur_credit,    
                                       SUM(dbl_base_cur_debit) AS dbl_base_cur_debit,
                                       SUM(dbl_base_cur_credit) AS dbl_base_cur_credit,    
                       SUM(dbl_cons_cur_debit) AS dbl_cons_cur_debit
                                       SUM(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 ac.sin_ac_category IN (3,4) AND dat_transaction BETWEEN <FY_START> AND FY_END>
                                     AND tr.sin_is_pandl_records != 1
                               GROUP BY (fk_ledger_id,
                                       fk_main_ledger_id,
                                   vhr_ledg_currency,
                                       fk_branch_id,
                                       fk_department_id,
                                       fk_ledger_id

-> ROE = dbl_ledg_cur_amount/dbl_base_cur_amount
->Update mode -> Delete and Insert the transactins
->sin_is_pandl_records = 1
vhr_sys_module_name = FINANCIAL_YEAR_END
->vhr_sys_name = P&L
=>Reverse Posting Each Record
->Deep Copy
-> not Swap the debit and Credit - new transaction
-> fk_ledger_id = P&L Mapping account(Not set then raise error)
-> fk_main_ledger_id = P&L Mapping account's main ledger
=>FY Status is 'Open Year End' then load the FY End document
=>Allowed only 'Normal' or 'Current' or 'Year End Open' FY
=>Year End FY Status set 'Year End'
=>if Current FY Year end then Add Next FY
->If not in FY table then add new FY(Status => Current)
->If already added Next FY from GUI then current status is 'Normal' then Update to 'Current'
->Empty FY Cache
=>Remove the year all locking and Unlocking(Period and Document)
=>Imp -> Year End FY System wise Period Locking
=> keep log in financialyear.tbl_fy_actions(Check FY module)

GUI changes
-----------
1)Add branch ,department at the end of grid and currency after account
2)In action list add new column date and time
3)Remove grouping