• How to Flow a UDF from Sales Order Header to SO History Header Reliably

    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…
  • 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…
  • Upgrade to Version 2020 with IM ItemCost UDF's Causes Button Script Failure

    A button script has been working for 8 years that writes 4 string UDF's and the TransactionDate started failing immediately after upgrading to 2020. After getting successful returns on all the SetValue statements, the Write fails (retVal = 0). The IM…
  • Possible to use a lookup for a UDF validating against a UDT?

    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…
  • Copying the Date value into new date UDF on the Invoice Data Entry

    Hi We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF. I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new…
  • 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…
  • Log who printed Picking Sheet

    I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below: retVal…
  • script for extended item description in BOM

    HI I am new to scripting and am trying to create a script for a client that will bring in the extended item description into t
  • 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…