Sage 100

I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…

Running SAGE 100 v2018 and exporting a file using VI that requires the current date and time be appended to the file. Is there a way to accomplish this using the Perform option within the VI Export job or do I need to create a separate batch process once…

I am trying to figure out how to create a VI job to be able to change all of the customers for a sales person to email Sales Order & S/O invoices. I've tried exporting AR_CustomerDocuments and AR_CustomerDocumentsContacts, but neither of those seem to…

I'm trying to import a journal entry. I've calculated the Debit Account number by combining other fields to make the complete account and that works. Now I need to total all the debits to get the credit amount and then assign the credit account number…

We have a long time customer that has been running a batch file that launches a VI job. The first job chains to another and so on for several jobs. They are and have been Sage 100 premium, we just upgraded them to 2020. The batch file works and all the…

Hello everyone, I received existing import job with defined perform logic The import job contains Command "CREATE_ERRORLOG" on Failure. Сan anyone tell me where I can find this error log? Also, Is there a link where listed all available commands…

Can someone explain the purpose of the Cycle Option in VI. I have read what documentation I can find but want a "real world" explanation of how it is used. I am hoping it will cause my VI Job to complete. I have a bat file that is run from Windows Task…

W/O-Legacy experts, I need help! I have been trying to set up a VI job to import W/O material transactions. I followed the KB advice to create an export job, and look at the fields that are populated, I also double-checked that I am using the proper…

Attempting to create my first bat file to run a VI job outside of Sage 2018 Advanced 6.00.5.0, getting a Connection Time Out error. Can anyone tell me where I went wrong? I followed the steps carefully to create the new app in the Sage Application Server…

I'm trying to recreate PO Receipt of Goods from history. I can't seem to import to a PO where 10 lines are lot distributed and 1 line is not. What field can i add to distinguish between them?

Hello, I've created a VI job to import Sales Orders. All fields work perfectly with the exception of the Quantity and Price. The import log shows both fields as blank, even though the amounts are in the selected columns. I also tried setting the amounts…

Hello, I've used VI jobs for various import and export jobs to import things from sales order info to bill structure. I dont use a lot of conditional based columns. What im trying to do is have the ShipExpireDate be 5 business days added to the order…

Hi all, would like a better understanding of best practice in setting up an ODBC link for Sage 100 VI jobs. We are currently still on Sage 100C Advanced 2018, and I am working to beef up what began as a home-grown Access solution to meet a specific accounting…

I have a VI Job that imports sales order invoices into a batch. I have scripting that does some zip code validations and then uses scripting to interact with 3rd party integration buttons that are installed (Vertex tax software). The scripts work perfectly…

Good day; Newbie here, any help is greatly appreciated. I created a VI job to export the previous day invoice no,, day, customer number, customer name. I am exporting this data from table "AR_InvoiceHistory Header". No management wants me to also…

I am running a VI import to import AR invoices into AR Invoice Data entry to post Invoice to Customer accounts. The import works I am using an assigned Misc Item code that contains a GL Account number for Sales. But when I try to post the invoice I get…

Is it still not possible to use Sage VI to change the qty on an already existing component item in Bill of Materials? I have not seen anything posted on this subject in several years, so i just wanted to see if it was possible now. I've tried everything…

I need to know if there is a script or perform logic that can help my situation. - I have a VI Import Job importing Invoices from Sales Orders - The source file does NOT contain the Misc or Charge items from the SO Can this be done without the…

Hi, In importing through VI into IM_TransactionHeader (which also has L and LL), how do I use "Next" operation for EntryNo and apply the first EntryNo generated to all L and LL lines?? Or should I be using different Operation or can I simply not achieve…

Client is currently on Sage 100 2016. We are in the process of updating to 2018. Client has an import job for work order that I created many years ago. As I recall it was a particularly difficult import to create. It still works nicely and is used on…

I would like to automate some Visual Integrator Exports. However, I need to use the Select Tab to make sure each time the export runs the correct records are selected. I found the following formula helpful on the Sage Knowledgebase...and it works based…

Hello, I am in the process of restructuring roles for our company. We just began testing, and one of the reported issues is that there are no VI jobs in the job select menu. All of the Visual Integrator permissions are selected for this role, so I am…

The original statement we have is as follows - Temp001$=“458” I want to include "459". How should the formula look? Temp001$=“458, 459" or Temp001$=“458” or Temp001$=“459”

I need to run all the following in sequence 1 Run MS Access Macro - I have a bat file that does this nicely 2 Import data into 'Production Entry'- I have a VI Import job that works 3 Launch 'Production Register Update' panel - I see this can be…

I am not sure why when I run the VI export job, the tax amount from SO_InvoiceDetail appears to be 0 in the exported result file. All other values are being exported correctly. I have also check ed manually in the sales orders and invoices that the tax…