• DocumentTotal Bug?

    I should start off by saying we are still on v2020 for compatibility reasons. It appears that the `oBusObj.DocumentTotal` property (Sales Order Bus) doesn't calculate on quotes (it's value is 0). Is this intended behavior? The moment I change the order…
  • nFind returns 0 for AP Invoice lookup in AP_OpenInvoice

    I hope this is something easy that I'm overlooking. I'm looking up an invoice in the AP_OpenInvoice table that I know exists. I have confirmed that I'm passing the correct vendor division, number, and invoice number. But I'm getting a 0 return value.…
  • Sales Order Invoices don't get emailed from BOI script when run with Windows Task Scheduler.

    I created a BOI script that selects a batch of invoices, PDF's them, emails them, updates and PDF's the sales register and updates and PDF's the DTR in 2022 Advanced. The script works fine when run manually from the desktop. When running it from Windows…
  • Exit Table Updates Properly?

    I have encountered a strange issue with a button script that enters data into a UDT. I have been using this script in testing for about a month now and it hasn't had any issues until yesterday - even after a server restart. The first time clicking this…
  • 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…
  • Work Ticket BOI Change QuantityOrdered and Rescale Labor and Materials

    Using Sage 100 Advanced 2023 and the Production Management Module, I am trying to use BOI to update the Quantity Ordered on a Work Ticket but want it to automatically trigger the rescaling of labor and materials like it asks when you change the quantity…
  • BOI Purchase order entry to Receipt of GoodsGuidance

    Hello I am currently entering a Purchase Order into a Receipt of goods using BOI but the issue is when we don't receive an order fully it is leaving our items on backorder... Is there a way to get rid of pending backorder through BOI? or is this a bad…
  • Script to Loop through Invoice History Lines

    Hello, I was hoping to get some advice on scripting the BOI via a Button script that was placed on S/O Invoice Data Entry that would act as a "Quick Tax Credit" button. We use a third party cloud vendor to calculate our taxes but that shouldn't affect…
  • 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…
  • Grabbing the Currently Selected Invoice from Listbox

    In Customer Maintenance's Invoice tab I am wanting to allow accounting to have the ability to edit the Comment field from the AR_OpenInvoice table. Since this isn't the history table, it wouldn't affect the comment line for invoice history reprints, so…
  • Deleting a batch - am I missing something or is this a bug?

    I thought I'd done this before, but perhaps I haven't. The batch is empty. I've confirmed that. But the below doesn't delete it and the retval doesn't return an error. Am I missing something? I've confirmed that sBatchNo has the correct batch number value…
  • 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…
  • SO_SalesOrderHistoryDetail has records with a null SalesOrderNo

    I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…
  • Update UDT whenever Sales Orders are printed

    Greetings all, I was wondering if there is a way of updating a UDT whenever a Sales Order is printing via script. I have a customer that would like to keep track of the time between when the SO is printed and when the order is shipped. I figured I…
  • 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…
  • 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…
  • Has anyone been able to trigger a script on the Ar_CustomerMemo or other Memo tables?

    I'm trying to trigger a script that will set the "Auto Display" value to "Always" as a default on the AR_CustomerMemo. I've tested triggering a script with a simple message box on various events like, on Table Set Default Values, Table Pre-Write, and…
  • Upgrade from Sage 2016 to Sage 2023?

    I started working here 3 years ago, and there was an existing Sage 2016 installation. I've been meaning to upgrade it since I started here, but just haven't taken the time to do it. Yesterday I received a threatening email from Sage about TLS, and there…
  • 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 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…
  • Copy UDF Values from AR_CUSTOMER.M4T to Equivalent UDFs on new Sales Orders

    New to this forum, and new to using the Business Object Interface. Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…
  • Persistent connection to Sage BOI with PHP?

    Our company is working on a locally hosted PHP web-server that connects with our local Sage 100 instance for our internal use. So far it's working pretty well, but it takes about 10 seconds to open up a session in Sage 100 with the BOI and execute a script…