Have you ever wondered about how to automate the process of entering Accounts Receivable invoices into Sage MAS 90 ERP? How about uploading Sales Order data while you sleep at night, ready to process by the time you arrive in the morning?

With the Sage MAS 90 Visual Integrator (VI) module, users can automate the import of Accounts Receivable, Sales Order, or other types of data, by running a VI job from the command line. A Visual Integrator job or any other Sage MAS 90 program can run independent of Sage MAS 90, with a Windows task, a batch file, or similar method. This allows a user to run the job after business hours, or several times a day, without anyone having to log in to Sage MAS 90.

Please review the details below for examples and notes regarding the command line structure:

Note this is for Version 4.xx

The following information must be included in the command line:

..\MAS90\Home\Pvxwin32.exe ..\launcher\sota.Ini ..\SOA\Startup.M4P -ARG DIRECT (UI State) (User Logon) (Password) (CompanyCode) (Program Name) (Program Argument)

Example:

..\MAS90\Home\Pvxwin32.exe ..\Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION myuser mypassword ABC VIWI00 AUTO

Notes:

  • If an argument has no value (for example: if the User Logon has no password), use quotation marks (“”) to hold the arguments in place.
  • The User Logon above refers to the Sage MAS 90 or Sage MAS 200 ERP user logon setup in User Maintenance (not the User Code field in User Maintenance).
  • UIState—Set this argument to either UION or UIOFF. This setting specifies if a User Interface exists (for example: a user could receive notification of errors in a message box.)
  • Set the Program Argument to Auto or Manual. The Manual option forces the import job interface to launch, and requires the user to click Accept. Use the Manual option to test your procedure, then use the Auto option once you have verified that the job launches correctly in the Manual option.
  • For batch file command lines, use this example as a model:

    F:
    CD F:\Version4\Mas90\Home
    Pvxwin32.exe ..\Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION myuser mypassword ABC VIWI00 MANUAL
    REM Note we set the current directory to Home first
    REM Note we set the program argument to MANUAL initially
  • Any program run with a command line on version 4.0 must exist as a Task within the Sage MAS 90 or 200 Role-based security system. You must add Visual Integrator “legacy” jobs (jobs not using a 4.0 Table as the Primary Table) to the Jobs Menu before running the job with a command line. Jobs using a 4.0 Table as the Primary Table are automatically added to the Jobs Menu (for example General Ledger jobs).
  • After you add the task to the system tasks files, use Role Maintenance to grant access to the new menu for the Visual Integrator Jobs menu. The user logon specified on the command line above must belong to a role that has access to this new task or menu item.

Sage MAS 200:

  • For Sage MAS 200,  the path to the Sage MAS 90 directory used in the shortcut properties corresponds to the Sage MAS 90 directory of the Sage MAS 200 Server Installation, not the Sage MAS 90 directory on the workstation. In the VI job, enter the path to the Import File/Export File as it appears from the WORKSTATION, and uncheck the ‘On Host’ option.

    .

If you have any questions or need assistance creating or automating an import,   please contact our support  desk at DSD Business Systems

Jim Woodhead

VIA  Sage e-bulletin

Jim Woodhead is Vice President of Professional Services of DSD Business Systems, a national provider of on-demand (cloud) and on-premises ERP and CRM software, specializing in wholesale distribution, manufacturing, warehouse management, inventory, business intelligence and eCommerce software. DSD offers Sage 100 (formerly MAS 90), Sage 300 (formerly Accpac), Sage 500 (formerly MAS 500), NetSuite, Sage FAS, Sage HRMS (formerly Abra), Sage CRM, Sage SalesLogix, Extended Solutions, and Custom Programming.
Jwoodhead
View all posts by Jwoodhead
Jims website
Share
© 2010 DSDtips.com Suffusion WordPress theme by Sayontan Sinha