• 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…
  • 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…
  • Import of AP Bills - random errors

    Hi Experts, I created an integration that pulls CSV files with AP Bills from an FTP server and imports those into Sage 100. Every time the script runs it imports 20 to 50 AP Bills. The bills are often for different company codes, so the integration…
  • Sage 100 2022 BOI unhandled exception in 64-bit sales order entry

    I am writing an API in C#.net, that POSTs sales order entries to Sage 100, using BOI. I am using much of the same code that I've used for other integration projects with success. The client for this project is upgrading to Sage 100 2022 Premium- and testing…
  • BOI PO_PurchaseOrder creation.

    Background: We're using the C# NuGet package. When I have a session object (Sage100.ObjectManagement.MasSession), I'm able to do the following (though, actual creation inevitably fails because of needed line items). var createObject = session.CreateObject…
  • Sales Order ShipTo address being ignored

    I have a C# dotNet 4.8 web application providing API services into Sage 100, working fine at multiple sites. At one customer, the Sales Order BOI seems to ignore the ShipToAddress fields on the sales order. Avatax and Scanforce are installed on this site…
  • BOI SO_SalesOrder_bus call to nSetKey(key) fails, sLastErrorMessage = "This order is currently being shipped. The invoice number is [num] in batch [num]"

    Using the BOI and trying to loop through all Sales Orders and, for each Sales Order, loop through all lines. Have it working however some orders are in a state such that, if opened from the Sage UI, a popup is shown with text like: In the UI, I can…
  • BOI Update Receipt of Goods Register Sage 100 Premium 2022 BOI

    Hi All, I am having an issue running PO_ReceiptRegister_upd. I am trying to run the Receipt of Goods Register from BOI. oSS.InvokeMethod("nSetDate", "P/O", date); oSS.InvokeMethod("nSetModule", "P/O"); //DispatchObject security = new DispatchObject…
  • C# Create Sales Invoice From Sales Order; nSetKey() fails, sLastErrorMsg = "The [InvoiceNo] is invalid"

    I am on Sage 100c Standard 2016 (Version 5.30.5.0) (yes, I know it is very old, and have plans to upgrade to a supported version). I am attempting to create a program in C# that creates a sales invoice from a sales order. When my program executes the…
  • How to get business object names for table from Sage 100 BOI

    Is there a way to get a list of all the business object names for a table from the Sage 100 BOI? The SY_File object from the FileObj property on the session object seems to have methods to get a list of all the table names. Looking to expand on that where…
  • Forcing Price override for SO_Invoice Line

    I'm currently trying to integrate SO_Invoice using BOI and needing to override pricing on the line item, below is snippet of the code on the line level retVal = oSOInvoice.oLines.nAddLine() retVal = oSOInvoice.oLines.nSetValue("ItemCode$", "XX"…
  • creating a receipt of invoice with BOI

    Hi, I'm trying to write a code to create a new invoice from PO set the key ReceiptType$ set the key ReceiptNo$ call setKey() set PurchaseOrderNo$ set InvoiceNo$ Now i want to add the lines of the po to the receipt. In addition, i want…
  • Object Handle to UDT in PowerShell or C#

    Experts, I need to establish an object handle in PowerShell to a UDT. I know how to do it in VBScript. Does anyone know the proper syntax in PS? If not C# would be helpful as well because I could try to figure it out from there. For regular object…
  • Trying to set pricing, "The Price Code Record is Required" (even though it's set)

    {solved} The error was in my KeySet() line. Instead of: var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey", ""), pcObject).ReturnCode; It should have been: var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey"…
  • Exception on nWrite in CI_Item in C#

    Experts, I have a small app that writes to CI_Item. It has been working with no issues in Sage 100 v2017 Premium for my client in a Sage Server / Terminal Server setting. Now they are on v2020 Premium in the same setup (new servers), but we are running…
  • DCOM permissions and BOI

    Environment: IIS, .net CORE ASP.net web API, ProvideX.Script COM object (Sage 100/ MAS90 2018 v4.5), Server 2012 R2. Starting with the workaround first: so far my workaround has been to allow my IIS identity pool ID full access to the DCOM computer…
  • sage .NET libraries for c#

    I see some older threads discussing some in-progress ideas people were working with, as well as some libraries on the nuget packages out there - but there is no documentation on them that I can see. Does anyone have a recommended usage for them? Have…
  • Set Sage field equal to UDF (user script?)

    Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…
  • Create Purchase Order Invoice via BOI

    Experts, I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…
  • Sage 100 Export Sales Order to File BOI

    Hello, I am having difficulty getting some code to work. I have found examples, but translating it to C# is making it harder to solve the problem. I am trying to export a sales order through the SO_SalesOrderPrinting_UI BOI. the following settings…
  • Adding Misc Charge Items to Sales Order are not being added in BOI

    I am currently trying to add in a misc charge item to a sales order using BOI. soORDER.oLines.nSetValue("ItemCode$", "/SALESTAX") soORDER.oLines.nSetValue("ExtensionAmt", 10.00) soORDER.oLines.sLastErrorMsg #No error message. soORDER.oLines.nWrite…
  • Third party integration error when trying to import an order from Quoteworks to Sage 100 2018 Sales order

    The error that's generated during the process is misleading. I think there's something else going on which is preventing the process from completing. Here's the general error info: Processing the Document "DocumentNumber" in Sage failed Current Company…
  • Help with SO_Invoice_bus

    I'm trying to create a Sale Invoice via BOI and not doing something right, but not sure what. When I nSetKey, I get this error "You cannot use a credit card payment when credit card payment type is not set up." Thanks!
  • Handling pre-authorizations in SAGE 100 2017. Which field is analogous to CreditCardPreAuthorizationAmt field in SAGE 2014?

    We have an in-house built application that pre-authorizes a credit cards with external CC processor and updates SO_SalesOrder_bus with CreditCardAuthorizationNo$, CreditCardTransactionID$ and also sets CreditCardPreAuthorizationAmt. We have recently…
  • Is it possible to select all the customer's credit cards using SAGE BOI

    We have an in-house built application. The application uses BOI to integrate with SAGE. One of the forms inside the application needs to present the user with the list of customer's credit cards. Is there a way to find all the customer's credit cards…