Support #11682

[SCP ID :##5831##] : Enhance reports in IBAM

Added by Zahir Abd Latif over 3 years ago. Updated about 3 years ago.

Status:Work Completed-End life cycleStart date:April 19, 2021
Priority:NormalDue date:April 22, 2021
Assignee:Zahir Abd Latif% Done:

100%

Category:System EnhancementSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

Request to enhance reports in IBAM:

1. To add text report format in CDB

2. For bulk services (batch payment report);

i.            To have number of file
ii.            To have number of transaction

These excel format have merged fields (column & row) and time consume to breakdown the data

Re Reports in IBAM.msg (129 KB) Zahir Abd Latif, April 19, 2021 08:36

no number of file dispaly.jpg (268 KB) Nurul Athira Abdul Rahim, June 01, 2021 22:13

no number of file dispaly-pdf.jpg (364 KB) Nurul Athira Abdul Rahim, June 01, 2021 22:13

failed to generate the report.jpg (273 KB) Nurul Athira Abdul Rahim, June 03, 2021 17:00

BSNeBiz Monthly Transactional Report_403.xls (12.2 KB) Nurul Athira Abdul Rahim, June 11, 2021 16:41

BSNeBiz Monthly Transactional Report_402.pdf (15.2 KB) Nurul Athira Abdul Rahim, June 11, 2021 16:41

History

#1 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Category set to System Enhancement
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

#2 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Due date set to April 22, 2021

#3 Updated by Najmi Pasarudin over 3 years ago

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

#4 Updated by Najmi Pasarudin over 3 years ago

  • % Done changed from 0 to 50

#5 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
  • % Done changed from 50 to 90

SIT deployed on 25/05/2021

Issue:
Fix IBAM eBiz report excel template and add text format

Finding:
IBAM eBiz report excel template not optimized

Solution:
  1. Fix IBAM eBiz report excel template
  2. Currently text format cannot be done due phase 2 development. Text format requires new template and code.
Test steps:
  1. Access IBAM > CBE > BSNeBiz report
  2. Create new Monthly Transactional report in excel and pdf format
  3. Download report once available
  4. Expected result, excel report columns are optimized(no extra empty column or row) and new report column Transaction record
  5. Please comfort tests for other reports

#6 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
  • % Done changed from 90 to 70

Tested and failed.

1. Theres no "number of file" displayed on report pdf and excel.

#8 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • % Done changed from 70 to 90

#9 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Internal Testing to System Integration Test

SIT deployed on 02/06/2021

#10 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from System Integration Test to Internal Testing
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

SIT batch updated. Please redo testing.

#11 Updated by Nurul Athira Abdul Rahim over 3 years ago

  • File failed to generate the report.jpg added
  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

Hi Najmi, I failed to generate the monthly transactional report.

System display failed status.

#12 Updated by Najmi Pasarudin over 3 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

Batch Program fixed on 09/06/2021

Finding:
Report template is using Arial font and not supported in BSNeBiz server

Solution:
Change to SansSerif font

#13 Updated by Nurul Athira Abdul Rahim over 3 years ago

Tested and passed.

#14 Updated by Nurul Athira Abdul Rahim about 3 years ago

  • Status changed from System Integration Test to Pending UAT Deployment
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

Tested and passed by Azyan,

Please prepare for uat deployment

#15 Updated by Najmi Pasarudin about 3 years ago

  • Status changed from Pending UAT Deployment to Code Review

#16 Updated by Najmi Pasarudin about 3 years ago

  • Status changed from Code Review to Development / Work In Progress

#17 Updated by Najmi Pasarudin about 3 years ago

  • Status changed from Development / Work In Progress to User Acceptance Test
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

UAT deployed on 15/07/2021

#18 Updated by Nurul Athira Abdul Rahim about 3 years ago

  • Status changed from User Acceptance Test to Pending Prod Deployment
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

Tested and passed by Mazni on 2/8/21

Please prepare for Pre-prod deployment

TArget to go live on 6/8/21

#19 Updated by Najmi Pasarudin about 3 years ago

  • Status changed from Pending Prod Deployment to Pending Review
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
  • % Done changed from 90 to 100

Prod deployed on 11/08/2021

#20 Updated by Nurul Athira Abdul Rahim about 3 years ago

  • Status changed from Pending Review to Work Completed-End life cycle
  • Assignee changed from Nurul Athira Abdul Rahim to Zahir Abd Latif

Migration ID0038

Also available in: Atom PDF