Sage 100

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…

We have been using Sage 100 along with the Scanco and JobOps modules for quite some time. We recently purchased a module from another ISV which requires some integration work to be completed to ensure they operate together without conflicts. We’ve tried…

Hi community! I need some help. I have an almost perfect code here in C# posting a payment in cash receipts. The only problem is that the batch amount is duplicated. The batch total is $520.00 instead of $260.00. What am I doing wrong? Here…

Does anyone have any suggestions on the best way to use Microsoft SSIS (SQL Server Integration Services) to connect to SAGE 100 Business Objects API? We came across this product, but were curious to know what recommendations the community had. https:…

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…

Hello, I am a developer, and we have purchased Sage 100 partner account. We want to integrate it with our app. Where we will fetch products related data to our system. However, I am unable to see any help regarding the REST API or integration tool. I…

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- 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…

We'd like to take a sales order form that SAGE 100 emails to customers and instead run it through the Docusign API. This would allow our customers to e-sign for custom orders instead of printing out, signing, and scanning forms. Has anyone done this?

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…

Hello Everyone, I've read the previous posts referencing signature pads; however, they are all outdated. The company I work for is looking to implement the use of signature pads with our sales order module to streamline our processes. Currently, we…

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…

How can Sage 100 be integrated with an existing MES system. Are there APIs built into the Sage application for ease of integration?

We are using a cloud based project management system. All employee time is entered into this system. However, Sage Timesheet (9.85) is used to feed our billing, which is currently done through MAS 200 (4.40). I can grab the time entries from the project…