• Column PreValidation & reverting user entry

    Hi guys, To interactively approve or cancel an entered value by a user, is there a way to make it work just in PreValidation event? I'm working in SO_SalesOrderHeader The basic logic flow is as follows User enters a value in a ShipVia Script…
  • 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…
  • Split Sales order with a script

    Hello everyone, I was wondering if anyone has been able to split a sales order into two separate orders based on line information using a script. Would something like that be feasible?
  • File Picker Dialog

    I actually kind of figured that this would have been asked a few times, but my search attempt wasn't all that successful. The only somewhat related topic was Script to Select File , but the script I found here only displayed server-side files since it…
  • Sales Order GD_Lines Refresh

    I have a button script that successfully changes the price level on SO Lines but the changes aren't visible in the grid until either moving to another tab and then back to Lines or closing and reopening the sales order. Is there a way to refresh the…
  • Delete Change Items in BOI

    Is it possible to do this? I've been able to populate the IM_DeleteChangeItems table using BOI, but I can't figure out how to actually apply the changes to the item codes using BOI. If it's not possible that's okay, but please let me know if that's…
  • Permanently Enable Button on UI

    I have a button script located on a Cash Receipts Entry screen. Sage disables it by default until a customer number has been entered. The purpose of the button is to assist the user with locating the customer number, so this doesn't work for our use-case…
  • Button Script to Add Comment Line to GD_Lines Table in SO Invoice Data Entry

    From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card. First I actually…
  • 'Table' Does not have correct permissions, when running script

    Hi, I made a script in Sales Order Entry that loops thru the lines and changes a few fields based on the previous lines (trying to group lines together for a report). I'm getting an error now and after a lot of troubleshooting I realized that I only…
  • Script to find the Contact Code from the Confirm To in Sales Order

    Hi, I'm trying to write a script to find the Contact Code using the Confirm To in the Sales Order header so that I can populate some user defined fields in the contact code maintenance into the sales order header. I have this so far, but it's not finding…
  • Type mismatch

    Hello, I'm trying to convert numbers entered into a text field to an integer value. I have tried: number(textfield) CInt(textfield) but nothing seems to work. Any ideas? Thanks, Kevin
  • Creating a simple script to restrict specific GL accounts from certain users

    Hi, I am trying to create a script that puts the focus back on the GL account field when specific GL accounts are selected by user. So, when a user enters a GL account with a UDF_RESTRICTED value of Y, then Sage will focus back on the GL account and not…
  • SO Invoice Data Entry: Button Script to get Invoice No from an SO No

    I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker. Essentially, instead of the user typing the invoice # they would type the sales order…
  • Using python with the BOI

    We have a python (3.10) application that we want to use to create a sales order in Sage 100. I have installed pywin32 so the python script can access win32/COM. This code works up to the point where I try to call a method on the SY_Session object…
  • Script to Synchronize Customer Billing Address in Sales Order Data Entry

    I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…
  • How to use the "SO_PickingSheetPrinting" method "SelectOrder" to queue sales order picking sheets to be printed

    From a BOI script I would like to select individual orders so that a type "4" record will be added to "SO_SalesOrderPrint" table. The method "SelectOrder" calls for two separated string parameters: "hdrRec$" and "dtrRec$". This is confusing. Why would…
  • Using BOI to print Quote

    Looking to use the BOI to retrieve a quote as a PDF. Can see topics here about generating sales orders as PDF's, example: https://www.sagecity.com/us/sage100_erp/f/sage-100-business-object-interface/159332/print-to-pdf-and-electronically-deliver-sales…
  • Looping a table while batches enabled

    Hi, I want to loop through all my not-registered invoices. What I do (in general) is: dynamic obj = pvx.NewObject("AP_ManualCheck_bus", oSession); obj.nMoveFirst(); //To get to the first record //Rest of code The problem is that I have…
  • 100E - Sage 100 - Object Interface Course

    Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…
  • Sales Order Entry / Totals Tab / PaymentObj

    I believe the Deposit Payment Type on the Totals panel and other data reside in PaymentObj. What table is associated with this object? Where/how can I find the data?
  • Unable to drop object in event script

    I have a working event script tied to S/O detail that fires on post validation of quantity ordered. The script automatically creates a BOM Production Entry for the item entered, updates the production entry and updates the GL DTR. The problem I'm having…
  • GetResultSets pagination

    Is there a way to paginate the GetResultSets() function in boi? I'm thinking sort of like how in SQL, you can use OFFSET and LIMIT to divide the query results into multiple pages. Is there a way to do that with the GetResultSets() function?
  • Rebuild Sort Files using BOI?

    Has anyone been able to Rebuild Sort Files (and/or Key Files) using BOI? Last post on this topic from 12 years ago said no, but perhaps someone has figured it out since? I see the objects SY_Rebuild_bus in the Object Reference but am not certain if…
  • Button Script to delete Sales order with cancel code

    Hello all, I wrote a script with the goal to delete sales orders with a specific condition. So I can delete sales orders just fine its just that when the orders are deleted the cancel reason code is not flowing to history it is staying blank. I am…
  • Sage 100 BOI Script to Create Inventory Transactions

    I'm writing a BOI script to create Inventory Adjustment Transactions. I want to use the next available entry number so I have the GetNextEntryNo(refNo$) function in my script. What I can't figure out is what the "refNo$" needs to be. Does anyone have…