Create a batch file to run a Sage 100 Visual Integrator Job

Understand prerequisites and requirements

• Use this process only with the following versions:
  • Sage 100 Advanced and Premium
  • Sage MAS 200 version 4.40.0.4 or higher
• Use the Sage 100 Application Server for external execution.
• Running jobs this way prevents ODBC path issues that block Sage tasks.

Gather job information

1. Open Import Job Maintenance or Export Job Maintenance.
2. Select an existing job or create a new one.
3. Record the Job Name.
4. Open the job.
5. Locate the Compiled File Name in the upper-right corner.
6. Record the VI program name, such as VIW###.

Create a new application entry in Application Server

Perform setup on the Sage 100 Advanced server

1. Open Windows Start, Sage, Sage 100 version directory.
2. Select Application Server Configuration.
3. Select the Apps tab.
4. Click New to open the app properties screen.
5. Enter the Job Name as the App Name.
   • Caution: The App Name must exactly match the batch file entry.

Configure application settings

• ProvideX EXE: Leave default.
• Server INI: Enter ..\Launcher\Sota.ini.
• Lead Program: Enter StartUp.M4P.
• Extra CMD Options: Leave blank.
• Arguments: Leave blank.
• Start-In Directory: Enter the ..\MAS90\Home path.
• Init Window: Select Hidden.

Configure options

• Select Allow Client Arguments.
• Clear all other options.

Save and restart

1. Click OK.
2. Click Apply to save changes.
3. Compare settings with the existing Sage 100 entry for accuracy.
4. Exit Sage 100 for all users.
5. Restart the Application Server or related Windows service.

Create the batch file

Build the batch file structure

C:

CD "C:\Sage\MAS 200 Client\Version4\MAS90\HOME"

"C:\Sage\MAS 200 Client\Version4\MAS90\HOME\pvxwin32.exe" -hd ../launcher/sota.ini *Client -ARG "Server Name" "Port" "App Name"

Add required arguments

-ARG=DIRECT UION UserLogon Password Company VIWxxx AUTO

• Use no space after -ARG=.
• Replace placeholders with actual values:
  • UserLogon: Sage 100 login with VI permissions
  • Password: User password
  • Company: Company code
  • VIWxxx: Compiled VI name
  • AUTO: Runs silently

Example batch file

C:
CD "C:\Sage\Sage 100 Workstation\MAS90\Home\"
"C:\Sage\Sage 100 Workstation\MAS90\Home\pvxwin32.exe" -hd ../launcher/sota.ini *Client -ARG "SERVER1" "10000" "SOINVOICEIMP" -ARG=DIRECT UION admin password ABC VIWI00 AUTO

Save and run

1. Open Notepad.
2. Paste the three lines.
3. Save the file with a .bat extension.
4. Double-click the file to run the job.

Steps for Sage 100 Standard or older MAS versions

Verify setup

• Confirm the task exists as a menu item.
• Confirm Visual Integrator jobs appear on the Jobs menu.
• Assign user access in Role Maintenance.

Create the command line

..\MAS90\Home\Pvxwin32.exe ..\Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION user password company VIWxxx AUTO

Example command

F: CD F:\Version4\MAS90\Home Pvxwin32.exe ..\Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION user1 password01 ABC VIWI00 MANUAL 

Configure arguments

• Use UION or UIOFF to control user interface display.
• Use AUTO for silent execution.
• Use MANUAL for testing with prompts.

Additional information

• Define the source file location in Import Job Maintenance.
• The batch file cannot override the source file path.