Set default value in SAP B1 Query - Selection Criteria window

Answered

Hugo van der Poel

• December 07, 2016 15:39

 

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:

Vote

0

• Official comment

  

  Naama Aharoni

  • December 11, 2016 09:50

  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
• 

  Eric Rasenberg

  • January 24, 2017 11:51

  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.
• 

  Hugo van der Poel

  • January 31, 2017 08:27
  • Edited

  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

Please sign in to leave a comment.