• SO Invoice Data Entry: Button Script to get Invoice No from an SO No

    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…
  • Script to Synchronize Customer Billing Address in Sales Order Data Entry

    I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…
  • 2016 - 2020 First oScript.SetError Method doesn't trigger an error message in Lot/Serial Number Distribution

    This UDS is a Column Pre-Validate on QuantityShipped against the SO Sales Order Tier Distribution table at version 2016 Std through 2020 Advanced. The SetError doesn't always trigger the error message, but it does fail (i.e. clear) the distribution number…
  • Silent and Unassisted Removal and Deployment Sage 100v 2019

    Does Sage support silent removal and deployment for client installs? We are using Sage 100 v2016 and moving to a new server with Sage 100c v2019. Is there a way to deploy a script to uninstall the client on all the machines and reinstall a new client…
  • Possible to use a lookup for a UDF validating against a UDT?

    Hello, I have a UDF/script combo on sales order entry which requires the user to input a customer of type "A" into the UDF if the customer placing the order is of type "B". The values allowed are located on a UDT which I use the UDF to validate against…
  • script a button for multiple keystrokes

    Is it possible to create a button with a script that is a sequence of keystrokes? Sage 100c 2016 sp5 from item Maintenance or Item Inquiry I would like to create a button that would take the user through a series of keystrokes. ALT 5 ALT W ALT Y…
  • Scripting Dilemma (Pre vs Post Table write)

    Hello, I am working on a scripting solution that sets a hard cap on the number of free sample items a salesperson can receive. I currently have a UDT set up that tracks how many of each product line a sales person has, and am able to write to that table…
  • Button Script to open Sales Order UI with parameter.

    Hello, I have been struggling to get this to work for quite some time and am starting to go crazy! I have created a button on the Invoice History Inquiry which opens up the Sales Order UI, but I want to pass through a parameter so that the Sales Order…
  • Script to transfer data to secondary company

    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…