Sage 100

Hi, I experiencing errors in customer maintenance on a custom tab. I'm using the debug window and found 1k+ lines on several clicks. Error:0 Error:11 Error:12 Error:13 Error:14 Error:2 Error:20 Error:23 Error:26 Error:27 Error:36 Error:65 Error…

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

Hello, We have added many panel customizations including additional tabs, buttons with scripts, etc that are important for many of our users. I was just resizing a field in customizer, and when I went to exit the customizer an error popped up saying…

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…

We have some standard price level codes we use that are set up for each item, if you are a wholesaler you get X price, MSRP has its own price code, etc. The descriptions for these codes are universal, W always would be described as wholesaler for example…

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.