• 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…
  • 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…
  • Scanco Warehouse and Barcoding

    Good Afternoon Does anyone have feedback on Scanco Warehouse as a solution to automate receiving inventory transfers and shipping? If you have experience with this product would you recommend it? We are struggling with the decision as the receiving…
  • Create Sales Order Lines Object from MS Access Module ( Second attempt )

    Good Day, I hope this message finds you well. I am currently facing an issue with a control I've created in MS Access that interacts with Sage100 (Standard 2020 v6.20.4). I'm reaching out to seek your assistance in resolving this matter. The control…
  • Will Sage 2023 work with Starship 23.1.2

    Will Sage 2023 work with Starship 23.1.2?
  • Pay App Billing

    I am fishing here for someone to get in contact with that also has Sage 100 and handles pay application's with general contactors? We have now steered more towards pay app type customers who require us to bill through their pay application software. It…
  • Create Sales Order Lines Object from MS Access Module

    Good Day, I hope this message finds you well. I am currently facing an issue with a control I've created in MS Access that interacts with Sage100 (Standard 2020 v6.20.4). I'm reaching out to seek your assistance in resolving this matter. The control…
  • 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…
  • Sage 100 in WooCommerce

    We are inquiring to see if anyone knows if Sage 100 is able to be integrated with WooCommerce?
  • creating AP Invoice

    I have the following code working properly to post AR Invoices. var homePath = @"C:\Sage\Sage 100\MAS90\Home"; var userName = "test"; var password = "test" var companyCode = "test"; var sessionLogon = new SessionLogon { CompanyCode = companyCode, UserLogon…
  • Open Source: C# Helper to initialize PVX & OSS

    Hey all, As I've been learning how to implement BOI within a C# project I was really bothered by the amount of code reuse in my project surrounding instantiating the main BOI connections. This led me to refactor out that common code into a helper class…
  • How to get the customer master data

    Hi, I would like to extract the customer data from customer master using business objects. Can someone let me know, how to do the same. We are planning to integrate the customer master from Sage to Odoo
  • Sage 100 2022 & Starship V22.0

    We are using the on premises version of Sage 100 and Starship desktop. About 1-2 times per week the connector gets stuck and when connecting it literally gets stuck on connecting. If we go to the server task manager we have to end task on the Starship…
  • Visual Integrator - Big Commerce

    Has anyone tried to get a proper export from Big Commerce for a VI into Sage 100c 2021?
  • BOI Retrieving Invoice Line Serial Numbers

    On sales order invoice items can successfully use BOI to retrieve the SO_Invoice items, and for each item access the lines, however have not been able to collect item serial numbers for each line. For reference a screen capture showing these serial numbers…
  • 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?
  • Sage 100 JobCost Module BOI Script

    Hi all, I am working on the JobCost Maintainance module using BOI, Can you please anyone let me know what object I need to initiate for this?? Thank you in advance !! Thanks SF
  • 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…
  • Lotus Domino Sage 100 Integration

    Has anyone successfully been able to link there Sage 100 to email invoices from their Lotus Domino Server? If so what configuration did you use?
  • 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…
  • RMA Processing using BOI

    I am trying to duplicate the following UI process using the BOI: 1) Create RMA Receipt (header/details) for an Invoice. (Note that the procedure for us is to skip creating the RMA return in the UI.) 2) Distribute RMA lines. 3) Generate Transactions…
  • Paya Credit Card Settlement amounts are incorrect

    Has anyone have this happen to them? The Credit Card settlement report shows a lower amount than what the credit card payment screen showed when the card was processed. This is the second time this happened, but the first time Paya deposited more than…
  • BOI: The password for this user has expired. Do you want to change your password now?

    Hi, having a c# app to connect to Sage100 via BOI. Was working well till my password expired and login was not possible due to this error message in oSS: The password for this user has expired. Do you want to change your password now? What I did…
  • 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…