Setting Document Type with a Macro

Answered

Stuart Blackwell

• March 25, 2020 18:31

I am attempting to use a Macro Type Universal Function to set the Document Type of a Purchase Order to Item, but although I can set the value in the Combobox, the document table does not update and remains as if a Service type document. Is there a trick I am missing to get this to work correctly?

Stuart

Vote

0

• Official comment

  

  Yaremi Miranda Lopez

  • May 13, 2020 19:07

  Hello Stuart,

  I have a macro that changes the document type when the Business Partner is selected and it works fine. Here is it:

  
• 

  Nadav Caridi

  • March 25, 2020 20:51

  Hi , 

  you can use set focus / send keys with enter after setting the value, just be aware that send keys isn't recommended by boyum.

  might be a cleaner way to do this (?)
• 

  Stuart Blackwell

  • March 26, 2020 09:16

  In theory that should work, but in practice, after using either Focus or Click to select the ComboBox,  no following input works. Using Set, or SendKeys has no impact on the screen and the ComboBox remains open awaiting user input.
• 

  Nadav Caridi

  • March 26, 2020 11:47

  ok try use dynamic code as follows : 

   

  SAPbouiCOM.ComboBox myCombo = (SAPbouiCOM.ComboBox)form.Items.Item("3").Specific;
  myCombo.Select("S", SAPbouiCOM.BoSearchKey.psk_ByValue);
• 

  Stuart Blackwell

  • March 26, 2020 11:56

  Aside from needing the change "S" to "I" for setting it to Item Type, it works perfectly. Thank you.
• 

  Nadav Caridi

  • March 26, 2020 11:59

  Sure , maybe theres a better way to do this with B1UP , I'm not sure.

  Glad it worked. 
• 

  Stuart Blackwell

  • May 14, 2020 10:55

  Thanks for the official comment Yaremi, but that is exactly what I was trying to do originally and it did not work for me.
• 

  Yaremi Miranda Lopez

  • May 14, 2020 11:47

  Hello Stuart,

  Maybe the event is not triggering the universal function, I tested and worked for me, if the problem persists please contact your local support so we can investigate further. =)

Please sign in to leave a comment.