Task #6689

[Bank Statutory] : IBAM Report - LHDN & SOCSO

Added by Norhaidah Md Dasuki almost 8 years ago. Updated almost 8 years ago.

Status:Closed - End of life cycleStart date:October 13, 2016
Priority:HighDue date:October 17, 2016
Assignee:Norhaidah Md Dasuki% Done:

100%

Category:UAT - LHDNSpent time:-
Target version:-

Description

Hi Jeng Wei,
Kindly assist on the IBAM Report as required. Attached is the propose Sample LHDN and SOCSO for your reference

Notes: Please share your opinion/idea (if any) in providing meaningful report content.

image001.png - LHDN (16.7 KB) Norhaidah Md Dasuki, October 13, 2016 11:33

image003.png - SOCSO (16.1 KB) Norhaidah Md Dasuki, October 13, 2016 11:33

Task 6689_Bug_BIB Report.docx (555 KB) Erni Suhaireen Zulkifli, October 14, 2016 18:12

Task 6689_Bug_BIB Report (V 0.1).docx (742 KB) Erni Suhaireen Zulkifli, October 21, 2016 16:51

Test Result #6689_BIB Report (LHDN).docx (171 KB) Erni Suhaireen Zulkifli, November 10, 2016 18:14

Test Result #6689[Bank Statutory] IBAM Report - LHDN & SOCSO.docx (566 KB) Erni Suhaireen Zulkifli, November 16, 2016 16:34

Related issues

Related to Statutory Bodies - Bug #6774: [UAT_SB_LHDN-013] Closed - End of life cycle November 08, 2016 November 09, 2016
Related to Statutory Bodies - Bug #6826: [UAT_SB_LHDN-023] - LHDN IBAM Report Closed - End of life cycle November 17, 2016 November 17, 2016

History

#1 Updated by Tan Jeng Wei almost 8 years ago

  • % Done changed from 0 to 80

#2 Updated by Tan Jeng Wei almost 8 years ago

  • Assignee changed from Tan Jeng Wei to Erni Suhaireen Zulkifli
  • % Done changed from 80 to 100

Hi Erni,

Please kindly ask for kah yan for deploy and help for verify the data on this two report. Thanks you.

#3 Updated by Erni Suhaireen Zulkifli almost 8 years ago

  • File Task 6689_Bug_BIB Report.docx added
  • Status changed from New - Begin Life Cycle to Development / Work In Progress
  • Assignee changed from Erni Suhaireen Zulkifli to Tan Jeng Wei
  • % Done changed from 100 to 70

Hi Jeng Wei,

There are still some parts on report that does not display same as requirement needs. Kindly refer attached file further details and fix it.

Thank you.

#4 Updated by Tan Jeng Wei almost 8 years ago

  • Assignee changed from Tan Jeng Wei to Erni Suhaireen Zulkifli
  • % Done changed from 70 to 100

Hi Erni,

1)root/cause: The detail header is because overlay between color box.
Solution : click the send it to back button.

2)root/cause:Amount on Total Contribution Amount (MYR) at header does not equal to the Total Amount at the details.
Solution: sum up all the total amount based on data range. just changing query.

3)root/cause:Total Amount at column 4 does not equal to the sum of PCB Amount and CP 38 Amount at column 3.
Soultion : total amount = PCB Amount + CP 38 Amount.

Please ask kan for update report.. Thanks you.

#5 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi Jeng Wei,

There are still some parts on report that does not display same as requirement needs.

BIB Statutory Bodies LHDN Report Daily
PDF format :
1) There is only 2 Pending Approval Transaction, but the Total No. of Successful Records = 4
EXCEL format:
2) There is only 2 Pending Approval Transaction, but the Total No. of Successful Records = 4

BIB Statutory Bodies SOCSO Report Daily
PDF Format:
1) No. of Records display on Report does not equal to total of record on upload file.
2) There is only 2 Pending Approval Transaction, but the Total No. of Successful Records = 3
EXCEL Format:
1) No. of Records display on Report does not equal to total of record on upload file
2) There is only 2 Pending Approval Transaction, but the Total No. of Successful Records = 3

Kindly refer attached file for further details and fix the bug.

Thank you

#6 Updated by Tan Jeng Wei almost 8 years ago

  • Assignee changed from Tan Jeng Wei to Erni Suhaireen Zulkifli
  • % Done changed from 60 to 90

Hi erni,

BIB Statutory Bodies LHDN Report Daily
PDF format :
1) There is only 2 Pending Approval Transaction, but the Total No. of Successful Records = 4
EXCEL format:
2) There is only 2 Pending Approval Transaction, but the Total No. of Successful Records = 4

root/cause: Counting total detail record
solution : counting total Record

BIB Statutory Bodies SOCSO Report Daily
PDF Format:
1) No. of Records display on Report does not equal to total of record on upload file.
2) There is only 2 Pending Approval Transaction, but the Total No. of Successful Records = 3
EXCEL Format:
1) No. of Records display on Report does not equal to total of record on upload file
2) There is only 2 Pending Approval Transaction, but the Total No. of Successful Records = 3

root/cause: Counting total detail record
solution : counting total Record

Please ask kah yan for deploy and retest again.. Thanks a lot

#7 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Category changed from SIT-LHDN to UAT - LHDN
  • Status changed from Development / Work In Progress to Internal Testing

#8 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi Chee Onn,

Kindly assist to check on this issue. No transaction display on BIB Report - IBAM.

Thank you

#9 Avatar?id=1966&size=24 Updated by Ngoh Chee Onn almost 8 years ago

  • Assignee changed from Ngoh Chee Onn to Tan Jeng Wei

Hi Jengwei,

Please assist on this issue.

Thank you.

#10 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Subject changed from [Statutory Body] : IBAM Report - LHDN & SOCSO to [UAT_SB_LHDN-013] : IBAM Report - LHDN & SOCSO

#11 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Subject changed from [UAT_SB_LHDN-013] : IBAM Report - LHDN & SOCSO to [Bank Statutory] : IBAM Report - LHDN & SOCSO

#12 Updated by Tan Jeng Wei almost 8 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Tan Jeng Wei to Nurul Akmal

Hi Nurul,

Root/cause: file path issues + folder name data is not correct when insert into IB_RPT_LIST table DB. such as 6-10-11
solution: fixed the path issues + Fix the path report output.root-dir

Please retest after deployed. Thanks a lot.

#13 Updated by Nurul Akmal almost 8 years ago

Pending SD to deploy.

#14 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Assignee changed from Nurul Akmal to Erni Suhaireen Zulkifli

#15 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi Kak Haida,

Internal Testing for BIB Statutory Bodies LHDN Report Daily has been tested and successfully pass. Kindly review the Test Result attached. Please be noted that this issue is related to Bug #6774 [UAT_SB_LHDN-013].

#16 Updated by Erni Suhaireen Zulkifli almost 8 years ago

  • Assignee changed from Norhaidah Md Dasuki to Erni Suhaireen Zulkifli

#17 Updated by Erni Suhaireen Zulkifli almost 8 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • % Done changed from 50 to 30

Updated issue found:

1. PDF Format
1.1. Total No. of Record on Header should display the total record of No. of PCB Record and No. of CP38 Record for all the transaction status. Current result display Total No. of Report: 5. Expected result is to display Total No. of Report: 36.
1.2. Total No. of Successful Record on Header should display the total record of No. of PCB Record and No. of CP38 Record for successful transaction only. Current result display Total No. of Successful Record: 3. Expected result is to display Total No. of Report: 18.

2. EXCEL Format
2.1. Total Contribution Amount should display the total amount of successful transaction. Current result display no value on Total Contribution Amount.
2.2. Total No. of Record on Header should display the total record of No. of PCB Record and No. of CP38 Record for all the transaction status. Current result display Total No. of Report: 5. Expected result is to display Total No. of Report: 36.
2.3. Total No. of Successful Record on Header should display the total record of No. of PCB Record and No. of CP38 Record for successful transaction only. Current result display Total No. of Successful Record: 3. Expected result is to display Total No. of Report: 18.
2.4. Date/Time Upload File should display as [2016-11-17 12:54:46.257].Current result display no value on this field.

#18 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Updated Changes/Bug Found:

As per discussion with user, kindly change label for Total Contribution Amount(MYR) to Total No. of Successful File Upload. Please ignored previous bug reported.

EXCEL FILE:
1. Total No. of Successful Record on Header should display the total record of No. of PCB Record and No. of CP38 Record for successful transaction only. Current result display Total No. of Successful Record: 3. Expected result is to display Total No. of Report: 18.
2. Date/Time Upload File should display as [2016-11-17 12:54:46.257].Current result display no value on this field.

#19 Updated by Erni Suhaireen Zulkifli almost 8 years ago

  • Assignee changed from Erni Suhaireen Zulkifli to Norhaidah Md Dasuki

Hi Kak Haida,

Both IBAM LHDN Report and IBAM SOCSO Report has been tested and successfully passed. To review the Test Result attached please refer on these task:
#6826
#6792

Thank you.

#20 Updated by Erni Suhaireen Zulkifli almost 8 years ago

  • % Done changed from 30 to 100

#21 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Status changed from Development / Work In Progress to Closed - End of life cycle

Successfully deployed to Production under migration ID065 on 2/12/2016 and Offline

Also available in: Atom PDF