Am trying to create a formatted search to provide a suggested RMA Number on the Business Partners > Activity window in a UDF.
While in Activity, the user should get a list of ONLY the one customer they are currently working with. So if C0001 is being used in the Activity window, the list should show all suggested RMA numbers just for that customer of C0001, not any other customer.
When I use the following it shows all customers.
--FMS 6BP Automated RMA Number
T1.[CardCode] + ' - ' + ltrim(str(T0.[ClgCode]))
FROM OCLG T0
INNER JOIN OCRD T1
ON T0.CardCode = T1.CardCode
T1.[CardCode] + ' - ' + ltrim(str(T0.[ClgCode])) Desc
When I put in WHERE T1.CardCode = $[$ 9.0.0 ] in the right place it shows nothing...
Any ideas on how to make only the one current customer in Activity window appear in the list???
Thanks in Advance - Zal