Can anyone tell me how to do a basic SendKeys script for the picking sheet printing window?
I tried and I can't get it to work. Not really familiar with scripting, but this seemed like it would be easy.
Can anyone tell me how to do a basic SendKeys script for the picking sheet printing window?
I tried and I can't get it to work. Not really familiar with scripting, but this seemed like it would be easy.
If you are trying to automate printing/exporting of a picking sheet, you are better off using the BOI (Business Object Interface).
SendKeys can work but can be unreliable and cause unintended results if…
If this is a UDS script (executing on either a table or UI event), the script is always going to execute on the server.
If this is a button script, you have to set it to execute on the client.
If you are trying to automate printing/exporting of a picking sheet, you are better off using the BOI (Business Object Interface).
SendKeys can work but can be unreliable and cause unintended results if focus is moved inadvertently.
Here is a link for more info on SendKeys.
https://ss64.com/vb/sendkeys.html
Since Sage 100 uses a lot of keyboard shortcuts with the ALT prefix, whereever you see a button with an underlined character, such as the Preview button, you would use something like this.
Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.SendKeys "%v"
If you are going to use the BOI, refer to some of the posts on this forum on how to print forms via BOI. If you are only ever doing a single sales order at a time, this is simpler as you can use the quick print property otherwise if doing a range, you have to incorporate quite a number of more lines of code to properly select the orders.
Here is a good starting point if you are going to use BOI.
This post has the QuickPrint property being used.
I just want the 'Warehouse' field to be filled in automatically
I just want the 'Warehouse' field to be filled in automatically
If you use a form code other than "STANDARD", I believe the previous value should be saved (by user / workstation)... no scripting required.
That's not the case. It will save any of the checkboxes that you select, but not anything in that grid.
*Community Hub is the new name for Sage City