Sage 100

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…

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…

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…

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 ?

We are experiencing an error 88 on Sales Order Lines. The error occurs only on large orders with numerous lines, especially when adding inventory items to the order on the fly. The line prewrite script is failing and referencing different UDT objects…

We would like a Button Script on Customer Maintenance to open UDT maintenance UI for a particular AR_UDT. The second step would be to pass the Customer Number to the CM_UDTMaintSelect_UI. This would work great as t here are multiple records in the UDT…

We have Sage 100c 2022 with Operations Management. I would like to add a button to the Work Ticket Printing screen that replaces the Print button, launches a script to cycle through the JT_WorkTicketAttachments file for all attachments for the current…

how to add script on posting Process button to validate posting date? we want the posting date in same month with all PO receipt invoice date, but some times type may happen.

client has requested to have a button link in the sales order entry screen that will pull up the bill of materials inquiry for the item selected. I've done this before to launch item inquiry which requires a single parameter, but I'm having difficulties…

I actually kind of figured that this would have been asked a few times, but my search attempt wasn't all that successful. The only somewhat related topic was Script to Select File , but the script I found here only displayed server-side files since it…

Posting this in case it helps someone else. Client is on SPC (new), v2022.2, and we received this error when trying to add a UDS (clicking the green check-mark button to verify syntax). The script host was properly installed (and Allow External Access…

I had a script on a Table Pre-Write on the SO Header and I needed to turn it off for a while so I deleted it and recompiled the UDS. However, on our SO's I still see the output from the script running? Should I add something to the script to not allow…

Has anyone attempted to script the automatic selection of "Backorder Item" anytime the "Entry Exceeds Available Quantity" screen pops up?

I'd like to access the header of a PO receipt from a script attached to PO Tier Distribution. This possible? Or at the very least, the other way around (handle to tier distribution from PO Receipt Header script)?

I have two scripts running on the SO Invoice Date Entry Header, one on a pre-totals to change the "MultipleSalesOrdersApplied$" field to "N", this works no matter if there is more than one SO applied to the invoice. My next script is a post read to change…

While creating a UDS to dynamically display the total order gross profit for a sales order, I discovered that a change to a UDF in the SO_SalesOrderDetailed table while in the Sales Order Data Entry lines panel corrupted the UI display even though the…

We're using Batches in Shipping Data Entry and want to suppress a specific batch from being selected when running "Daily Sales Reports/Updates." For example, in the screenshot below we want the print option for batch PACK to be disabled, or filter out…

Hi... I'm trying to create a udf on the item maintenance main tab that will pull from that item's general alias and show in this udf. It appears maybe a script is the only way to do this as the alias table does not show for the udf. I tried a script…

Hi, I am trying to create a script that puts the focus back on the GL account field when specific GL accounts are selected by user. So, when a user enters a GL account with a UDF_RESTRICTED value of Y, then Sage will focus back on the GL account and not…

In Sage ERP 100 Purchase Order History Inquiry, the Receipts button click will show this PO first receipt info. When there are duplicate receipt NOs in PO receipt history record, this will only show the first one that match the receipt no, even though…