Sage 100

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…

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…

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…

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 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…

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…