Q: On a sales/purchase document, how do I open the freight window (I can’t find a menu-uid that does that)?
A: It is correct that the freight window does not have a menu-uid. However, it is still possible to open it using a click on the orange arrow associated with freight with the following command Click($[$91.0.0]); (91 being the Item uid of the arrow).
Q: Is it possible to execute a Formatted Search using a macro?
A: Yes, you need to do an Activate(7425); command
Q: How do I set a date from an SQL: Value?
A: In order to set a date it needs to be in the format yyyy-MM-dd.
Sample: SET($[$10.0.DATE]|SQL: SELECT CONVERT(VARCHAR(10), GETDATE(), 120)); will set the date in item 10 to today's date. Please note that Conversion of the GetDate to the yyyy-MM-dd format is needed as getdate returns values based on SQL localization/language
Q: Is it possible via a macro to ignore the standard system messages from SAP, for example, "Closing a document is irreversible. Document status will be change to “Closed” Do you want to continue ?" or "You cannot change this document after you have added it - continue?".
A: Yes (with a few limitations) it is possible with the AutoPressNextPopup() command.
Comments
3 comments
Hi Rasmus Wullf Jensen,
As you show in 3rd Q we can use SQL value and set into specific item like,
SET($[$10.0.DATE]|SQL: SELECT CONVERT(VARCHAR(10), GETDATE(), 120));
can we store SQL value in @Store variable..?
SET(@Store10|SQL: SELECT CONVERT(VARCHAR(10), GETDATE(), 120));
if not,is there any alternative solutions ..?
Why ever store it in a @Store value... Every place you can use @Store you can also use SQL:
Beyond that I can't see why you should not be able to do it
One example is that you would store it so you can use it in comparisons without repeatedly querying the database.
Please sign in to leave a comment.