Task #6703

LHDN: Add validation for Employer number

Added by Tan Lee Yong almost 8 years ago. Updated almost 8 years ago.

Status:Work Completed-End life cycleStart date:October 14, 2016
Priority:HighDue date:October 19, 2016
Assignee:Norhaidah Md Dasuki% Done:

100%

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

Description

1) Create a new table for the new LHDN Employer with 3 fields
i) Employer number
ii) Company Name
iii) Flag (temporary use this name until known)
2) Validate employer number with DB. If not exist, fail the request.

Employer_Data_testing.txt Magnifier (3.75 KB) Tan Lee Yong, October 14, 2016 15:04

LHDN_REG_EMPLOYER_TABLE.sql (694 Bytes) Ngoh Chee Onn, October 19, 2016 11:47

EmployerNoColumnType.sql (153 Bytes) Ngoh Chee Onn, October 19, 2016 11:47

Task 6703 Test Result_LHDNValidationEmployerNumebr.docx (214 KB) Erni Suhaireen Zulkifli, October 19, 2016 16:23

Task 6703 Test Result_LHDNValidationEmployerNumeber_V 0.1.docx (202 KB) Erni Suhaireen Zulkifli, October 20, 2016 10:50

History

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

Hi Kah Yan,

Development done and pushed to staging mercurial. Please help to deploy in SIT and UAT server and refer attachment for the new create table script, which this table use to keep all registered employer. Furthermore, the previous column NO_EMPLOYER and NO_EMPLOYER_HEADQUARTERS in BIB_LHDN_RECORD table in wrong date type. Please help to execute the query in second attachment in SIT and UAT db for this column type fixed.

Thank you.

#2 Updated by Yap Kah Yan almost 8 years ago

  • Category changed from Development to Internal Test
  • Assignee changed from Yap Kah Yan to Erni Suhaireen Zulkifli
  • % Done changed from 80 to 0

Hi Erni,

Deployed Chee Onn's changes for validating LHDN registration.

Please test. Thank you.

#3 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi Chee Onn,

Already test the subject. Even when change the employer number to be invalid employer number. System still receive the file. No validation occurred on this scenario. Kindly refer attached file and fix the bug.

Thank you.

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

  • Status changed from Development / Work In Progress to Internal Testing

Hi Erni,

Please check properly the number you change is Headquarter Employer Number and not Employer Number. Employer Number is starting from length 21 until 31.

Thank you.

#5 Updated by Erni Suhaireen Zulkifli almost 8 years ago

Hi,

Sorry for the mistake. Subject has been tested and successfully pass. Kindly review the Test Result on attached file.

Thank you.

#6 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Category changed from Internal Test to UAT - LHDN

#7 Updated by Norhaidah Md Dasuki almost 8 years ago

  • Status changed from Pending Review to Work Completed-End life cycle

Reviewed.

Also available in: Atom PDF