x Want to participate? Join the group to interact

  • BM_GrossReqrmntReport_rpt

    I'm not finding a way to import several Bill Numbers into this report's parameters. Can you help me? It seems like i should be able to do this, however i'm not finding the right path yet. VI doesn't offer it and i'm having trouble finding clues to help…

  • Using a Sage UDT (Sage Premium SQL table) as a source for a VI job?

    How can I use a Sage UDT SQL table as a source for a VI job?

  • Adding a perform with two select statements in Sage 100 Visual Integrator

    Client running Sage 100 v2018. Trying to export purchase order information based on two select criteria that is outside standard fields. I'm able to create a Perform for the individual selections and when I add one of the two perform functions to the…

  • Looking to Export AP Payment Transaction History-System Limiting Export

    When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…

  • 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…

  • VI Import Job update field based on 0

    Hello Everyone, I am trying to updated the "Hold Payment" field for our Vendors with an import file that will contain Vendor code and a number. The number will act as a switch for the Hold Payment field, so if it's a 0 then N, if greater than 0 then…

  • Possible to create Visual Integrator import job without a source file?

    I'm wondering if i can create a job that cycles through every record in a table instead of every record in a source file. like, a calculation job instead of an import job. All that needs to be done is set field to nothing if date in that field is…

  • 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…

  • 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…

*Community Hub is the new name for Sage City