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 have a request to add an "options" button that will open a custom dialog box with various button scripts performing different functions. One in particular is hiding some elements on-screen for what I suppose is to sanitize some information for screen…

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…

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…

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…

I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

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…

Hello, I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…

Hi All, I am very new to VB Scripting and BOI in Sage scripting, Is there any training material or certification which is recommended for the newbies, please advise and recommend. Thanks AJ

Hi I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank . Later when there is an update on the Date…

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…

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…

Hi Folks, my company has to changes prices on a number of items on a somewhat regular basis, every month or so. having someone open each sales order that those items are on to hit the "recalc" button is a huge time spend. is there a way to create…

I located KB 19387 which describes how to create a batch file to run a VI import program. The routine requires the name of the the VI job which is readily available on the job listing and panel. I'm thinking I could use the same/similar batch file format…

I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below: retVal…

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 need an executable to run when the client Posts AP Batch to the Invoice Register. I cant add a user defined script to the AP Invoice Registry screen because i cant get to it with Customizer. Is there a way to get around this?

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 a script that works unless the field "UDF_EXCH_RATE" is zero. (default value is .000000) Where do I place the "if" statement to get it to work? tmpAmt = 0 : tmpExchange = 0 retVal = oBusObj.GetValue("ExtensionAmt",tmpAmt) retVal = oBusObj…

Hi, We have a script on Invoice detail which sets the Extension Amount on the line, the current trigger for this script is "Column-Post Validate" on "ItemCode". But when we generate invoices using AR Repetitive Invoice Selection, the script doesn't…