• 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…
  • DFDM Modifications to Allow UDT Field Lookups

    When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…
  • 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…
  • AP Manual Check Entry screen with UDF from another business object

    Hello, Can anyone help me with example code on how to get a User Defined Field in another object? I'm used to using oSession and oLines to get the header values and details for AP_ManualCheckHeader and AP_ManualCheckDetail. But I'm trying to get one…
  • 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…
  • RE: <Error: 0 in Method GetValue>

    80020009 Same problem here - SO and PO modules. Upgrading from Sage MAS 200 4.40.0.5 to MAS 100 2013 5.00.7.0. Tried on XP, Windows 7 (cmd as 32-bit), Windows 2012 Server Standard (cmd as 32-bit) support.microsoft.com/.../896456 (%windir%\SysWoW64…
  • "Permission Denied" when attempting to set the value SO Header UDF

    I am on 4.3 and am using BOI in Access VBA to update some fields on Sales Orders (headers only). I have a UDF field for Sales Order shipping priority. UDF_Priority is a drop box field with a length of 20 with 3 options: Staging, Expedited, and Normal…