• 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…
  • Trying to set PO ROG batch as "Private" through scripting

    Hey all, I'm having a fun time trying to do a seemingly easy task. We have a customer that would like to set all their PO batches to be private when they are entered, even when they are not selected to be when they are created. I figured I could set…
  • 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…