Bug #6673

[SB_LHDN_011 & 012] : LHDN - Validation Issue

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

Status:Closed - End of life cycleStart date:November 08, 2016
Priority:HighDue date:November 08, 2016
Assignee:Norhaidah Md Dasuki% Done:

100%

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

Description

Hi Chee Onn,
Reported by IT on the validation issue for LHDN. Kindly refer to attached screen shot assist to fix the error.

Notes: Need to complete by Monday, 10/10/16

LHDN-VALIDATION-ISSUE.doc (1.5 MB) Norhaidah Md Dasuki, October 07, 2016 16:06

Error Message to Display.docx (1.34 MB) Erni Suhaireen Zulkifli, October 14, 2016 10:30

Penril Datability (M) Sdn Bhd Mail - [LHDN] List of Error Message to be Verified.pdf (153 KB) Norhaidah Md Dasuki, November 08, 2016 11:04

Error Message to Display (V 0 1)-2.docx (32.4 KB) Norhaidah Md Dasuki, November 08, 2016 11:04

IB_FILE_FIELD_DATA.sql (80.3 KB) Ngoh Chee Onn, November 08, 2016 13:03

Test Result #6673 [UAT_SB_LHDN-011][UAT_SB_LHDN-012].docx (211 KB) Erni Suhaireen Zulkifli, November 10, 2016 12:44

Test Result #6673 [UAT_SB_LHDN-011][UAT_SB_LHDN-012]HeaderDetails.docx (485 KB) Erni Suhaireen Zulkifli, November 10, 2016 14:00

Test Result #6673 [UAT_SB_LHDN-011][UAT_SB_LHDN-012]HeaderDetails[V1.2].docx (342 KB) Erni Suhaireen Zulkifli, November 10, 2016 15:36

Test Result #6673 [UAT_SB_LHDN-011][UAT_SB_LHDN-012]HeaderDetails[V1.3].docx (159 KB) Erni Suhaireen Zulkifli, November 10, 2016 16:02

Test Result #6673 [UAT_SB_LHDN-011][UAT_SB_LHDN-012]HeaderDetails[V1.4].docx (574 KB) Erni Suhaireen Zulkifli, November 15, 2016 18:05

Test Result #6673 [UAT_SB_LHDN-011][UAT_SB_LHDN-012]HeaderDetails[V1.5].docx (557 KB) Erni Suhaireen Zulkifli, November 15, 2016 18:29

Related issues

Related to Statutory Bodies - Bug #6640: Statutory Bodies - LHDN Closed - End of life cycle September 30, 2016

History

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

  • Assignee changed from Ngoh Chee Onn to Norhaidah Md Dasuki

Dear Haidah,

Please help to confirm the error message must in Malay or English? According to the attach document only Malay error message can be refer.

Thank you.

#2 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Status changed from New - Begin Life Cycle to Pending Customer Feedback
  • % Done changed from 0 to 10

Already send to user to verify on the error message required.

#3 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Assignee changed from Norhaidah Md Dasuki to Erni Suhaireen Zulkifli

#4 Updated by Erni Suhaireen Zulkifli almost 8 years ago

  • File Error Message to Display.docx added
  • Status changed from Pending Customer Feedback to Development / Work In Progress
  • Assignee changed from Erni Suhaireen Zulkifli to Ngoh Chee Onn

Hi Chee Onn,

Attached are the list of error message in English version that have been verified with customer. Kindly refer attachment to update the system to meet this latest requirement.

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

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Ngoh Chee Onn to Erni Suhaireen Zulkifli

Hi Erni,

Please test again for the lhdn validation message after deploy done by Kah Yan. For issue no 11 cannot be done, due to contains 2 validation message and field inside.

Thank you.

#6 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Category changed from SIT-LHDN to UAT - SOCSO

#7 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Subject changed from [Statutory Body] : LHDN - Validation Issue to [SB_LHDN_011 & 012] : LHDN - Validation Issue
  • Category changed from UAT - SOCSO to UAT - LHDN

#8 Updated by Norhaidah Md Dasuki almost 8 years ago

Hi Chee Onn,
Just found the email on the validation issue - error message. Please refer the attachment and proceed for the fix. Thank you.

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

  • File IB_FILE_FIELD_DATA.sql added
  • Assignee changed from Ngoh Chee Onn to Yap Kah Yan
  • % Done changed from 10 to 80

Hi Kah Yan,

Please help pull agro-bib and deploy in SIT. Furthermore, please help to clean data in table IB_FILE_FIELD and execute attachment script. After finish, let erni to test on it.

Thank you.

#10 Updated by Yap Kah Yan almost 8 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Yap Kah Yan to Erni Suhaireen Zulkifli

Deployed. Please retest. Thank you.

#11 Updated by Norhaidah Md Dasuki almost 8 years ago

Erni,
Please add below scenario to testing and the error message is correct.

Q . Currently, we not allow company to upload LHDN file for other company. If customer upload LHDN file for other company (company code registered with LHDN), what is the error message to be prompt?
A. The error message should be displayed as “Invalid Employer No.”

#12 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi Chee Onn,

Currently tested error message displayed on Header Part only. Error message displayed is not according to requirement needs. For more details please refer attached Test Result on this scenario number:

No 3 : Enter other than H on H field
No 5 : entering zero ‘000’ on HQ Employer No field and Branch Employer No field
No 7: Enter ‘000’ on Brach Employer No field

Thank you

#13 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi Chee Onn,

Currently tested error message displayed on both Header and Detail Part. Error message displayed is not according to requirement needs. For more details please refer attached Test Result on this scenario number:

Header
No 3 : Enter other than H on H field
No 5 : entering zero ‘000’ on HQ Employer No field and Branch Employer No field
No 7: Enter ‘000’ on Brach Employer No field

Details:
No 1: Id details record does not start with “D”
No 3: Enter zero “000” on Employee Name
No 6: Leave blank on:
Tax Reference No.
-Old NRIC No. or New NRIC No.
Passport No.
No 8: Enter alphabets on PCB Amount field
No 9: Enter alphabets on CP38 Amount field
No 11: If record details exceeded 136 field

Kindly fix on both Header and Detail part.
Thank you

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

  • Assignee changed from Ngoh Chee Onn to Yap Kah Yan

Hi Kah Yan,

Please help to pull agro-bib and deploy for erni to do testing.

Thank you.

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

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Yap Kah Yan to Erni Suhaireen Zulkifli

Hi Erni,

Please refer below for my answer.

Header
No 3 : Enter other than H on H field
- Please test after deployment.

No 5 : entering zero ‘000’ on HQ Employer No field and Branch Employer No field
- Please test after deployment.

No 7: Enter ‘000’ on Brach Employer No field
- Please test after deployment.

Details:
No 1: Id details record does not start with “D”
- Please test after deployment.

No 3: Enter zero “000” on Employee Name
- Will not validate employee name 000 is required since 000 also not alphabet. Somemore add extra validate 0 for a string value in details costing so much memory in server. It will impact how whole system performance, because details might be got record arround 1000++.

No 6: Leave blank on:
Tax Reference No.
Old NRIC No. or New NRIC No.
Passport No.
 Please test after deployment.

No 8: Enter alphabets on PCB Amount field
- The total PCB record also affected by change alphabet in PCB amount, due to PCB amount with alphabet will causing this amount is skip or zero. For those skip and zero PCB amount will not count as a PCB amount. That's why the 'Invalid Total PCB record.' cannot be excluded.

No 9: Enter alphabets on CP38 Amount field
- Please test after deployment.

No 11: If record details exceeded 136 field
- Please test after deployment.

Thank you.

#16 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi Chee Onn,

Kindly recheck on this issue (Detail Part).

Error message displayed is not according to requirement needs. Refer on this scenario:

Details:
No 1: Id details record does not start with “D”
[Change the error message display to be - Detail Records does not start with “D”]

No 6: Leave blank on: Tax Reference No., Old NRIC No. or New NRIC No., Passport No.
[Error message should not display Invalid Tax Reference No.. only display Employee Name and other two information have to be filled (Tax Reference No. or Old NRIC No. or New NRIC No. or Passport No.)]

No 9: Enter alphabets on CP38 Amount field
[Error message should display “CP38 Amount should be numeric” “Invalid Total CP38 Amount”]

No 11: If record details exceeded 136 field
[error message should display: Detail length format is > 136]

Please refer attached Test Result for more details and fix the bug.
Thank you

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

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Ngoh Chee Onn to Yap Kah Yan

Hi Kah Yan,

Please help to deploy the second push from me.

Thank you.

#18 Updated by Yap Kah Yan almost 8 years ago

  • Assignee changed from Yap Kah Yan to Erni Suhaireen Zulkifli

Deployed.

#19 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi Kak Haida,

Issue SB_LHDN_011 & 012 is already tested and status is conditional pass. Kindly review the Test Result.

Thank you.

#20 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Status changed from Pending Review to User Acceptance Test

10/11/2016 - Fixed reported issue found and send for User Retest

#21 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Status changed from User Acceptance Test to Internal Testing
  • Assignee changed from Norhaidah Md Dasuki to Erni Suhaireen Zulkifli
  • % Done changed from 100 to 80

Erni please verify on feedback in the email from Idayu dated Mon, Nov 14, 2016 and fixes from Chee Onn date:Tue, Nov 15, 2016 at 10:55 AM

#22 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi Kak Haida,

Attached is Test Result for SB_LHDN_011 & 012. Kindly review the Test Result.

Thank you

#23 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi Kak Haida,

Attached is updated Test Result (V 1.5) for you to review.

Thank you

#25 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Status changed from Pending Review to User Acceptance Test

Reviewed. Send for User Retest.

#26 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Status changed from User Acceptance Test to Closed - End of life cycle

16/11/2016 [Idayu] Retest and pass

Also available in: Atom PDF