• Update UDT whenever Sales Orders are printed

    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…
  • Sage 100 SQL - Use Script Tied to Button on Production Entry Header to Open UDT Screen and Return Data From UDT to Production Header

    Is it possible from the Production Header panel, via a script, either tied to a button click event or on one of the table events, to open an existing UDT (so that the user can see the UDT), then get a value from it and set a textbox on the Production…
  • Not allowing to delete a PO with Prepayment scripting...

    I have a script that launches if a user attempts to delete a Po with a prepayment. Here is my script. It works when the user click on Delete button on an existing PO with prepayment. The problem is however, it removes lines of the PO. I have this script…
  • Script to retrieve primary vendor alias

    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…