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?

  • 100E - Sage 100 - Object Interface Course

    Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

  • Read & Write data in Sage100 using Business Object Interface

    Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…

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

  • item price using boi in sage 100 /mass 90 /mass 200

    Hi i am trying to read item code, item description,and item price of all the items, i am able to read both item code and item description in an object but i am getting item price as null or empty string . can any one help me out on how to read a…

  • Is Company ID from ODBC login available?

    Is Company ID from ODBC login available?

  • 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