Sarah Swettlen

Hi Yaremi! I was able to get it to work by having the entire stored procedure in the boyum button and then using the syntax there.   It works great!Thank you all for your feedback! :)

• View comment
• May 13, 2020 20:08
• 0 votes

Macro error in UF-081: System.Exception: Incorrect syntax near the keyword 'where'.[Macro Command: ExecuteSQL(EXEC SAP_LabelFileCreator where owor.itemcode = '$[$6.0.0]' AND owor.docnum = '$[$18.0....

• View comment
• March 31, 2020 18:25
• 0 votes

Using Exec SQL with parameters from production order

Hi All!I am trying to use a boyum button in order to execute a stored procedure in SAP. I need it to pick up the stored procedure parameters from the production order ( Document number and Item cod...

• Sarah Swettlen
• March 31, 2020 18:10
• 3 followers
• 4 comments
• 0 votes
• Answered

Set Value - Selecting a certain field to be updated

Hello!Here is the situation I am in and what I am trying to accomplish: 1. Customer has a Sales Bill of Material. When added on a sales order, they want the child GL Account to match the parent GL ...

• Sarah Swettlen
• December 10, 2019 22:19
• 2 followers
• 1 comment
• 0 votes
• Answered

Report Variables not working properly

Hello, I have the following report parameters setup however, they are not working properly: WHERE WhsCode = '[%0]' OR '[%0]' = ' 'AND ItemCode = '[%1]' or '[%1]' = ' '     What I want to be able t...

• Sarah Swettlen
• April 18, 2019 17:08
• 2 followers
• 1 comment
• 0 votes
• Answered

That worked!!!! Thank you SO MUCH for your help!!   Thank you!

• View comment
• March 25, 2019 17:34
• 0 votes

Hello, How would you filter this out to only total the quantity for specific items?Thank you

• View comment
• March 20, 2019 20:14
• 0 votes