Set default value in SAP B1 Query - Selection Criteria window Respondida

Hugo van der Poel

 

Hello experts,

I have a small problem I hope you can help me with.

I have a Universal Function that will initiate to print a label when the user presses a B1up button in the Item Masterdata window. This UF Macro looks like this:

Activate(4868);

Click($[$5.1.0.10]);

Activate(519);

Now I want to add to the Macro that the second criteria (Quantity) in the Query Criteria selection window (form 4000) is set by default on '1'.

I amended the Macro and finally came up with  the sample below but whatever I do it will continue the macro only after I closed the Query selection window. It then tells me it cannot find the Quantity field (obviously).

 Activate(4868);

Click($[$5.1.0.10]);

Activate(519);

Activate();

Focus($[$1000007.0.0]);

Set($[$1000007.0.0]|1);

 

Is there any way to get B1Up to set a value in this window, or am I doing something else wrong?

Many thanks,

 

Hugo

-----

Function:


Original Macro

 

Error after closing Query - Selection Criteria window:

Comentarios

3 comentarios

Fecha Votos
  • Comment author
    Naama Aharoni
    • Comentario oficial

    Hi Hugo,

    Unfortunately, I do not understand what are the macro steps. Can you please write what each macro line supposed to do? You can add remarks to the macro by adding the following "//your remark" to the end of of each macro line.

    Thanks, Naama

  • Comment author
    Eric Rasenberg

    Dear Hugo,

    I would suggest to make a SQL report (put it in the SAP main menu)  and set the default values in the query behind it. When selecting empty values you get the default values you set in the query.

    0
  • Comment author
    Hugo van der Poel
    • Editado

    Hi Naama and Eric,

    Thank you for your responses. Apologies for the incomplete Macro description. I will try your approach for now Eric.

    Many thanks!

    Hugo

    0

Iniciar sesión para dejar un comentario.