Sage 100

Is it possible to write data into different company within some Sage 100 company. For Example add a button on Sales Order Entry to copy order to secondary company. I know how to do it outside of Sage with a script but not sure if session to different…

Is there a way to perform Period End using BOI? I don't see any handles for it, so my guess is it's not possible. Anyone else have more info? Thanks!

I've tried the below by following the write up, but no luck. retVal = oSession.AsObject(oSession.UI).MessageBox("","WARNING MESSAGE GOES HERE", "title=WARNING, style=OK, icon=stop, defbtn=2, Beep" ) Any suggestions?

I get an error "Module J/C is not on file" when attempting to reverse an electronic payment. Here is my code using (DispatchObject mCheck = new DispatchObject(pvx.InvokeMethod("NewObject", "AP_ManualCheck_bus", oSS.GetObject()))) { // Perfrom Check…

Hello Everyone, I am trying to run a 3rd party exe on a button click using VB Script , The code is trowing (OLE ERROR -2147024894) i have added the code and also the error message i got ********************************************************…

I have a system running Sage 100 v2017 Advanced (with update 1). In my script I'm returning the company code via a message box, but I'm getting a random company code, not the one that I'm actually logged into. Has anyone else had problems with the…

Afternoon everyone Working in 2017 100c Adv. Trying to get a UI script to work on the SO Lines tab that will disable a UDF from editing unless the user is an exclusion list. We cannot seem to get the UDF to disable despite all syntax efforts. If…

I have a requirement that a /Hand handling charge must be added as a new line, upon clicking Accept of the Invoice. I used a User Defined Script (UDS), and hooked into the Table-PreWrite event. The line writes fine. When the user re-opens the Invoice…

I am using a BOI script to check if the Unattended Barcode Import Task is running. If it is not running, the script starts up the UI for Unattended Barcode Import. But I need to programmatically press the "Proceed" Button in the UI. Any ideas? Is…

Is there a Prompt or Interactive Message Box available in a server-side script? I know that from a User Defined Script or a Customizer script that runs on the server, you can display a message box thusly: retval = oSession.AsObject(oSession.UI).MessageBox…

The below is a modified/shortened version of a script I am executing from outside the Sage 100 system. Purpose is to update some UDF's on two separate records in the same table (different key values). I simplified the naming structure, etc. to make it…

I'd like to trigger a script when a user clicks on the "Invoices" tab (and other tabs) in Vendor Maintenance. The goal is to restrict access to the tab depending on a UDF checkbox on the AP_Vendor table. Does anyone have ideas (or alternatives) on how…

I have BOI Script in the table pre-write events for SO_SalesOrderHeader and SO_InvoiceHeader that do regular expression searches in the ship to address fields for PO boxes when certain ship via types are used, as most of our ship to addresses should not…

I'm trying to write a script that will loop through all the lines of an order and put a check mark in a UDF. The trouble is that this doesn't seem to work with the oBusObj because the EOF is always false. Is there a way to accomplish this without having…

Hi All, Everytime I try to set the key, failed but its working on other MAS Version (Sage 100 Standard ERP 2015 - Version 5.20.3 - Providex) retVAL = oIM_TE.nSelectNewBatch(BatchNo, "N", "Created by Auto Import") '--> Good TransactionType =…

Hello, I am trying to write a script for lookup button in order to pull the salesperson data. I only want to pull the salesperson data whose division number is “00”. How can I pass ARDivisionNo as parameter? Here is the script which I am working on…

Hello All, I'm importing invoices using a BOI script. I'm getting errors stating the customer division is required and tax schedule is required when attempting to invoice an order on hold. The ID used has permissions to invoice orders on hold, so…

Hello all, I have a button script on repetitive invoice header which will pulls out a UDT. But what I want to do is not just pulls out the UDT, (cause it will show all the datas) but also filter the UDT values that shows only for this particular customer…

Hello, I have a script on cash receipt header table, post-write, will bring cash receipt header and detail to a UDT. It is working fine, EXCEPT, If there is more than one lines in the detail, it will only return the last line to the UDT. Only showing…

I'm looking for a way to keep a running total of quantity ordered by product line while entering lines on a Sales Order. There are 20+ product lines. Had there been fewer, I would have simply created UDFs representing the running total for each product…

So I have an odd problem. A customer is using Visual Integrator to run jobs. That's fine, they also use BOI in the User Defined Scripts, attaching to Read, Write events. The problem is the code in these scripts are ran when Visual Integrator is running…

Is there a handler that will allow me to access the Sales Order Tax Detail while in SO Entry? Much the same as there is a handler to access the Tier Distributions? 'handler for distribution of tiers Set oDistribution = oBusObj.AsObject(oBusObj.Distribution…

Hi All, Is there a list of the properties for the various control types? I am trying to work with Text labels using oUIObj.SetControlProperty(ctlName, propertyName, value),. I would like to hide labels based upon data on the screen to display the…

I am having trouble trying to create a new record using BOI for AP_VendorElectronicPayment. It is in the Object Reference, but I get a 200 error when I attempt to instantiate it. I have it typed correctly, and the user account I am using has access to…

I'm looking for existing script I can use to simplify our need to run a custom report during our quoting process for every order. Can anyone help me create a script that will calculate the entire Gross Profit/Margin for the whole Sales Order and display…