x Want to participate? Join the group to interact

  • New Object Error 200

    I'm receiving the error: Message=<NewObject Error: 200> Source=ProvideX.Script.1 on a new Windows 2016 server (remote desktop server). This script was running on an older server and is still running on workstations running Windows 7. The line referenced…

  • Transaction Panel Sort Order

    The default sort sequence on the Inventory Transaction tab is ascending Transaction Date. Can the default be changed to descending? Or, if that's not possible, can it be done with a user-defined script on the Panel post-load event and what would the code…

  • Unable to get previous Sales Order Lines on table - Pre Write?

    Hello, I'm simply wanting to write the previous item code to a UDT when the line is changed in a sales order. For example, if the item code was abc123 and a user changed it to def456, I want to write abc123 to the UDT. However, each time I try to access…

  • Multiple table writes requires multiple Objects? (Audit Script)

    Hello, I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…

  • Scripting in cash receipts

    Hi all, I have done some scripting before where I write in lines to things like Sales order and Purchase order but have not ever tried cash receipts and it looks like it is a bit different based on what I am seeing! I am hoping someone here might have…

  • Can you trigger a script to open Customer Inquiry when clicking on Totals tab in SO Invoice Data Entry?

    I am not well versed in scripting, but I know it can do a lot of wonderful things. I'm hoping this will be possible. I have a customer that creates credit memos but they do not always apply them. They would like a way to checking their customer's invoices…

  • How to Launch "Daily Sales Reports/Updates" in a script

    I located KB 19387 which describes how to create a batch file to run a VI import program. The routine requires the name of the the VI job which is readily available on the job listing and panel. I'm thinking I could use the same/similar batch file format…

  • Script to Return lowest price

    Does anyone have a script for over-riding the price on a sales order with the lowest price ? Some of our customers get product line discounts that result in a lower price than the current promo price. It might be like that for every SKU in the product…

  • How to Reference Inherited Objects/Properties in Panel Script

    I'm trying to add an MS Script button to the SO Invoice Data Entry panel. In the script I need to access the LOCAL cCurrentPaymentTypeMethod$ property inherited from Class SO_CommonEntry_UI. Can this be done and, if so, how would it be coded?

  • AP Invoice Data Entry - How to Clear Invoice Date Auto Populated

    In AP Invoice Data Entry, when user selects invoice no, the invoice date will be auto populated. Is there way to turn this off? My business partner told me script might be required if I want to clear the invoice date. I did the similar thing in Sales…

  • Script - Sales Order Line - Promise Date Change

    Hi, I need to change Promise Dates on multiple Sales Order Lines for a range of item numbers. I wrote a little script that connects via ODBC into Sage and grabs the SalesOrderDetail information for the items that need to be changed and puts it into…

  • Passing a parameter to Crystal Reports using a button script

    Hi All, I have created a new report that is launched from a button script. I have one thing left to accomplish & the syntax is killing me. Several things to get "out of the way", this is being done is Sage 2015 Premium. What we have wound up doing is…

  • Script to trigger from VI - Problem with Exit Sub function

    Hello, I have been working on a script that launches after a visual integrator job and have run into an issue with the Exit Sub function. I have seen other threads about how you have to define the Sub first when triggering like this but can't quite…

  • Can someone help me understand SetStorageVar and GetStorageVar?

    I'm trying to use a script to store the ShipToAddress1, 2, and 3 field values prior to having a script fire off a button click which does an address validation through a 3rd party plugin. I have the address validation working. However, I cannot get the…

  • Use "Confirm To" Field to look up "Telephone 2" Field in SO

    I am trying to place the <Telephone2> field in AR_CustomerContact on the SO_SalesOrder Header. I am placing it over the Fax Number Field as we don't use fax numbers much. I have created a UDF in SO_SalesOrder Header file to hold the value, and have placed…

  • oScript.InvokeButton("xxx") Alternative in BOI Script

    I am using a BOI script to check if the Unattended Barcode Import Task is running. If it is not running, the script starts up the UI for Unattended Barcode Import. But I need to programmatically press the "Proceed" Button in the UI. Any ideas? Is…

  • Unable to use paperless office from an external BOI script yet the same script will work when launched from a button or table script

    Hi community, running sage 100 advanced version 2015. I've got a puzzling scenario. If i attempt to launch a rpt business object from a button script, i can leverage and send the document to paperless office. Yet if i run the same code formatted…

  • Scripting adding extended description

    Hi All, I know I must be missing some basic concept here. I have a client that wants to insure that all items have an extended description. Here is what I have: sType = "" retVal = oBusObj.GetValue("ItemType$", sType) If sType <> "1" Then Exit Sub…

  • Stop use of unfinished items

    Hi All, I am working on what should be a pretty simple script. Got it to work but then changed the trigger for it and now I cannot get it to fire off. I have setup one of the categories in inventory as "Raw". I will enter Y in the items that I want…

  • Is AP_VendorElectronicPayment_bus available through BOI?

    I am having trouble trying to create a new record using BOI for AP_VendorElectronicPayment. It is in the Object Reference, but I get a 200 error when I attempt to instantiate it. I have it typed correctly, and the user account I am using has access to…

  • Need Sales Order Header Script to compute Standard Cost based Margin on ENTIRE Order, on totals tab.

    I'm looking for existing script I can use to simplify our need to run a custom report during our quoting process for every order. Can anyone help me create a script that will calculate the entire Gross Profit/Margin for the whole Sales Order and display…

  • Script Error 88 Message

    Have a script that runs fine in Sage 100 2013 Standard: sFirst = "" : sLast = "" : sKey= "" : sCKey = "" retVal = oBusObj.GetValue("UserCreatedKey", sCKey) Set oUser = oBusObj.AsObject(oBusObj.GetChildHandle("UserCreatedKey")) retVal = oUser.getvalue…

  • Qty Ordered in SO Entry Script rounding to 2 digits

    I have a script that is triggered by a button on the Lines tab of Sales Order entry. I would like to type in the Extension Amount ("Labor $ Sold) and then trigger a script that uses a preset labor rate (in the script) to calculate the qty of labor hours…

  • I need to have script execute on the selection of a line in a grid (SO Lines specifically).

    Need to have a script run as soon as a user selects a field on a line in a grid. I'm not sure which event can control this or how. Any ideas? [I posted a similar question in the Customization section. I wasn't sure how to make it show up in this…

  • Script Access to Current PO# in PO Header table

    I have searched Sage City and cannot see to find this. I would like to fill the current PO # on the comment line as a default when creating a new PO. I have added script to default warehouse based on current user, but cannot seem to find how to access…

*Community Hub is the new name for Sage City