• Trigger script during SO detail line addition

    On Sage 100 Advanced 2018: I have added a UDF checkbox to CI_Item and SO_SalesOrderDetail, linked so that when a new item is added to the Lines grid the default checkbox state from CI_Item is auto populated. If the value in CI_Item is checked I don…
  • 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…
  • Need to to get the LineKey after saving a SalesOrderDetail item.

    My goal is to get the LineKey after saving an order line item. Getting the SalesOrderNo is easy because I just used nGetNextSalesOrderNo before creating the SalesOrderHeader. Then as each detail item is added I need to return the LineKey of that item…