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 is 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 need 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 todays date. Please note that Convertion 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, 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.