Sage 100

I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…

I'm going through a process of converting several Standard Cost Parts to Serialized in our system for each of our warehouses. I've adjusted the items out manually using a transaction entry. I've changed the valuation from Standard to Serialized using…

I am needing to run an Open Balance Export job that contains specific headers that are located on different tables. The primary table I'm using is the `AR_OpenInvoice`, to which I am attempting to link to the `AR_InvoiceHistoryHeader` table. The problem…

I have seen two different upgrades affected by the *.SQL files under MAS90\VI failing to be migrated to the 2021 MAS90\VI folder during upgrades. Anyone else encountering this? The manual solution is to just copy them but I don't recall having to…

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…

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…

How to change file type in EXPORT JOB MAINTENANCE, For me it is showing FILE TYPE: Delimited, and that drop down box is disable (grayed) so I can not change file type. Tried checking / unchecking ASCII

We are importing SO invoice records using VI. There are 445 lines in the file. The summary says that none of them failed or were skipped, yes the number "passed" is not equal to the number read. What causes this to happen? From looking at the summary…

Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?

Our client has a system in place that kicks out a dept code. This department code has been directly linked to a G/L account by utilizing the AP Expense Distribution Table (Code 5 on the Distribution Table is equivalent to the G/L account we want to import…

I'm running into issues with creating an AR Cash Receipt Import using VI in version 5.1/2014. Does anyone happen to have a sample AR Cash Receipt VI job that they would be willing to share? Any help would be greatly appreciated. Thank you.