B1UP Macro on Goods receipt

Tom Blais

• September 19, 2024 20:24

I have a macro set up from a report to open a PO and report completion. Is there a way to get the Set($[$item.col.type]|valueToSet); to actually set the quantity. The PO is populated but I can't get it to focus so it won't do anything. Am I doing something wrong?

 

ActivateRightClick(5922);

Set($[$13.9.NUMBER]|@STORE1); 

Vote

0

• 

  Keshava Best

  • September 26, 2024 17:48

  Add another Activate()
  
  

  ActivateRightClick(5922);

  Activate();

  Set($[$13.9.NUMBER]|@STORE1); 
  
  Keshava
• 

  Tom Blais

  • September 30, 2024 15:36

  Thanks but I tried adding another Activate() and it still won't let me set the quantity. I even tried changing my code to activate from menu id and enter the production order number from there with no luck. I removed the variables to simplify but I continue to get the same error message.

  Macro error in UF-164: System.Exception: Error setting Matrix '13' - Column '9' - Row '0' with value '1' [Check that it is visible and active] (Item - Form item is not editable)
   [Macro Command: Set($[$13.9.NUMBER]|1)]

   

  Macro below:

  OpenForm(202|$[$BOY_1.DocEntry.0]); //Open PO

  ActivateRightClick(5922);

  Activate();

  Set($[$13.9.NUMBER]|1); 

   

   
• 

  Geoff Booth

  • September 30, 2024 16:06

  Hey Tom, turn on the Debug Mode on your macro.

  Then you can walk through the macro line by line and it will show you which form is inactive / active.

  That should help determine whether you need another Activate () or possibly a PopFormStack() to move to the form you want to activate.
• 

  Keshava Best

  • September 30, 2024 16:22

  Hi Tom,
  
  I tested and the issue is you need to provide the row number when setting the quantity. You also need the Activate()
  
  Fix for your example

  OpenForm(202|$[$BOY_1.DocEntry.0]); //Open PRO
  ActivateRightClick(5922);
  Activate();
  Set($[$13.9.NUMBER.1]|1);

  
  Alternate method
  Activate(4370); //Open Receipt from PRO
  Set($[$13.61.0.1]|1); //Set DocNum
  Set($[$13.9.0.1]|1);

  
  Keshava
• 

  Tom Blais

  • September 30, 2024 21:34

  Thank you. I tried manipulating the row number in the set command but I was doing that wrong and that was my problem. I appreciate the help and support.

Please sign in to leave a comment.