FAQ Overview

Select ROW_NUMBER() OVER (ORDER BY E.StartDate) As "NO",
CAST(A.AR_File_No As text) As "FILE NO",
F.SectionCode As "SECTION",
Format(E.StartDate,'dd-MM-yyyy') As "AUDIT START DATE",
Format(E.EndDate, 'dd-MM-yyyy') As "AUDIT END DATE",
A.AR_Decision_Maker As "AUDIT TEAM LEADER", -- (is AR_Decision_Maker?)
N.MA_NAME As "AUDITOR",
--I.STAFF_NAME As "AUDITOR",
--'XX' As "TA/EVA/OBS",--TA/EVA/OBS
K.STD_NewCode As "SCHEME",
(Select Top 1 ContactPerson from TBL_RFI_TempCustomerContact where RFI_id = B.ARM_RFIID) As "PIC/CLIENT NAME",
ISNULL(G.EMAIL,'') As EMAIL,
ISNULL(G.ADDR_LINE1,'') + space(1) + ISNULL(G.ADDR_LINE2,'') + space(1) + ISNULL(G.ADDR_LINE3,'') + space(1)
+ ISNULL(G.CITY,'') + space(1) + ISNULL(G.POSTAL_CODE,'') + space(1) + ISNULL(G.STATE,'') + space(1)
+ ISNULL(H.COUNTRY_NAME,'') As "CLIENT COMPANY ADDRESS",
REPLACE(REPLACE(ISNULL(G.COMP_HPS_PHONE1,''),'-',''),' ','') As "TEL NO.",
G.CUSTOMER_NAME As "COMPANY NAME",
L.ST_Description As "AUDIT TYPE" --AUDIT TYPE
from TBL_Application_Review A inner join
TBL_Application_ReviewMain B On A.AR_ARMainID = B.ARM_MAINID inner join
--TBL_MSCS_Tracking_NewFiles C on A.AR_ID = C.MTN_ARID inner join
TBL_MSCS_Tracking_NewFiles_Sub D on A.AR_ID = D.MTNS_ARID inner join
TBL_Schedule_FileNoDate E on E.AR_Id = A.AR_ID inner join
Master_Section F on A.AR_SectionID = F.Section_ID inner join
Master_Customer G on B.ARM_CustomerID = G.CUSTOMER_ID inner join
Master_Country H on G.COUNTRY = H.COUNTRY_ID inner join
Master_Staff I on I.STAFF_ID = A.AR_SchedulerID inner join
Master_Standard K on K.STD_ID = A.AR_STD inner join
Master_Stages L on L.ST_ID = D.MTNS_Stage inner join
TBL_AuditorSchedule M on M.SchMain_RefId = D.MTNS_SchMainID inner join
Master_ExternalAuditor N on N.MA_ID = M.AuditorID
Where
E.StartDate BETWEEN '2023-04-01 00:00:00.000' AND '2023-04-30 23:59:59.000' AND
D.MTNS_SchPickFlag = '1'
Order by
--A.AR_File_No ASC
E.StartDate ASC

Select Distinct ISNULL(PD.PD_ID, 0) PaymentID, Inv.Inv_Id INVID, Inv.Inv_No, Format(Inv.Inv_Date, 'dd/MMM/yyyy') InvDate, Invd.Invd_Price, Format(PD.PD_CreatedDate, '') ReceivedDate,

DateDiff(DAY, Inv.Inv_Date, GetDate()) InvTAT, MS.STAFF_NAME UserName, PT.Response_TransactionId TransID, PT.Response_TransactionDate TransDate, PT.PaymentType PaymentType,

Upper(ISNULL(MC.CUSTOMER_NAME, '')) CustomerName, ISNULL(MS.EMAIL, '')  from TBL_Invoice Inv With (NOLOCK) inner join TBL_Invoice_Details Invd With (NOLOCK) on Inv.Inv_Id=Invd.Invd_InvID

inner join Master_Customer MC With (NOLOCK) on Inv.Inv_CustomerId=MC.CUSTOMER_ID

Left Outer join TBL_Payment_Transaction PT With (NOLOCK) on Inv.Inv_QuotationId=PT.QuotationId and isnull(PT.Payment_Status, '')='SUCCESS'

Left Outer join TBL_Invoice_Payment_Transaction IPT With (NOLOCK) on Inv.Inv_QuotationId=IPT.QuotationId and isnull(IPT.Payment_Status, '')='SUCCESS'

Left outer Join TBL_PaymentDetails PD With (NOLOCK) on Inv.Inv_Id=PD.PD_InvoiceID

Left outer join Master_User MU With (NOLOCK) on PD.PD_CreatedBy=MU.ID

Left outer join Master_Staff MS With (NOLOCK) on MU.Staff_ID=MS.STAFF_ID Where Inv.Inv_Id=19119 and ISNULL(Inv.Inv_IsConfirmed, 0)=1

Select MBC.BC_Bank_CashType_Code + ' - ' + MBC.BC_Description BankCode, MCT.CT_CashType, PD_UploadPath,

PD_RefNo, format(PD_ReceivedDate, 'dd MMM yyyy') ReceivedDate

from TBL_PaymentDetails PD With (NOLOCK)

Left outer join Master_BankCode MBC With (NOLOCK) on PD.PD_BankCode=MBC.BC_ID 

Left outer join Master_CashType MCT With (NOLOCK) on PD.PD_CashType=MCT.CT_ID

where PD_InvoiceID=19119

select * from TBL_RFI where RFI_RefNo='RFI201700042'

select * from TBL_Application_Review where AR_RFIID=1218

select * from TBL_Application_ReviewMain where ARM_RFIID=1218

select QM_Address1,* from TBL_Quotation_Main where QM_QuotaitonNo='QUO202201023'

select * from TBL_Quotation_Details where QT_QMID=12032

select ADDR_LINE1,ADDR_LINE2,ADDR_LINE3,CITY,POSTAL_CODE,STATE,* from Master_Customer where CUSTOMER_ID in (23980)

select Add_FileNo,Add_SiteName,Add_Address1,Add_Address2,Add_PostalCode,Add_City,Add_State,*

from TBL_APR_AddressDetails where Add_CustomerID in (23980) and Add_ID in (367,368,821,1261,2008,8434)

select QM_Address1,QM_Address2, * from TBL_Quotation_Main where QM_RFIID=1218

select * from Master_User where SectionID=6 and UserType=8

select * from Master_UserType

--SUITE 16.02, LEVEL 16, CENTREPOINT SOUTH MID VALLEY CITY

--update TBL_Quotation_Main set

--QM_Address1='SUITE 16.02, LEVEL 16, CENTREPOINT SOUTH MID VALLEY CITY'  where QM_ID in (12032) --NO. 17-9 & 19-9, 9TH FLOOR THE BOULEVARD  MID VALLEY CITY, LINGKARAN SYED PUTRA  59200 WILAYAH PERSEKUTUAN

--update TBL_Quotation_Main set

--QM_Address1='WISMA HRD Corp, JALAN BERINGIN,   BUKIT DAMANSARA,   50490, KUALA LUMPUR'  where QM_ID in (11945) --WISMA HRDF, JALAN BERINGIN,   BUKIT DAMANSARA,   50490, KUALA LUMPUR

--update TBL_Quotation_Main set

--QM_Address1='11-G, BLOCK A, ZENITH CORPORATE PARK   NO. 1, JALAN SS7/26, KELANA JAYA  47301 PETALING JAYA'

-- where QM_ID in (12326) --11-1, BLOCK A, ZENITH CORPORATE PARK   NO. 1, JALAN SS7/26, KELANA JAYA  47301 PETALING JAYA

INFO ErrorLog - Receipt post request: {"Type":{"value":"Payment"},"ApplicationDate":{"value":"12/18/2023 3:45:27 PM"},"Branch":{"value":"K-4-44-159"},"CashAccount":{"value":""},"CurrencyID":{"value":"MYR"},"CustomerID":{"value":"99000296"},"Description":{"value":""},"PaymentMethod":{"value":""},"Hold":{"value":false},"PaymentAmount":{"value":4624.80},"PaymentRef":{"value":"10976V"},"DocumentsToApply":[{"AmountPaid":{"value":4624.80},"DocType":{"value":"Invoice"},"ReferenceNbr":{"value":"159NV2300569"}}],"custom":{"Document":{"AttributeTRANSDATE":{"type":"CustomDateTimeField","value":"2023-12-18 15:45:27"}}}}18 Dec 2023 15:45:29,241 [17156] INFO ErrorLog - Erp Receipt Payment response : {"message":"An error has occurred.","exceptionMessage":"Payment.CashAccount: 'Cash Account' cannot be empty.\nPayment.PaymentMethod: Payment Method '' cannot be found in the system.\nInserting 'AR Payment' record raised at least one error. Please review the errors.","exceptionType":"PX.Api.ContractBased.OutcomeEntityHasErrorsException","stackTrace":

Resolution:

SCIS admin shall register the company in CRM and push it to SCIS

updated the status to 0 and costid to null for the duplicate record.

updated the status to 1 in tbl_master_addr

Added popup message to tell PO that task is route to Head for approval

Display fax no from GL user profile

Removed cancel button. SC must click on DONE.

Updating table structure tbl_lms_label_stock & tbl_lms_req_hdr in Production

The exec must click on Forms -> Label Price. Then select the Label Type.

Then click View on respective row. On the Label Price Form, select necessary action (Approved/Rejected).

Then click Submit.

Resolution: To revise the logic. If there is a valid test report do not route to CP.

Resolution: Delete the existing process. Use raise new process.

SIRIM Sign link = https://na2.documents.adobe.com/account/homeJS

https://sirim.sharepoint.com/sites/SIRIMVOD/AwarenessVideos/Forms/AllItems.aspx?csf=1&web=1&e=LrS4uf&cid=cc8da93f%2Df698%2D4e91%2Dac20%2D0adb04689cd2&FolderCTID=0x012000DD9ADF42D13E044DA765DACD5038D057&id=%2Fsites%2FSIRIMVOD%2FAwarenessVideos%2FSIRIMSign%2FLampiran%20A&viewid=d8759574%2D2f6c%2D4666%2D8e94%2Dd8b89a95d527

Customer License Enablement in CAKNA.

https://sirim.sharepoint.com/sites/CAKNAMANUAL/CAKNA%20ENABLEMENT/Forms/AllItems.aspx?npsAction=createList