Feature #238
openCost Centre Report
Added by Anil KV over 1 year ago. Updated 28 days ago.
70%
Subtasks
Related issues
Updated by Junaid M over 1 year ago
SELECT tr.pk_transaction_id,
doc.dat_document,
ac.vhr_account_code,
ac.vhr_account_name,
doc.vhr_main_document_no,
tr.dbl_ledg_cur_debit,
tr.dbl_ledg_cur_credit,
(tr.dbl_ledg_cur_debit - tr.dbl_ledg_cur_credit) AS tr.dbl_ledg_cur_balance ,
tr.txt_narration,
cc.vhr_cost_centre_code,
cc.vhr_cost_centre_name,
cc.vhr_cost_centre_group,
tr.fk_cost_centre_id
FROM transaction.tbl_transaction AS tr
LEFT JOIN document.tbl_documents AS doc
ON doc.pk_documents_id = tr.fk_documents_id
LEFT JOIN accounts.tbl_account AS ac
ON ac.pk_account_id = tr.fk_ledger_id
LEFT JOIN accounts.tbl_cost_centre AS cc
ON tr.fk_cost_centre_id = cc.pk_cost_centre_id
WHERE
--DATE
doc.dat_document BETWEEN '?' AND '?'
tr.dat_transaction BETWEEN '?' AND '?'
--BRANCH
AND tr.fk_branch_id = ANY('{1,2,3}'::BIGINT[])
--DEPARTMENT
AND tr.fk_department_id = ANY('{1,2,3}'::BIGINT[])
--COST CENTER
AND tr.fk_cost_centre_id = ANY('{1,2,3}'::BIGINT[])
--ACCOUNT
AND tr.fk_ledger_id = ?
--MODULE
AND tr.vhr_sys_module_name = ANY('{"RECEIPT", "PAYMENT"}'::VARCHAR[])
ORDER BY tr.fk_cost_centre_id,doc.dat_document
Updated by Junaid M over 1 year ago
- Assignee changed from travvise Admin to Baseem Shan
Updated by Baseem Shan over 1 year ago
- Status changed from New to Coding Done
- % Done changed from 0 to 60
Updated by unnikannan S over 1 year ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to unnikannan S
ISSUE FOUNDED
1.ADD CURRENCY COLUMN IN GRID
2.CORRECT THE DATE FORMAT OF DD/MM/YEAR
3.ERASE FILTER NOT WORKING
4.REMOVE MODULES FROM FILTER THAT NOT RELATED TO COST CENTER
5.CORRECT THE SPELLING OF COST CENTRE IN GRID
Updated by Baseem Shan over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUNDED
FIXED - 1.DONT SHOW DOCUMENTS THAT CHOOSEN BLANK OPTION IN COST CENTRE FIELD
FIXED - 2.SHOW THE DATAS ON LIST GROUPED BY DOC NO WISE
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUNDED
1.CLEAR ALL SELECTION
2.CORRECT THE MODULE NAME SHOWING IN TAB
3.SHOW PRINT BRANCH AS ALL IN PRINT SELECTING ALL ITEM FROM UI
4.ERROR WHILE SEARCH WITH TRANSACTION DATE (42601: syntax error at or near "tr")
Updated by Baseem Shan about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Baseem Shan 12 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Baseem Shan 6 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Arathy PS about 2 months ago
- Assignee changed from Baseem Shan to Athira KK
Updated by Arathy PS about 2 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
--------------------------------
1. Add redirection to document no:'s.
2. Reduce column length of debit and credit and increase account name and cost centre name.
Updated by Athira KK 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
- % Done changed from 70 to 50
ISSUE FOUND
-------------------------------
1. Not showing all sale documents when only sale alone is checked.
2. Not showing documents from performa sale, against sale.
3. when so many documents are present it repeats itself on the second page.