Lookup SQL SELECT Statement in a Container


We have an A/R Aging report in Sage intelligence reporting and now I'm trying to add the MemoText in the AR_InvoiceHistoryMemo table where MemoCode = "COLLECTION".

Below are my statements, but the report still doesn't only pull the MemoText where MemoCode = 'COLLECTION'. Can you please help and let me know what I got wrong with the statements? Very appreciated!!

Expression Name:


Expression Source:


LookupSQL SELECT Statement:

SELECT DISTINCT [AR_InvoiceHistoryMemo].[MemoText], [AR_InvoiceHistoryMemo].[MemoCode] FROM [AR_InvoiceHistoryMemo] WHERE [AR_InvoiceHistoryMemo].[MemoCode] = "COLLECTION"



Parents Reply Children
No Data