• 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…
  • 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…
  • 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…
  • 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…
  • 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
  • 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…
  • Microsoft's Deprecation of VBScript

    Hello, I saw that Microsoft is moving to deprecate VBScript in Windows. Resources for deprecated features in the Windows client - What's new in Windows | Microsoft Learn I know it will be around for a while before this is done. However, I am curious…
  • 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.
  • O365 integration w/Sage 100

    Hello we have an inquiry into [email protected] to sign up for the Microsoft 365 integration with Sage 100, but it's been 2 weeks and we have not received a response. Does anyone have any advice on how to reach them alternatively or how to escalate…
  • 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…
  • Access Office 365 Crashes when Connecting to Sage 100

    Has anyone else had issues with MS365 Access crashing when trying to connect to Sage 100 2022 via ODBC 32 bit connection? We just upgraded, and now when I try to connect the program (Access) crashes and closes. The same version of access will still connect…
  • 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 …
  • Office 365 Integration

    I am about 30 days in to trying to get the Office 365 Integration to function properly with my Sage 100 Cloud 2022 software. I have successfully followed all instructions here: https://help-sage100.na.sage.com/2018/Subsystems/LM/LMOffice365Proced/Setting_Up_Office_365_Integration…
  • Office 365 Integration

    I am trying to Set Up Office 365 Integration with my MAS 100 Cloud installation. I successfully installed the software and followed all steps as outlined here: https://help-sage100.na.sage.com/2018/Subsystems/LM/LMOffice365Proced/Setting_Up_Office_365_Integration…
  • Issue updating Inventory Transaction Receipt Multi-Bin Distribution using BOI

    When attempting to create line items for a Inventory Transaction Receipt batch I'm having issues when I attempt to update the distribution. my code was working on Sage 2018 but they are upgrading to Sage 2021 and it now throws an System.Runtime.InteropServices…
  • microsoft office professional plus 2021

    Is Sage 100 2022.1 compatible with Office Professional Plus 2021? I have it installed and my ALE lookups do not open in Excel, Instead I get Error 65, Windows element does not exist or already exists Program: SY_EXCEL.PVC statement 165 Class SY_EXCEL…
  • nSetKeyValue returns 100006 and Triggers VBA Error 438 but sLastErrorMsg is Empty

    I'm using the identical code to nSetValue R/W fields that has worked for years, but I am finding that it fails for some tables even though they show a R/W Business Object. I am modifying a non-key field in GL_DetailPosting, but I cannot get past the nSetKeyValue…
  • C# BOI example of creating an AR_Invoice with lines/details

    Is there anyone that can help with providing an example of creating an AR Invoice with lines/details in C# using either BOI or the nuget package www.nuget.org/.../
  • Sage100.ObjectManagement Interfaces .net Error when creating line entry

    var sessionLogon = new SessionLogon { CompanyCode = companyCode, UserLogon = new NetworkCredential { UserName = userName, Password = password }, ModuleCode = ModuleNames.AccountsReceivable, ModuleDate = DateTime.Today }; using (var…
  • Attempting to pull data into Excel from a UDT. Receive "Expression.Error: The key didn't match any rows in the table." in Power Query.

    Attempting to pull data into Excel from a UDT. Raw data will pull, but, when I try to edit Query, receive "Expression.Error: The key didn't match any rows in the table." in Power Query. See screen shot : Any Thoughts? I have used "syzcon" running…
  • Script for "Daily Sales Reports/update" using BOI

    Hi I am looking for a script to update "Daily Sales Report/Updates" in sales order (sage100 v2021). Could anyone suggest me what script i can use in BOI suing c# or VB?
  • Microsoft Surface Barcode Scanning

    Has anyone used a Microsoft Surface to scan barcodes within Sage 100? All I am trying to do is have the cursor in the "order number" field in SO entry and be able to use the surface to scan a barcode on the actual SO paper to avoid having the user type…
  • 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-…