Create an MS Script Link

Home | FAQs & Troubleshooting

               

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

To create an MS Script link, you must specify the script file, scripting language, and the variables to be used by the script.

Expand/Collapse item  Before You Begin

  • This procedure requires a thorough understanding of scripting languages. Contact a qualified Sage business partner for assistance with creating scripts.

 

To create an MS Script link

  1. Select Custom Office Main menu > Customizer Selection.

  2. Select the panel to create an MS Script link for. For more information, see Select a Panel.

  3. On the Customizer Toolbar, click the Add External Link button.

  4. On the panel, click and drag to position the button.  

  5. In the External Link Definition window, on the Link Settings tab, select the MS Script link type option. For more information, see External Link Definition - Fields.

  6. In the Language field, select the appropriate scripting language.

Note  Recognized file extensions for scripts include .vbs for VBScript files, .js for JScript, and .pvs for Providex files. These are the only scripting languages supported.

  1. In the File Name field, select the file name of the script file.

  2. Click the Select Variables to be Passed to Script button to select variables available from the current panel.

  3. In the MS Script Variable Selection window, click the Select Variable and Remove Variable buttons to transfer variables to and from the appropriate list. Click OK. For more information, see MS Script Variable Selection - Fields.

  4. Click the Link Settings tab and select the Return check box for variables whose values are to be returned after the script has run.

  5. Select the Numeric check box for variables whose values are to be recognized as numbers.

  6. Click the Copy Variable List to Clipboard button to copy the selected panel variables and system variables to the Clipboard. The Clipboard text is formatted as script remarks based on the selected language and is useful for pasting information in a script. When the script is run, numeric variables are passed to the script as numbers, and the variables are returned as numbers.

  7. In the Sage 100 Advanced Only (Execute Script on Client/Server) field, select the appropriate option. Click OK.

The MS Script is created. Verify that the MS Script link functions properly by Testing the Script Host Processor.