Sage 100

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…

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

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…

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…

Hi, I am trying to update my VI Job. I have it automatically running from Task Scheduler on my old server. I am trying to run it on my new server called NEWSAGE with port 9021 for Sage 100 2021 Premium. Here is my script below: C: CD "C:\Sage…

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…

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…

I've been trying to use the AND() function in Visual Integrator to combine to string fields. I keep getting an Error 46 saying the Length of the string was exceeded. I tried using two separate Temp fields to Truncate each of the original fields (I was…

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…

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…

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…

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…

So I have an odd problem. A customer is using Visual Integrator to run jobs. That's fine, they also use BOI in the User Defined Scripts, attaching to Read, Write events. The problem is the code in these scripts are ran when Visual Integrator is running…

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…