x Want to participate? Join the group to interact

  • Exit Table Updates Properly?

    I have encountered a strange issue with a button script that enters data into a UDT. I have been using this script in testing for about a month now and it hasn't had any issues until yesterday - even after a server restart. The first time clicking this…

  • Prevent Change to Different Division

    We use divisions and sometimes the users will copy a previous sales order and change the customer. The problem comes in that items on the sale order are coded to one division and if the new customer is in the different division it creates a problem with…

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

  • User Defined Script causing an error

    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…

  • Error 88 on Sales Order Entry Lines

    We are experiencing an error 88 on Sales Order Lines. The error occurs only on large orders with numerous lines, especially when adding inventory items to the order on the fly. The line prewrite script is failing and referencing different UDT objects…

  • Copy UDF Values from AR_CUSTOMER.M4T to Equivalent UDFs on new Sales Orders

    New to this forum, and new to using the Business Object Interface. Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…

  • DFDM Modifications to Allow UDT Field Lookups

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

  • Can't find the created UDT as a Data Source while adding a field to the AR Customer table

    Hello, I created an SY UDT, and then I tried to add the field from this UDT into the AR_Customer table. I don't see the UDF from that SY UDT as a Data Source under the AR_Customer_Bus. Is there one more step to link them before I'm able to select the…

  • Create Item on SO from Button Script

    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 …

  • UDF on AR Invoice Histrory will not print on invoice Document.

    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…

  • JobOps WT Template Modification Through BOI

    Hey everyone! I'm attempting to modify and create/remove work ticket templates via BOI (through C# and Entity Framework) and I'm not having much luck. I'm not sure what object the template table is a part of and I haven't been able to find anything…

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

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

  • Open Item Customer Sales History By Period UI from Button Script - pass Customer

    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…

  • Show/Hide buttons not working

    Hi Forum, i have buttons in AP Invoice custom panel that i have hidden and depending on the company code they will Show but buttons stay hidden. The UI Script Event is "POST LOAD" Here is the code I am using which i copied from the forum. …

  • I can't seem to set an event for an item change

    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…

  • AR Invoice Header PreWrite script not working correctly during Repetitive Invoice Selection

    Sage 100 Advanced 2018. I have a script designed to fire on AR Invoice Header PreWrite: If a BillTo account is specified in Invoice Header it should confirm the checkbox UDF_BTST is checked in AR_Customer, and if not should displays a message reminding…

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

  • Training Material and Certification recommendation for BOI and VB Scripting

    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

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

  • Set freight amount

    Hi all, First script first post. Task is simple for one customer set freight amount field to negotiated amount that is based on the sales order total amount. Script is attached to pre-total event and it always works BUT only if sales order has more…

  • oScript.Execute

    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

  • Unable to Initialize oBusObj ( OLE error 424)

    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…

  • Error when running WScript.Shell object (OLE ERROR -2147024894)

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

  • UDF using script

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

*Community Hub is the new name for Sage City