x Want to participate? Join the group to interact

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

  • Unable to get previous Sales Order Lines on table - Pre Write?

    Hello, I'm simply wanting to write the previous item code to a UDT when the line is changed in a sales order. For example, if the item code was abc123 and a user changed it to def456, I want to write abc123 to the UDT. However, each time I try to access…

  • VB Script to compare and update the date values for 2 date fields

    Hi I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank . Later when there is an update on the Date…

  • Update SO field from PO button script

    I'm trying to write a button script that will copy a single line from a SO and "pull" it into the open PO. I've done this successfully for SO (copying from Invoice or SO/Quote History), but with PO, I'd like to be able to "tie" the SO and PO together…

  • Automatically Save Changes on Event Script

    Without going in to the whole story we are trying to update some fields for auditing purposes and don't want the user to have the option to not save the changes to the order thus not having a record of the auditing information we are looking for. I have…

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

  • Is there a way......?

    I'm trying to create a custom dialog button in custom office on the SO Entry Detail screen to show some UDFs. The button would need launch a screen that allows me to put some UDFs that are linked to the line. If I create a custom dialog button in that…

  • I am trying to populate a UDF with the Gross Margin by line.

    I have created a script, and it does not seem to work. Do I put it under column validation, or some other mode. Here is the script. Retval=0 rExtcost rExtamount=0 rQtyship=0 rUnitcost=0 rLineGM=0 Set oLines = oBusObj.AsObject(oBusObj.Lines) oLines…

*Community Hub is the new name for Sage City