• How to avoid triggering pre-total events for each line of the same imported invoice?

    I've developed a script that, for some customers, discounts TX ItemCode's to absorb their AvaTax calculated sales tax and present a invoice total including sales tax (but not freight) equal to the original net invoice, but when the invoice is imported…
  • VI Job error WO with Bill Revision

    I'm trying to create a job to change dates for Work orders. Some WO through errors like this when the Revision Code has any letters. Some of our revisions are just numbers like the ### but some do have some letters which are allowed in the Bill of Materials…
  • Import AR Salesperson Commission - Err Record in Uneditable State

    Older version Sage 100 4.5 (yay, I know) Need to change the SalesSubjectToComm amount, created VI Import to AR_SalespersonCommission Test run, all records pass. Live run, all records fail with "Record is in Uneditable State". No other users…
  • Using Visual Integrator to modify BOM

    Is it still not possible to use Sage VI to change the qty on an already existing component item in Bill of Materials? I have not seen anything posted on this subject in several years, so i just wanted to see if it was possible now. I've tried everything…
  • CRE VI Job

    I have a vi Import job that does cash receipt entry. Occasionally the vi job fails. The result of the failure I believe is caused by a pop-up dialog that I am getting with the following message "The invoice balance was exceeded. Do you want to continue…
  • Script to trigger from VI - Problem with Exit Sub function

    Hello, I have been working on a script that launches after a visual integrator job and have run into an issue with the Exit Sub function. I have seen other threads about how you have to define the Sub first when triggering like this but can't quite…
  • VI export - All Vendors not just one company per job

    Hello- I have created some VI export jobs for exporting text files to export Vendors but I notice it only returns vendors for the company the job is being ran under? Is there a way to run one job and get all vendors for all companies? The best thing…
  • VI Import - CI_Item Table

    We were looking to clean up and standardize our misc item codes across our MAS companies. Our support group said you can't delete them if they had been used in the past, but we could switch "UseInPO" to N to hide them. I've built a VI job that seems…