x Want to participate? Join the group to interact

  • 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…

  • Copy UDF Values from AR_CUSTOMER.M4T to Equivalent UDFs on new Sales Orders

    New to this forum, and new to using the Business Object Interface. Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…

  • 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…

  • User defined script in AP invoice Data Entry is not working returning the Job Cost variables...

    I am trying to warn the user with a message when entering an A/P invoice and selecting a Job that is no longer active. Since there is no Active/Inactive jobs in J/C ,module, the customer is using the Sort field for this purpose. For jobs that are active…

  • CODE - Customer Maintenance

    I'm having issue trying to get into Customer Maintenance from Script. This was working before, but has become an issue over the last week or so. I don't remember changing anything. Maybe you can spot check me to see what i am doing wrong. Shell (…

  • Creating a New Line Item in Common Information using BOI

    I'm stuck and can't quite figure out why. Below is a script I wrote to add a new line item to the CI module (I copied and pasted from several places). If SetSession("C/I", "CI_ItemCode_UI") Then writeLog("Connection Complete - Item Maintenance") Try…

  • Set freight amount

    Hi all, First script first post. Task is simple for one customer set freight amount field to negotiated amount that is based on the sales order total amount. Script is attached to pre-total event and it always works BUT only if sales order has more…

  • 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…

*Community Hub is the new name for Sage City