Sage 100

Hi there, I'm testing out the first of many imports in our parallel upgrade test environment. We are going from 4.5 to 2023 100 Premium. I'm getting an error when running an import of an order that is downloaded from TrueCommerce's EDI TransactionManager…

Has anyone tried to get a proper export from Big Commerce for a VI into Sage 100c 2021?

I'm exporting column names in my Visual Integrator export. I need to rename one of the column headings, but I can't seem to find a way to do that. Anyone have any suggestions? Thanks!

Anyone using Time Track for Job Costing, but exporting the time track entries for outside payroll service to process payroll?

All, I'll try and be concise. I am working with Sage100 2019 and Visual Integrator Jobs. We just moved up from Mas90 4.3. Whoa, I know. Here's my dilemma: In Mas90, we had a VI job that would bring in website orders in a csv formatted file and import…

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…

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…

Currently using Sage 100 Advanced 2017 Ver 5.40.3.0. When I run the Visual Integrator it will show that the records came across with no errors. If I look at one of the records in the log it will show the correct Punch In time and Punch Out time there…

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…

We are using Sage 100 Advanced v2017 and have created a new VI job to import AP Invoices from DocLink SQL tables. We have a SQL script that we can run manually on the server to update the Doc link SQL tables. However, when we run it under the perform…

Questions: 1) Please suggest how can we create AP invoice with different dates for details within and success import their via VI module? 2) Please suggest how can we add lines (details) to existing AP invoice via VI module? Description: Our…

Questions: 1. How to check status completion of VI Job? (see picture 1) 1. What Sage MAS 100 table and field should we use to determine VI Job status using ODBC? 2. Is there other way to run VI Job without using PVXWIN32.EXE? The problem description…

Hello, We are a distribution company that is looking to implement a WMS that can integrate with Sage 100. Preferably one that can stand alone as well. We are going through some growing pains and may also be looking to a new ERP in years to come. May…

Community, We are a mid-west manufacturing company and are looking to implement the JobOps product with barcoding using JOScan. We are hoping to find another company presently using JobOps with Sage 100 ERP that might be willing to share their experience…