Sage 100

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…

Hi All, I am very new to VB Scripting and BOI in Sage scripting, Is there any training material or certification which is recommended for the newbies, please advise and recommend. Thanks AJ

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…

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…

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…

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…

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…

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…

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…

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…

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…

Hello: I have an issue where the client needs the ship weight and the freight to carry over to the Totals tab in Sales order data entry. It will not due to the line item setting in sales order options. I believe my options are to write a script to…

Hello all, I have a button script on repetitive invoice header which will pulls out a UDT. But what I want to do is not just pulls out the UDT, (cause it will show all the datas) but also filter the UDT values that shows only for this particular customer…

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…

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…

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…

Hi All, I was going through some old Sage Summit presentations and thought that these 2 sessions had a lot of great information that is still very useful. Enjoy! UsingBusinessObjectInterface_Begginer.pptx UsingBusinessObjectInterface_Advanced.pptx…

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…

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…

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…

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…

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…

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…

I'm trying to update a user defined field in the Sales Order Header table using a script from Sales Order Invoice entry from the Table - PreWrite event. The script saves the USERCODE from the session object into a UDF in the Invoice and then tries writing…