on 11-14-2007 3:44 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.