Skip to Content
0
Mar 19, 2010 at 12:48 PM

Formatted Search - Restrict to Only One Customer on Activity Window

9 Views

Hello Experts:

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

SELECT

T1.[CardCode] + ' - ' + ltrim(str(T0.[ClgCode]))

FROM OCLG T0

INNER JOIN OCRD T1

ON T0.CardCode = T1.CardCode

ORDER BY

T1.CardCode Desc,

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