• Update existing PO lines

    I am new to this so please bear with me. I have the following script ( i can only post a portion of the code. The SPAM blocker flagged it as malicious) that is used to update two UDF fields from a .csv file. It is called via a custom application. I am…
  • Creating PO via BOI Write Issue

    Hello All! I have an issue with creating a PO via BOI that I was hoping someone can help me with. We're using Sage 100cloud Premium 2019 Version 6.10.4.0. Here's my code: using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject…
  • Script to Generate Material Requisition

    I am having issues setting the Purchase Order lines with a GL Account code or key gathered from a SQL table. It doesn't matter what I try to pass, the system always defaults it to some obscure account code. All other fields I set work except for the GL…
  • Purchase Order Lines Script not behaving as expected

    We have a checkbox UDF in purchase order entry at the lines level called UDF_LINE_COMPLETED, when they check this box I would like to zero out the quantitybackordered field. I have tried this script as a column pre-validate and post-validiate on the UDF…
  • Event Script Idea

    I would like to check the detail lines within a PO to verify that all the fields have been entered. I'd like to either run the script after the detail line has lost focus or when the user clicks the "Accept" button. Basically I think going to place a…
  • Trying to use BOI to create PO, issue with Vendor Number

    Greetings, I am trying to use the following: retVAL = oPOOrder.nSetKeyValue("PurchaseOrderNo$", sPONumber) retVAL = oPOOrder.nSetKey() retVAL = oPOOrder.nSetValue("PurchaseOrderDate$", "20140529") retVAL = oPOOrder.nSetValue("OrderType$", "S") retVAL…