Macro SQL Set Row Values with Store Function

Carla van Zyl

Good day!

On My Sales Order, I want the Minimum price (from Item Master Data) to reflect per row on an open sales order. 


I have written this,but its not working - casuing my SAP to just load. Do you maybe know what the issue is or what I can do to fix. 

@store1=SQL

(Declare @ItemCode as nvarchar(12);

SET @ItemCode=$[$38.1.0]

SELECT Distinct T0.U_Min_Price

FROM OITM T0  INNER JOIN RDR1 T1 ON T0.[ItemCode] = T1.[ItemCode]);

Set($[$38.U_Min_Price.0]|@Store1);

 

Comentarios

2 comentarios

Fecha Votos
  • Comment author
    Geoff Booth

    Validation:

    Set the Before Action to False

    Set the ActionSuccess to True

     

    UF:

    @STORE1 = SQL(Select T0.U_Min_Price FROM OITM T0  Where T0.ItemCode = $[$38.1.0]);

    Set($[$38.U_Min_Price.0]|@Store1);

    0
  • Comment author
    Carla van Zyl

    Hi Geoff, 

    Thanks so much for your quick assistance! It is working now. 

    0

Iniciar sesión para dejar un comentario.