• How to Create a Windows batch file to run "Other Sage 100 ERP Task Outside the Program"

    KB article 19387 "How to create a short-cut or Windows batch file to run Visual Integrator import job, export job, or other Sage 100 ERP task outside the program," implies this can be done but the examples given are for VI jobs only, where the "APP Name…
  • How to run bat file followed by VI job and Sage Tasks from a single command

    I need to run all the following in sequence 1 Run MS Access Macro - I have a bat file that does this nicely 2 Import data into 'Production Entry'- I have a VI Import job that works 3 Launch 'Production Register Update' panel - I see this can be…
  • VI perform logic and SQL Script

    We are using Sage 100 Advanced v2017 and have created a new VI job to import AP Invoices from DocLink SQL tables. We have a SQL script that we can run manually on the server to update the Doc link SQL tables. However, when we run it under the perform…
  • Perform Logic in Cash Receipts To Look Up Invoice Number

    Hello Everyone, In a past post, it was implied it is possible to use perform logic to look up values in other tables when running a VI import job. I have extensive experience with VI in general but little with perform logic but have been intrigued to…
  • Visual Integrator Perform Logic not working

    I have a current project that is automating the import of invoices into AP _InvoiceHeader for 15 different companies within MAS90. I use a Batch file to launch the VI Job and perform logic to launch a command script to archive the .csv file upon completion…
  • Does anyone know how to launch the Sales Order UI after importing a sales order with VI?

    We use VI quite extensively and it works great. We use it to import many of our orders. After the VI jobs run, we open the sales order entry screen and enter the sales order number to do final editing and to print/email. Does anyone know how to add…