Hello!

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:

MemoText_Collection

Expression Source:

 [AR_InvoiceHistoryMemo].[MemoText],[AR_InvoiceHistoryMemo].[MemoCode]

LookupSQL SELECT Statement:

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

Thanks!!

Jun