| Description |
Client: Freedom Oil
Company: irely01 (also include irely99)
Current version: 18.1.0122.579
error while installing build 18.3.0315.803
Logs:
Error SQL72014: .Net SqlClient Data Provider: Msg 102, Level 15, State 1, Procedure uspGLImportSubLedger, Line 151 Incorrect syntax near 'THROW'.
Error SQL72045: Script execution error. The executed script:
IF (SELECT TOP 1 ysnUsed
FROM ##tblOriginMod
WHERE strPrefix = 'AP') = 1
BEGIN
EXECUTE ('
ALTER VIEW [dbo].[vyuAPOriginCCDTransaction]
AS
WITH APOriginCCDTransaction AS (
SELECT DISTINCT
[intEntityId] = D.intEntityId,
[strVendorOrderNumber] = (CASE WHEN DuplicateData.apivc_ivc_no IS NOT NULL
THEN dbo.fnTrim(A.apivc_ivc_no) + ''-DUP''
ELSE A.apivc_ivc_no END),
[intTermsId] = ISNULL((SELECT TOP 1 intTermsId FROM tblEMEntityLocation
WHERE intEntityId = (SELECT intEntityId FROM tblAPVendor
WHERE strVendorId COLLATE Latin1_General_CS_AS = A.apivc_vnd_no)), (SELECT TOP 1 intTermID FROM tblSMTerm WHERE strTerm = ''Due on Receipt''))
FROM apivcmst A
LEFT JOIN apcbkmst B
ON A.apivc_cbk_no = B.apcbk_no
INNER JOIN tblAPVendor D
ON A.apivc_vnd_no = D.strVendorId COLLATE Latin1_General_CS_AS
LEFT JOIN tblEMEntityLocation loc
ON D.intEntityId = loc.intEnti
|