Sage 100

Hello, We have a custom-defined script that triggers Post-Write on the table CI_Item. This script then reads the field 'ItemCode' of that table. We also want to extend this by triggering this script with other tables. I am seeking a way to retrieve…

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…

To reproduce, in either 32-Bit or 64-Bit Sage 100, create an "Execute Script on Server" button in either Customer Maintenance or Item Maintenance (maybe any panel) that runs a simple two line script: retVal = oScript.InvokeButton("BT_LINK_2") retVal…

I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed. I am now receiving an error 88 type mismatch (error window below). Any thoughts? START OF CODE Dim retVal Dim cpwgt Dim cpwgtstr Dim…

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…

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…

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…

I created a button that runs a simple VBScript that checks if a customer is set up on paperless or not. The problem is that while I am modestly proficient at VBS, I don't know anything about the Sage Object model. I first attempted to have the script…

I have most of this script working but am hung up on the part reading from the line detail object. I have created a button on the AR Invoice History Inquiry panel so that the end user can find the invoice they want to copy, press the button, and the flat…

Hi all, Does anyone have any suggestions on how to incorporate user-defined functions and additional sub routines in UDS? I have a working (pseudo-codes below), intended to be assigned to Table_Post-Write event for AR_Customer_bus. Basically, there…

Experts, I have a complex script that fires on the Panel PostLoad event of PLINES in SO Entry. The script colors lines based on some conditions and works great. It is based on a script that I got from a ScriptingClass a few years ago. The issue with my…

I am trying to check to see if a sales order has been completed from an external VbScript. I'm guessing I'm not hitting the right object. Any suggestions would be appreciated. Public Function IsSalesOrderComplete(strOrderNo) Dim so, rtnVal, status…

I have general question about writing button scripts in AR_Customer where I can write data to the fields. My goal is to update and address Customer Maintenance Main 1: menu with a button that fetches data. What I have working is the pulling data from…

Is there a way to trigger a User Defined Script when a Sales Order is closed without any changes being made to it?

I have a script that has been running for years to verify login credentials in Sage. I just setup a new workstation and am getting the following error when running this script. Error: <NewObject Error: 200> Below is the code leading up to this. It…

Hi everyone, I see many examples of processing a report in BOI, like this one . But all of them are VB/.NET or C#. Could someone please help me translate the syntax to UDS work with Events like Column_PostValidate? Below is Bret's example of Previewing…

I have a vi Import job that does cash receipt entry. Occasionally the vi job fails. The result of the failure I believe is caused by a pop-up dialog that I am getting with the following message "The invoice balance was exceeded. Do you want to continue…

I need to run a script after a sales order is saved. The Post-Write doesn't work, because the data is not yet in the tables when the Post-Write script runs. My script prints a specific sales order form for the order being saved, but on new orders, since…

I'm trying to pass a filepath in a button script (MAS 200 "Execute on Server"). I can't get the variable to take the literal string that I assign. Here's what I mean: sample script: sAttach = "\\fileserver\folder\file.pdf" retVal = oSession.AsObject…

I'm trying to add an MS Script button to the SO Invoice Data Entry panel. In the script I need to access the LOCAL cCurrentPaymentTypeMethod$ property inherited from Class SO_CommonEntry_UI. Can this be done and, if so, how would it be coded?

I'm new to scripting and having a little trouble. I'm trying to grab the primary vendor alias for an item from IM_AliasItem and put it into a UDF in CI_Item. This will probably be triggered on reading the item record, if that makes a difference, but I…

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…

Sage 100 ERP 5.00.8.0 We are adding a button to our Shipping Data Entry that calls for a print of an invoice based on a Sales Order Number. I am consistently getting the following two errors: 1) "The S/O0000000022SO_INVOICEPRINTING_UI STANDARD 00001…

Hello, I am new to Sage and was wondering if someone could point me in the right direction on how to add a new customer by using vbscript.

I currently have a udf that gets data from another udf in po and bm lot/serial distribution. I am looking for a new udf that I can update with an input box, where I don't have to do a transaction. Searching on here I have found scripts allowing people…