Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
With identical UDF names in both tables, the original value set into the SO Header UDF via a ColumnPostValidate script from a standard field works to flow the value to SO History Header, but subsequent successful updates directly to that SO Header UDF…
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…
Hi, I'm trying to write a script to find the Contact Code using the Confirm To in the Sales Order header so that I can populate some user defined fields in the contact code maintenance into the sales order header. I have this so far, but it's not finding…
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…
Hello,
I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…
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…
Hello,
I am a bit new to scripting on Sage and would like some assistance if anyone is willing. I am writing a script to update a UDF date field based on any change on the specifications Tab in Item Maintenance. I have attached my script below. I am…
I have a UDF on JT_WORKTICKET that totals a UDF field for each item on the Parts tab of the Work Ticket.
I would like to have that data populate a UDF on the Parent Item in the associated Sales Order.
Screen shots attached.
I can't find a means…
Not sure how to word this, but I'm trying to pull some values from PO_PurchaseOrderHistoryInqDetail_bus. The script runs with no errors (button script), but no data is returned. I have a working script that pulls from SO_SalesOrderHistoryInquiryDetail_bus…
I've got a button script on Sales Order Entry that a user can enter an Invoice number and a line number, and the script will copy that line to the Sales Order. Everything is working great, except I can't seem to get "VendorNo" to set. I'm getting the…
