• Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…
  • 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…
  • 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…
  • Sync Inventory and Product Data with php eCommerce

    Hello! I am building a php eCommerce system for a client, and they would like to have inventory and product data synced from Sage 100 ERP 2016 to the eCommerce store. They were previously using MAS90 when we had first looked into it, but between that…
  • 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…
  • Rebuilding Sort Files Automatically

    Once every 1-2 weeks or so I have to get in after hours to rebuild sort files, in our old business system a similar process was scheduled to run each night. Does anyone out there have a script or other method that would allow for scheduling a rebuild…