Project

General

Profile

Edit Copy Actions

Feature #238

open

Cost Centre Report

Added by Anil KV over 1 year ago. Updated 28 days ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Target version:
Start date:
07/09/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Cost Centre Report
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Cost Centre Report


Add

Subtasks


Add

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

Actions #2

Updated by Junaid M over 1 year ago

  • Assignee changed from travvise Admin to Baseem Shan
Actions #3

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

Actions #5

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 over 1 year ago

TESTING DONE

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

Actions #8

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

TESTING DONE

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")

Actions #11

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 unnikannan S about 1 year ago

TESTING DONE

Updated by unnikannan S 12 months ago

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

ISSUE FOUNDED

1.ARRANGE BALANCE AMOUNT SHOWING IN PRINT
2.ADJUST GAP BETWEEN FIELDS

Actions #14

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 Arathy PS 6 months ago

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

ISSUE FOUND
-------------------------
1) Data showing only for document modules not for sub document modules.

Actions #16

Updated by Baseem Shan 6 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions #17

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.

Actions #19

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.

Actions #21

Updated by Athira KK 28 days 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