• How to add a change order to a job in the Job Cost module?

    Hello, I am trying to add a change order to a job in the Job Cost module using the BOI in the C#. I have taken the BOI course and understand the basics of how to interact with Sage using the BOI, and have been using the Object Reference documentation…
  • External Script to Loop Through Deposits in Batch

    I am attempting to create an external script that will update all deposits in a Cash Receipts batch in the event something was entered incorrectly during data entry (i.e. BankCodes, DepositDates, etc). It would appear that the script is working fine until…
  • Installation of the business object interface in a docker container

    I want to deploy my app in a docker container but for that I need to install the business object interface. The problem that I'm facing is that the installation is blocked from installation in the container even with scripts that execute the .exe as…
  • Sage BOI SO_PackageTrackingByItem_bus

    I am attempting to write a Sage BOI VBS program to read and write to the SO Shipping Data Entry Package Tracking By Item object and am receiving the error <NewObject Error: 200>. I am using a Sage user that has full access to Sage and have the company…
  • 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…
  • 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…
  • 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…
  • 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…
  • 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…
  • Matching Receipt of Invoice Line with One of Multiple Receipts of Goods

    I've got the following scenario: I create a PO with qty 1000 of Item A on it. I receive against the PO at two different times, so I make two Receipts of Goods against said PO. The first receipt I receive 500 of Item A, and add a charge to the…
  • 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…
  • How to Stop "Do you want to print Sales Journal?" prompt from happening in my script?

    I have my script working to select invoice batches in S/O Invoice Printing. Once the batch is selected the invoices are electronically delivered. This all works fine. It needs to run unattended with no UI. How do I stop the Sales Journal prompt after…
  • 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…
  • Sales Order Invoice Printing with Batches Enabled

    Has anyone had any luck creating a BOI script to print and update invoices when batches are enabled? I keep getting a message stating that batching can't done in the current task. Here's a snippet of my code: retVal = oSS.nSetProgram(oSS.nLookupTask…
  • 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…
  • PO Receipt of Goods - Set OriginalOrderQty on existing item

    As a follow-up/refinement to my previous question, I am wondering how to set the OriginalOrderQty on a line on a Receipt of Goods that I have entered by hand. In an effort to isolate my issue, I have created this PO ( here ) and this Receipt of Goods…
  • PO Receipt of Goods - Receiving existing line and adding new line not writing new line quantity

    I have a PO that I am receiving against. I want to receive part of the line that exists as well as add a new line. The existing line is received as expected. However, when I try to add the new line, it creates a line with the item code and unit cost…
  • Scripting References

    Hey does anyone know where to get the objectreference.chm file? In the object training and here in Sage City it is referenced quite a bit but I'm unable to find it anywhere incuding the portal.
  • PO_PurchaseOrderDetail_svc - UnitCost rounding

    Hello, I'm having rounding problem issue - in configuration I have decimal precision set to 4, in the Sage 100 (2022 version 7.10.0.0) my PO Item is stored correctly. Unit price for one of the items is 37.5950, but when I get date by PO_PurchaseOrderDetails_svc…
  • 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…
  • Error 88 on Sales Order Entry Lines

    We are experiencing an error 88 on Sales Order Lines. The error occurs only on large orders with numerous lines, especially when adding inventory items to the order on the fly. The line prewrite script is failing and referencing different UDT objects…
  • Button Script on Customer Maintenance to open UDT maintenance UI for a particular AR_UDT. The second step would be to pass the Customer Number to the CM_UDTMaintSelect_UI

    We would like a Button Script on Customer Maintenance to open UDT maintenance UI for a particular AR_UDT. The second step would be to pass the Customer Number to the CM_UDTMaintSelect_UI. This would work great as t here are multiple records in the UDT…