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