• Multi-Line Invoice Import through Visual Integrator

    While importing a job through VI for AP Invoices - if there are multiple lines on the same invoice, the job will not work correctly. Is there an easy fix to this. The invoice will either not show up in Invoice Data Entry or Sage will need to be prompted…
  • Bill.com

    Has anyone done any integrations or been asked to do any integrations with Bill.com? I have had several inquiries as the Bill.com site has the Sage logo, but the integration they offer is for Intacct, not Sage 100 ERP. I have mapped it out to be able…
  • VI job error in VI_ImportAssignValues.pvc

    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…
  • Have you ever had performance issues with Starship due to your UDFs? What is your UDF count?

    Hi all, We've been using Starship for years but in the last week have experienced major delays and performance problems EXCLUSIVELY with their integration (meaning other 3rd parties like ScanForce, Avalara, Paya, TrueCommerce, Insynch, etc.... are performing…
  • Visual Integrator - Big Commerce

    Has anyone tried to get a proper export from Big Commerce for a VI into Sage 100c 2021?
  • How to change VI job export column heading

    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!
  • I have used Sage for 30 years and need to utilize purchase order and inventory modules.

    Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.
  • Non-existent items

    We're currently using the Sage100 C# NuGet package noted below. We've run into a situation whereby a miscellaneous item (CI_Item) is visible in the UI and via OBDC connection however, we're unable to find the item using the MASRecordset utilities…
  • SAGE 100 2018 Integration with Odoo

    Hi, We are using SAGE 100 2018 Version for the last 5 years. We would like to integrate the following records from SAGE to Odoo using API. Can anyone let me know, whether integration is possible for this records. 1. Customer 2. Work order …
  • Anyone using Time Track for Job Costing, but exporting the time track entries for outside payroll service to process payroll

    Anyone using Time Track for Job Costing, but exporting the time track entries for outside payroll service to process payroll?
  • Import Orders with Visual Integrator

    I'm wanting to get orders imported started with a J and have them increment for every new order that comes in. I managed to get the J in there, but with using the "NEXT" order number. Is there a way to have the vi job check for the last order, then…
  • Looking for a Microsoft Power App expert

    Looking for a Microsoft Power App expert who can develop a power app application that will fetch data from the SQL database in bulk and then send that data to Sage 100 ERP via Sage 100 API connector which is already installed. Data to be picked and sent…
  • Best option for extracting data out of Sage 100 into Third-Party software

    We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
  • Looking for consultant to help in installation of Sage API into our sage 100 2020

    Hi, We are looking for consultant to help in installation of Sage API into our sage 100 2020. Please check below link for understanding: www.sagecity.com/.../getting-started-with-the-sage-100cloud-custom-connector-for-the-microsoft-power-…
  • Automatically Distributing Lot Number in S/O Invoice Data Entry through Visual Integrator

    Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…
  • Sage 100 integration with Concur Expense Management

    We have a Sage 100 client who is looking at Concur Expense Management. Has anybody integrated this with Sage 100? How did you do it? What were the difficulties? I'm looking for thoughts and/or recommendations. Thanks.
  • Is there any way by which we can achieve integration between ACT! and Sage 100?

    is there any way by which we can achieve integration between ACT! and Sage 100?
  • Sage100 Visual Integrator: Where to put ship to informaton?

    OK. This has me flustered. I have figured out how to use Temp fields in Vi for Sage 100 2019 to create a single SO that has multiple items on it. The data source I'm using has a separate row for each item purchased, and my current VI job creates one…
  • Documented needed to help create new modules

    My apologies if I'm not in the correct forum for this. (It seemed to match the best from the list I was presented with.) I'm looking for documentation on building modules to run from the Sage 100 desktop. I've taken a number of the courses (including…
  • Sage100 Visual Integrator Conundrum

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

    Is anyone out there utilizing HubSpot? And if so, are you transferring data both to and from Sage 100? Or just transferring data from HubSpot to Sage? Any problems with the integration?
  • Invalid or missing posting date encountered on Bill of Materials transaction update

    Hi, I've been working on automatic registration of transactions for Bill of materials. but I've been encoutering this issue for a couple of days now. its been throwing me an error that says "Invalid or missing posting date encountered" I opted…
  • BM Production register Error "The register must be printed prior to posting"

    Hi, I've been wondering if someone else encountered or might have a solution for this. Im getting the error "The register must be printed prior to posting" oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister…
  • BM ProductionRegister - New object error:200

    Hi, i've been constantly getting the error "System.Exception: <NewObject Error: 200>" when I register the BM production entries. here's what I have coded: oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister =…
  • VI Import to AR Invoice data entry version 2019

    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…