Sage 100

I have a Batch file that has been running VI jobs for years. But recently some of it hasn't been working. The batch file calls 2 separate VI Import jobs, with a timed pause between. The first VI job runs fine, and loads the data without issue. The…

When we run a job nightly for IRP do we need to change the effective and cutoff dates every day or does it change automatically somehow?

I am receiving an error message when clicking on any template in the task scheduler. Here is what happened. How it happened: Library Master > Task Scheduler > I ran IMPORTITEMS (worked great until I put all the imports into script). It has been…

Hi When I am trying to import a PO through VI can I import a comment line. In My SO import I replace the "Line type" and comments import as a 4 items import as a 5. Is there a similar thing with PO's. I can't get it to import the comment line. (it…

I have a VI job that is using odbc to connect to my database. is it possible to execute this VI job using sData?

Hi Everyone! We are going to be using Concur Standard to handle our company credit card expenses. The Concur rep told me to contact Sage and ask for a sample input file so she can customize our upload file to Sage's specification. I contacted Sage…

I am new to Sage 100. I've previously used Sage 50. Using Sage 50, I was able to import our credit card charges into one AP entry. When using the Visual Integrator in Sage 100, which table would I use? There are many for AP and I'm not sure which one…

Is there a way in Visual Integrator, when importing from excel, to do conditional formatting on a particular field on the excel file, not a MAS table? For example, I am importing sales orders and I want particular items on that sales order to be priced…

We have 5 companies and want to combine them into one company. We want to do this ourselves rather than pay someone to do it. Does anyone have a "guide" for doing this? I need to know what all tables to use to get the various history files, etc., for…

First, I'm an IT guy, but have little Sage 100 knowledge. We have created a new company in Sage. I need to move some inventory records from the old company to the new company. I have two CSV files. The first contains inventory records of items that…

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…