Sage 100

In purchase order entry, lines tab, there is a sales order number field. Although that field has a lookup button, it does not appear to be validated. Users seem to be able to type in anything they want that's not a valid sales order number. Is this a…

It's me again. Looking into using VBA or potentially a vb.net windows form app to potentially create and update Cash Receipt Batches & Deposits. External scripting documentation seems to be pretty limited and I am not sure where to even start when it…

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…

Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…

I have a vb script for the SO object and when my validation fails I want the Lines panel to have focus to minimize the user having to click it.

Hi All. Using Sage 100 2022 Advanced. I am having an issue with the below script where it runs but then fails on objShell.SendKeys"CREATEITEM"&(NRF). It is executing on client side. Note sure where the issue is. Basically it cancels the item maintenance…

Hi, Is there a simple way to get around this to add a display-only field twice in the same object but on a different panel? I have thought of a few ways but none are easy. Thanks, Gordon Graham

I am working on an issue after a new a install of Sage 100. The font on the Sales Order Entry Module is tiny. ( See attached Pic ) . I have adjusted the resolution and scaling in Windows. But this has not made any difference. All other Sage modules and…

When use client side script, MAS_SCR_USR is the current user log on, what is the current user password constant, in my client script, it will also run an external BOI app, needs current username and password to pass to it. Thank you

Have a need to lock the unit cost field in ROG, but unable to do so in custom office. Is there another way around this? Maybe a script? Looking for functionality just like this post: www5.v1ideas.com/.../40042

SAGE 100 - Can I create a pop up alert in "Invoice Payment Selection" Process? I need to set a particular reminder about a vendor every time I do a check run.

Some questions on the 2022 interface. Tasks/Modules: The tabs feature in 2014 is a better design...so how do I delete the default Taskview items? Are the default taskview items configurable based on the user type. There is no reason to display all…

Greetings all, I was wondering if there is a way of updating a UDT whenever a Sales Order is printing via script. I have a customer that would like to keep track of the time between when the SO is printed and when the order is shipped. I figured I…

Hello, Is there anyway to edit the field size of an existing field, not UDF. I want to resize the Comment field on PO order entry to be larger than 30 characters is there a way to do this. I used Custom Office then Advanced settings for PO Header…

Hi, I have a script for the "UnitPrice" field in Sales Order Detail that triggers an alert if the price seems incorrect. I also have another script for "QTYOrdered" that occasionally modifies the "UnitPrice" field. The issue is that this second script…

when add one sales order line, we want some item default unit price automatically changes according to a price type defined in order header, which event should we use to trigger a script to get that price, I tried column pre-validate and post-validate…

I'd like to create a global user lookup via the User Lookup Wizard for a very particular lookup - the Sales Order Entry Item Code lookup, but the Miscellaneous item version of it (the one that launches when entering '/', then pressing F2. I THOUGHT…

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…

When I using a function or sub in event Column Post-Validate, and click Check Script button to check the VB script, get this OLE Error Number: 1002 error, however if I use same function in button click script where no Check Script, it works. looks like…

The identical script works in every other version, but 2023 64-Bit. I get this error at the point the oScript.InvokeButton(<<button name>>) method is used:

I'm trying to trigger a script that will set the "Auto Display" value to "Always" as a default on the AR_CustomerMemo. I've tested triggering a script with a simple message box on various events like, on Table Set Default Values, Table Pre-Write, and…

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…

Hey does anyone know where to get the objectreference.chm file? In the object training and here in Sage City it is referenced quite a bit but I'm unable to find it anywhere incuding the portal.

I want to perform a operation through VBScript , after that I want the cursor to be focused on a specific grid cell. How do I do That ?