Project

General

Profile

Edit Copy Actions

Feature #242

open

Inter Branch Report

Added by Anil KV over 1 year ago. Updated 7 months ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Meljo Sunny
Target version:
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:

Description

Coding Inter Branch Report


Add

Subtasks


Add

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

Actions #2

Updated by Anil KV over 1 year ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions #3

Updated by Anil KV about 1 year ago

  • Assignee changed from travvise Admin to Vivekp V
Actions #4

Updated by Anil KV about 1 year ago

  • Status changed from Open to Ready for Coding
  • % Done changed from 10 to 20
Actions #5

Updated by Junaid M 8 months ago

  • Assignee changed from Vivekp V to Meljo Sunny
Actions #6

Updated by Meljo Sunny 7 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions #7

Updated by Meljo Sunny 7 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60
Actions #8

Updated by Arathy PS 7 months ago

  • Status changed from Coding Done to Testing Started
  • Tested By set to Arathy PS

Updated by Arathy PS 7 months ago

  • Status changed from Testing Started to Reopen Bugs
  • % Done changed from 60 to 50

Issue Found:
1)Currency value not changing as we change base currency
2)After clicking print input field in UI gets enabled

Actions #10

Updated by Meljo Sunny 7 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Edit Copy Actions

Also available in: Atom PDF