x Want to participate? Join the group to interact

  • get control property list box focus

    Hi, No return value for list box focus event property. How is this property trigger, by clicking on the list box control? Any information would be helpful. Regards -SKG

  • Sales Order import bypass VB scripts

    Is there a way to determine if a Sales Order is being imported, so I can bypass VB Scripts?

  • Sales Order To PO Address and lines button script

    Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…

  • Sales Order Invoice Printing with Batches Enabled

    Has anyone had any luck creating a BOI script to print and update invoices when batches are enabled? I keep getting a message stating that batching can't done in the current task. Here's a snippet of my code: retVal = oSS.nSetProgram(oSS.nLookupTask…

  • Update UDT whenever Sales Orders are printed

    Greetings all, I was wondering if there is a way of updating a UDT whenever a Sales Order is printing via script. I have a customer that would like to keep track of the time between when the SO is printed and when the order is shipped. I figured I…

  • Not able to write using AR_InvoiceHistoryInquiry_bus object

    Hi, I'm trying to use vbs script to insert an entry into the AR_InvoiceHistory table using AR_InvoiceHistoryInquiry_bus object but I'm getting the following error: Can anybody please help.

  • Script to update SO line pricing

    A customer has asked for a way to update pricing on 1000's of SO, for some planned pricing updates they working on. My idea was to have a button script to loop through all SO, and all lines on each SO, triggering the Sage logic to calculate each line…

  • How to find different record, change field value, and write the changed record back to the file

    I have a UDF checkbox on the GL_Account maintenance called UDF_DONATION. What I want to do in the Table Pre-Write is to check to see if there is another GL Account record where this UDF_DONATION is already set to "Y". If there is another record with the…

  • User Defined Script - Problems Getting Child Handle

    I'm trying to accumulate the quantities of all the detail lines in an AR invoice, but only if the item is of a certain type. I defined a UDF for that checkbox, and put it in the Item Maintenance screen. I would like the total to update whenever a user…

  • Pre-Totals Script - Accessing Item Information Using oLines.GetChildHandle("ITEMCODE")

    I have a script on the pre-totals event, that loops through any line items, and needs to get item related information for a given item. The problem I'm running into, is that in certain cases, the script runs, but the item information is returned as blank…

  • Access the Lines on Transaction Tab in Item Maintenance

    Experts, I got a tricky one here. I have a UDF in IM_ItemTransactionHistory that contains a file path. Now I would like to be able to place a button in Item Maintenance on the Transactions tab that allows me to open the file. The code to open the…

  • oLines not properly filtered for new SO (in header scripts)

    Issue identified on a 2019 Premium system, but verified on unmodified 2021 Standard with ABC data. Column post validate script on SO Header (WarehouseCode). sSalesOrderNo = "" retVal = oBusObj.GetValue("SalesOrderno$", sSalesOrderNo) oSession.WriteLog…

  • Copy invoice from AR_InvoiceHistory to flat file

    I have most of this script working but am hung up on the part reading from the line detail object. I have created a button on the AR Invoice History Inquiry panel so that the end user can find the invoice they want to copy, press the button, and the flat…

  • Launch Sales Order Entry to create new order from Customer Maintenance and pass Customer Number

    Hi Sage City and Happy Friday! I have been working on a button script to launch Sales Order Entry from AR Customer Maintenance. The goal is to click on the button and open SO Entry, automatically select the next Order Number and pass the Customer Number…

  • Forcing Cancellation Code when deleting Sales Orders into history through BOI

    Good morning all, So I figured this would have been a relatively easy script but I can't seem to find a way of accomplishing what I need. I have a customer that would like to force a cancellation reason whenever you delete a Sales Order into history…

  • Is it possible to create records in AR_CustomerDocuments and AR_CustomerDocumentContacts via BOI?

    Hi forum folks and Happy Friday! I have a customer that would like to CC a specific inbox any time we send SO Invoices and orders via Paperless Office. We have been doing this by adding this CC email to the "To Additional Email Addresses" Field under…

  • User Define Script on User Define Table

    Hi, Below is my script to Prompt user a warning that when user entering invoice data entry, it will check a udt for blanket PO is out of fund. I've create User Define Table to keep track of a listed PO and Billed Amount. The script is reading invoice…

  • run script without admin (COM exception failed to initialize provideX library)

    I see that there are lots of questions about this in the past, but I can't seem to find a concrete answer on how to move forward with it. I realize it has something to do with DCOM, registering the DLL, running client side verse server side.... But I…

  • Sales Order Line UDF Update during Invoice Data Entry

    Hi, I am trying to write a script that zero's out a Sales Order UDF during Invoice Data Entry. This is what I have, but it is not zeroing in on the exact sales order in my lines and it doesn't seem to be writing back to the sales order, although I have…

  • Set Sage field equal to UDF (user script?)

    Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…

  • <Error: 0 in Method UPDATEINT>

    Hi, I have the code below for automatic registration/update of the production transactions. I've been getting an error on the UpdateInit method. oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister = oScript2.NewObject…

  • Create Purchase Order Invoice via BOI

    Experts, I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…

  • <NewObject Error: 200> Source=ProvideX.Script.1 in set oUDT = oScript.NewObject("CM_UDTMAINT_bus" ...

    I'm getting the error m essage=<NewObject Error: 200> Source=ProvideX.Script.1 when accessing a UDT. I just installed the client on this workstation for the first time, though I suppose I can try reinstalling. I'm hoping I just have a small syntax error…

  • 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…

  • Manual Check on the fly Invoice Event

    I am unable to get a script to fire to modify the AP_InvoiceHeader when adding an invoice on the fly in Manual Check Entry. Goal is to copy AP_Vendor.Comment to AP_ManualCheckHeader.Comment to AP_InvoiceHeader.Comment. Have a similar feature in AP…

*Community Hub is the new name for Sage City