Feature #242
openInter Branch Report
Start date:
07/09/2023
Due date:
% Done:
70%
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 about 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