• Getting customer data from sage100

    I need to get customer data from sage100 using .Net code. I went through https://help-sage100.na.sage.com/2018/FLOR/index.htm but could not understand the functions as there was no clear instructions. I managed to get data from two columns using a sample…
  • How to filter in nGetResultSets or GetResultSets

    I am working on getting data from sage100 2016. I need to know how can I apply filter to data that I am getting using nGetResultSets. The documentation Sage100-2018 has shown what the function needs: FUNCTION GetResultSets(descColumn$, keyColumn$, dropBoxLoad…
  • 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…
  • 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…
  • excel is running into problems with 'report designer add-in 1.2.0'

    Why does this continue to happen on reports running through the microsoft scheduler when the report does not use the report designer? excel desigmer error.docx
  • Does Sage HR offer an invoicing method?

    Does Sage HR offer an invoicing method for its services, and if so, could you provide details on how the invoicing process works?
  • Error while writing a Purchase Order Invoice using C# to Sage 100 US

    Sage 100 Code: CI_ValGrpPORequired, Message: A purchase order number is required. when calling nSetValue with parameters InvoiceNo$, {InvoiceNumber} Could anyone please help me with the meaning of the error code CI_ValGrpPORequired. I have made…
  • How to create a production Entry but keep the lines that populate without adding or changing existing lines

    I'm trying to create a production entry. It works fine if I add lines but if I don't add any lines I get an error message saying I need at least one line. In the Sage UI you can select a Bill Number and it pre-populates the lines, I'd like to do the same…
  • Sage alerts w/crystal reports error

    I am trying to attach a crystal report to a Sage Alert. I have crystal reports installed on the Sage Alerts server and Sage 100 workstation installed as well. I have the SAP Crystal runtime engine for .NET framework 64 bit installed as well. The alert…
  • Create PO Purchase Order in BOI c# on Sage 100

    Hello, getting an error: Invalid or missing header on the code below- can anyone provide a working example of creating a purchase order in BOI? using (var sySession = new MasSession(homePath)) { sySession.InitSession(sessionLogon); CI.ColumnNames…
  • SAGE 100 PREMIUM BOI - Failed to Initialize ProvideX Library

    Hello, I am trying to setup BOI (first time trying this) we are running Sage 100 Premium 2021 (ps. this hasn't been tried done before this). I am following along with the Object Interface course from Sage. Im entering the Path to our Sage Folder as stated…
  • Error message: Cannot access the Sage 100 Integration Engine. Verify that the service has started (PushToMAS: No such host is known.)

    I have installed Sage CRM. I have set up the Integration Engine per the instructions. When I go to enter a new Company, Person, etc. - I get this message above the data entry fields: Cannot access the Sage 100 Integration Engine. Verify that the service…
  • 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…
  • BOI. Please, provide an example of a sample C# or VB code as a reference to write invoice using BOI which links to an Order

    Hi Team, Please, help me with this scenario. Scenario: Order is already created in the ERP Using BOI, write an Invoice to ERP that Integrates into an Order (The invoice will contain the Order document number(DO_Piece)). a) This invoice can also…
  • Loyalty Cards

    Greetings, we want to create Loyalty Programme at our workspace. We want to have Reward Cards including allowing people save money and buy or use their funds later. We will add a magnetic machine to use when reading the card and also scan the card. The…
  • 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 …
  • BOI not pushing web orders to Sage 100

    We are encountering an issue where CIM Cloud web orders are successfully pushing to the ERP Driver but is failing to create a BOI session. Any suggestions on what other pieces we can troubleshoot before reinstalling the ERP Driver? What we have tried…
  • Is the BOI going to stick around for awhile? Is there a better way to communicate with Sage 100

    I've been working with the Sage 100 BOI for some time now and have done a lot of C# applications that interact with the BOI for all sorts of Sage 100 integrations. As we all know the "API" is pretty clunky. I thought about creating a class Library that…
  • BOI with Webpage

    We have an intranet page we'd like to write to Sage with via BOI. For years we have used BOI in .NET desktop applications (using a dll containing 'wrapper' classes written in VB.NET) and its worked great. However when attempting to use it from a web page…
  • Sage CRM Persons/Sage 100 Contacts

    Hi All, I just wanted to confirm some functionality with the integration between Sage CRM and Sage 100. When creating a new Person in CRM for a particular company that is linked to an existing Sage 100 company, do you always have to click 'maintain…
  • Sage 100 Direct Deposit Service

    I am having a hard time getting a clear grasp on what exactly Sage 100 Direct Deposit Service is. I have a Sage 100 client that is an accounting firm and they process payroll for around 100 companies. Right now they need to generate an ACH file for each…
  • CustomerNo$ not on file

    We have no issues creating AR invoices in the ProvideX library with Sage 100 Advanced. We have several clients using our integration (all with Advanced). We were told our code would not need to change to support Premium (SQL). After setting up Premium…
  • Hopefully an easy one - Failed to load the ProvideX library

    We have no issues loading the ProvideX library with Sage 100 Advanced, however we're having an issue with Sage 100 Premium (SQL). We use the following c# code. It appears we're getting an error when it tries to invoke the Init method. Stack trace is…
  • Please make Sage 100 Integration Engine Service Optional or a separate installation

    Please consider making the Sage Integration Engine Service setup optional or a separate installation. We don't always have the credentials needed to create the service If we do have credentials, then there's a risk IT disables our account after…
  • Sage InTaact

    Anyone here move to inTaact? Looking for unforeseen issues with the cloud Sage product