Task #781

eCustody: Reports

Added by Tan Lee Yong over 13 years ago. Updated about 13 years ago.

Status:Work Completed-End life cycleStart date:March 16, 2011
Priority:NormalDue date:March 21, 2011
Assignee:Hafizudin MD% Done:

100%

Category:-Spent time:36.00 hours
Target version:-

Description

Generate 3 types of reports:-
1) CSV
2) Fixed length txt
3) PDF

History

#1 Avatar?id=2560&size=24 Updated by Ahmadi Hadi over 13 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#2 Avatar?id=2560&size=24 Updated by Ahmadi Hadi over 13 years ago

  • % Done changed from 0 to 10

Designed 80% of the first report (RPT001).

#3 Updated by Tan Lee Yong over 13 years ago

  • Assignee changed from Ahmadi Hadi to Almasi Moein

Transfer from Hadi (Completed 10%, Spent time: 6 hours) to Moein.

#4 Updated by Tan Lee Yong over 13 years ago

Tan Lee Yong wrote:

Generate 3 types of reports:-
1) CSV
2) Fixed length txt
3) PDF

Reports to generate:-
1) Settled Purchased Report
2) Settled Sales Report
3) Failed/Cancelled Trades Report
4) Corporate Actions Report
5) Corporate Meetings Report
6) Shareholdings Report by Master A/C
7) Shareholdings Report by Custody A/C
8) Substantial Holdings Report

#5 Updated by Almasi Moein over 13 years ago

  • Start date changed from March 21, 2011 to March 16, 2011
  • % Done changed from 10 to 30

1) Settled Purchased Report - Done
2) Settled Sales Report - Done
3) Failed/Cancelled Trades Report - Done
4) Corporate Actions Report - 40%

#6 Updated by Almasi Moein over 13 years ago

  • % Done changed from 30 to 70

4) Corporate actions report - Done
5) Corporate meeting report - Done
6) Shareholdings report by master - 70%
7) Shareholdings report by custody a/c no - 70%
8) Substantial holdings report - Done

#7 Updated by Almasi Moein over 13 years ago

  • Due date changed from March 29, 2011 to March 21, 2011
  • % Done changed from 70 to 90

6) Shareholdings report by master - 90% (Just left to figure out on how to print the grand total to n the last page of report 6)
7) Shareholdings report by custody a/c no - Done
9) Holding report (monthly) - Done

Task which have been done are arranging and formatting the reports according to the report table and template documents and updated the logo image.

#8 Avatar?id=2560&size=24 Updated by Ahmadi Hadi over 13 years ago

  • Assignee changed from Almasi Moein to Ahmadi Hadi
  • % Done changed from 90 to 80
  • Implemented the Struts side of Reports module and integrated it with the designed JRXMLs.
  • I set the percentage back to 80% because later we need to apply two more parameters (custodyAcNo and masterAcCode) to the reports as well.

#9 Avatar?id=2560&size=24 Updated by Ahmadi Hadi over 13 years ago

The session's current 'masterAcCode' has been already applied.
'custodyAcNo' still remains...

#10 Avatar?id=2560&size=24 Updated by Ahmadi Hadi over 13 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Ahmadi Hadi to Hafizudin MD

'custodyAcNo' has been applied to the reports too.
Ready for internal testing.

#11 Updated by Hafizudin MD over 13 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Hafizudin MD to Ahmadi Hadi

Tested by hafiz
status : failes

Report

1)i found at E-custody system requirement , Custody Account Name & Custody Account No is dropdown menu.
2) No title -"Report"
3) Custody Account No is alphanumeric. cannot accept Special character.
4) Go to blank page after enter 123123 to Report Start date
5) Go to blank page after enter 123123 to Report End date
6) All report type that has been download to computer is empty. no data, not title,????
7) can search this 17/12/20xx at Report Start date(need Disable javascript before test)
8) can search this 1/1/1 at Report Start date(need Disable javascript before test). should check date format dd/mm/yyyy
9) can search this 17/12/20xx at Report End date(need Disable javascript before test)
10) can search this 1/1/1 at Report End date(need Disable javascript before test). should check date format dd/mm/yyyy

please guide me about Report Format

#12 Avatar?id=2560&size=24 Updated by Ahmadi Hadi over 13 years ago

  • Assignee changed from Ahmadi Hadi to Hafizudin MD
  • Replaced the empty report with a message indicating that matching record has been found. * Please repeat the testing with masterAc switched to 'MAYINV', as it's one of the few @masterAc@s that we have data for it.

My apologies for not mentioning this before!

#13 Updated by Vincent Devethas over 13 years ago

please update this task. Close if its done. Thanks,

#14 Updated by Vincent Devethas about 13 years ago

  • Status changed from Development / Work In Progress to Work Completed-End life cycle
  • % Done changed from 80 to 100

Also available in: Atom PDF