Hi All,

This is Raj, newbie to Sisense. I am trying to write a manual query input as below but getting the following error

Here is my code

SELECT
ARI.Invoice_No,
ARD.Invoice_Link,
ARD.Shipper_Line_Key,
ARD.Account_No,
ARD.Quantity,
ARD.Unit_Price

FROM Accounting_v_AR_Invoice AS ARI

JOIN Accounting_v_AR_Invoice_Dist AS ARD
ON ARD.Plexus_Customer_No = ARI.Plexus_Customer_No
AND ARD.Invoice_Link = ARI.Invoice_Link

JOIN Common_v_Customer AS Customer
ON Customer.Plexus_Customer_No = ARI.Plexus_Customer_No
AND Customer.Customer_No = ARI.Customer_No

OUTER APPLY
(
SELECT
SUM(D1.xxx) AS MyVoid
FROM
(
SELECT
CAST(CASE WHEN ISNULL(AIA2.Void,0) <> 1 THEN 0 ELSE 1 END AS INT) AS xxx
FROM Accounting_v_AR_Invoice AS ARI2

LEFT OUTER JOIN Accounting_v_AR_Invoice_Applied AS Applied
ON Applied.Plexus_Customer_No = ARI2.Plexus_Customer_No
AND Applied.Invoice_Link = ARI2.invoice_Link

LEFT OUTER JOIN Accounting_v_AR_Invoice_Applied_Dist AS AIAD
ON AIAD.Plexus_Customer_No = ARI.Plexus_Customer_No
AND AIAD.Invoice_Link = ARI.Invoice_Link

LEFT OUTER JOIN Accounting_v_AR_Invoice_Applied AS AIA2
ON AIA2.Plexus_Customer_No = ARI.Plexus_Customer_No
AND AIA2.Applied_Link = AIAD.Applied_Link

WHERE ARI2.Plexus_Customer_No = ARI.Plexus_Customer_No
AND ARI2.Invoice_Link = ARI.Invoice_Link
) AS D1
WHERE d1.xxx = 1

) AS D

WHERE (ARI.Invoice_Date >= '5/1/19' AND ARI.Invoice_Date < '6/1/19')
AND (ARD.Account_No LIKE '41010%' AND ARD.Account_No <>'65010-0000-0000')
AND ARI.Void = 0
AND ARI.Credit_Memo <> 1
AND (D.MyVoid IS NULL OR D.MyVoid <> 1) 

It works within my SQL environment but not in Sisense, do i need to change anything in my code to be able to match Sisense formatting.

Any help is much appreciated...

Thanks

Raj