• Remove line breaks in VI Export

    Hello all, SAGE 100 Could Advanced 2020 (V6.20.1.0) I have a VI (Visual Integrator) export job that pulls fields from CI_Items out of SAGE and into a .CSV file. I use Task Manager to automate this export and then another software reads the .CSV files…
  • Creating a new company from some of the historical data.

    I have a client that has recently been purchased by a larger entity. The new company would like to change the fiscal year and purge all historical detail from before the acquisition. Their preference is to start a totally new company that only has detail…
  • ASCII Delimiters for VI Exports

    Greetings: I am attempting to export some data with TAB delimited fields. I have my job File Type setup for Delimiter and I have the Use ASCII Delim. box checked and for my delimiter I have attempted to use the ASCII code for horizontal tabs of 9 but…
  • VI Import Question

    I am currently new to VI and looking to see if there is a lookup function that would determine a value to be passed during the import based on a value found in the import file. As an example, the import file that has been provided includes an account…