• 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…
  • User Define Script on User Define Table

    Hi, Below is my script to Prompt user a warning that when user entering invoice data entry, it will check a udt for blanket PO is out of fund. I've create User Define Table to keep track of a listed PO and Billed Amount. The script is reading invoice…
  • Need Sales Order Header Script to compute Standard Cost based Margin on ENTIRE Order, on totals tab.

    I'm looking for existing script I can use to simplify our need to run a custom report during our quoting process for every order. Can anyone help me create a script that will calculate the entire Gross Profit/Margin for the whole Sales Order and display…
  • Trying to update Sales Order Header UDF from Invoice Entry getting error

    I'm trying to update a user defined field in the Sales Order Header table using a script from Sales Order Invoice entry from the Table - PreWrite event. The script saves the USERCODE from the session object into a UDF in the Invoice and then tries writing…
  • User Defined Scripting

    I have created a JobNumber UDF and added it to AR and AP invoice data entry line detail. Now I would like to create a User Defined Script for the actual Job Number entered during data entry to be written to the JobNumber UDF. In AR it comes from the header…