Feature #242
openInter Branch Report
Added by Anil KV almost 2 years ago. Updated 22 days ago.
Start date:
07/09/2023
Due date:
% Done:
50%
Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Inter Branch Report
Tested By:
Code Reviewed By:
Subtasks
Related issues
Updated by Anil KV over 1 year ago
Solutions
1) GUI Changes
-Currency - Default Empty - Add BASE1(***),BASE2(***), All currency code
-Add status - like Ledger stmt
2) SQL
SELECT tr.dat_transaction
--...
FROM transaction.tbl_transaction tr
LEFT JOIN document.tbl_documents doc
ON tr.fk_documents_id = doc.pk_documents_id
WHERE tr.sin_posting_status = 1
AND tr.sin_transaction_status = 1
AND tr.sin_document_status = 1
AND tr.sin_posting_type != 4
AND tr.fk_ledger_id = 1 -- Input To branche Control account id
AND doc.fk_branch_id IN (1, 2) -- Input from branches
AND tr.dat_transaction BETWEEN '2023-09-01' AND '2023-09-30'
ORDER BY tr.dat_transaction;
*Input currency base amount choose
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 Vivekp V
Updated by Anil KV about 1 year ago
- Status changed from Open to Ready for Coding
- % Done changed from 10 to 20
Updated by Arathy PS 22 days ago
- Status changed from Reopen Bugs Coding Done to New Changes
- % Done changed from 70 to 50
NEW CHANGES
---------------------------------
Inter Branch Report -> Assign Shilpa =================== ->Rename 'From Branch*' to 'Branch' -And Select box ->'To Branch' - Multi-Selection ->Branch Wise Grouping(Branch ac base finding branch-Branch master ) ->'To Branch*' need multi-selection ->Group wise total need -Total label 'Pay' or 'Receive'(-ve balance) =>List -Add 'OB' Column before 'Debit' -Rename 'Debit' to 'Pay(Dr)' -Rename 'Credit' to 'Receive(Cr)' *Swap the columns -Settled and Outstanding Column -> +ve(Cr) or -ve(Dr) -> Add 'Matched' and 'Outstanding' Checkboxes - Checkboxes - like Ledger stmt