Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Search/Find by Contact Name

While running through a standard demo, was unable to search in find mode in the contact name field in a Sales Quotation or Sales Opportunity - Is this a locked field, is this something that cannot be done in B1 2007, Is there a fix?

Former Member
Former Member replied

Sherry,

I could only think of a work around by using a Formatted Seach on the Sales Quote Number field to look for the Contact Person.

Sample SQL

<b>SELECT T0.DOCNUM FROM [DBO].[OQUT] T0 INNER JOIN [DBO].[OCPR] T1 ON T1.CNTCTCODE = T0.CNTCTCODE

WHERE T1.[NAME] = '[%0]'</b>

Suda

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question