• Writes not working from a event script

    My goal is on a new PO, update the SOs PO number and PO required Date values that are referenced in the PO. I have been able to go through the PO lines and find the SOs, but I can't seem to update the SO lines. I do not seem to be getting any failures…
  • oScript.Execute

    Hello I am trying to find any doc on "oScript.Execute", i am facing an issue i want to call a 3rd party app and want the script to wait till the exe completes its execution. Thanks
  • Error when running WScript.Shell object (OLE ERROR -2147024894)

    Hello Everyone, I am trying to run a 3rd party exe on a button click using VB Script , The code is trowing (OLE ERROR -2147024894) i have added the code and also the error message i got ********************************************************…
  • UDF using script

    Hello Everyone I am trying to update UDF in sales order line using script, i am not getting any error but it's not working i am adding the the code that i am using any kind of help will be really great Thanks ____________________________________________________________________________________________________________…
  • Trouble in write lines details to a UDT

    Hello, I have a script on cash receipt header table, post-write, will bring cash receipt header and detail to a UDT. It is working fine, EXCEPT, If there is more than one lines in the detail, it will only return the last line to the UDT. Only showing…
  • BOI Receipt of Goods Error #88 on nWrite

    I just spent a few hours troubleshooting something and figured that someone else might benefit from my experience. We have a receipt of goods integration that runs from AP invoices in our ECM system and creates a receipt of goods entry in Sage 100 ERP…
  • Get SalesOrder

    Hello I am using businss object to get SalesOrder for sage MAS90.I am using GetResultSets option to get.In it i am getting array of two columns.Is there way to get mutiple coulumns for this?
  • 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…
  • Script to track changes to a field in PO

    I've written a script to write field values out to a UDT and record a Date, User, and time so that we can have an audit trail of these fields in PO Header. The audit trail is written whenever a there is a change to the PO. This works fine for manual…
  • Why is a SetValue to oHeaderObj UDF not working when GetValue to standard fields does and the oBusObj is Sales Order detail?

    The events Table Post-Write and Table Post-Delete events: My script successfully retrieves oHeaderObj.GetValue fields, but when I write to a UDF I get a return code 0 and its value doesn't change. What are some other pitfalls? I've simplified the…