Skip to Content
0
Former Member
Sep 11, 2007 at 01:55 PM

Formatted Search Matrix

63 Views

Good Day

Experts:

I am trying to buid a Formatted Search for a UserDefined field on the SalesOrder Content tab Matrix. I need to reference the ItemCode and Whse columns in the Matrix. I currently have the following Formatted Search that returns an internal error.

<b>Select U_ItemCode AS 'Item Code', U_WhseCode AS 'Warehouse', U_BinLoc AS 'Bin Location', U_Quantity AS 'Qty in Bin', U_QCHold as 'QCHold', U_Rcv as 'Rcv', U_Ship as 'Ship' FROM [@TEMBIN] where U_ItemCode = $[$38.1.0] and U_WhseCode = $[38.24.0]</b>

If I replace the attempted column reference with the actual values in the row and run the query, the correct results are shown in the Formatted Search window.

I have searched the forum and did not find a solution. Does anyone have information on what I may be doing wrong?

Thanks,

Ed