Sage 100

Hello, I was hoping to get some advice on scripting the BOI via a Button script that was placed on S/O Invoice Data Entry that would act as a "Quick Tax Credit" button. We use a third party cloud vendor to calculate our taxes but that shouldn't affect…

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…

I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed. I am now receiving an error 88 type mismatch (error window below). Any thoughts? START OF CODE Dim retVal Dim cpwgt Dim cpwgtstr Dim…

When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…

Experts, I have a button script that generates an item code. The generated item code does not yet exist in CI_Item. The desired behavior is that I can populate the new ItemCode on a new line in SO Entry and from there default Sage logic takes over …

Running Sage 100 Advanced 2018: I have created a UDT to hold key information needed for our accounts by zip code, and a Button Script to look up the data by zip code, populate certain fields, then show a message to the user. I can run the script just…

Having added a UDF to the AR Invoice history Called Enhatch order Id. When trying to print a copy of an invoice from this record the UDF does not print and it has been added to the form. Any ideas as to what link I am missing? To see the invoice printout…

Experts, I am using the button script below to open Customer History by Period from a Sales Order line (Sage has this button in Item Maintenance on the History tab). It works. It opens properly for the item. But there is a secondary selection criterion…

I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI. I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…

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…

I have a script in Sales Order Entry triggered from a new 'Accept' button that searches for other open orders for the same customer with at least one line item that is not out-of-stock (new UDF I have three references to "SO_SalesOrder_bus" I use oBusObj…

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

This script runs from a button on Sales Order DMAIN. The purpose is to update UDF values in SO Detail based on changes made in CI Item. I have tested the script with message boxes (not shown here) to verify that expected keys, line and Item Master values…

Hello I am trying to find any doc on "oScript.Execute", i am facing an issue i want to call a 3rd party app and want the script to wait till the exe completes its execution. Thanks

Hello Every one I am running a script to get line level values in sales order, I am getting a "OLE error 424" error, can any one please help Code: ****************************************************************** Dim taxReqXML Dim intx dim…

Hello Everyone, I am trying to run a 3rd party exe on a button click using VB Script , The code is trowing (OLE ERROR -2147024894) i have added the code and also the error message i got ********************************************************…

Hello Everyone I am trying to update UDF in sales order line using script, i am not getting any error but it's not working i am adding the the code that i am using any kind of help will be really great Thanks ____________________________________________________________________________________________________________…

hello, i am trying to read data("SO Line" line level data for a sales order) from the grid to a vbscript but i am only able to access data of selected line ..... can any one help me out in how i can read the data from the gird( read all lines…

Hi all I have a button script on SO Order entry form. UDFs are on Totals tab. UDF_QTY and UDF_AMT. When a button is pressed, the script gathers quantities and amounts from detail lines where unit price meets certain criteria, The totals gathered should…

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