Skip to Content
0
Jun 16, 2020 at 04:34 PM

SAP B1 query for BOYUM or Formatted Search

670 Views

I need a query to use with BOYUM or Formatted Search to select specific line item information from a quote(marketing document). I have the following which not working:

Set ($[$BOYX_2.0.0]|SQL:SELECT $[$38.1.0] FROM [dbo].[QUT1] WHERE $[$38.0.0] = $[$BOYX_1.0.0]);

//will set the field $[$BOYX_2.0.0] based upon Line # entered 'BOYX_1'

//$[$38.1.0] Item No.

//$[$38.0.0] Line Number