• Sage 2022 Customer Maintenance Custom Tab List-Box

    Hi, I experiencing errors in customer maintenance on a custom tab. I'm using the debug window and found 1k+ lines on several clicks. Error:0 Error:11 Error:12 Error:13 Error:14 Error:2 Error:20 Error:23 Error:26 Error:27 Error:36 Error:65 Error…
  • 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…
  • Grabbing the Currently Selected Invoice from Listbox

    In Customer Maintenance's Invoice tab I am wanting to allow accounting to have the ability to edit the Comment field from the AR_OpenInvoice table. Since this isn't the history table, it wouldn't affect the comment line for invoice history reprints, so…
  • Has anyone been able to trigger a script on the Ar_CustomerMemo or other Memo tables?

    I'm trying to trigger a script that will set the "Auto Display" value to "Always" as a default on the AR_CustomerMemo. I've tested triggering a script with a simple message box on various events like, on Table Set Default Values, Table Pre-Write, and…
  • 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…
  • How to access PR_TaxProfileLocation

    Hi Experts, We are working on a script that will bulk import TaxProfiles into Payroll. We are utilizing the PR_TaxProfile_bus. But we need to get to PR_TaxProfileLocation. The Sage Help states that this can be accessed as oTaxProfileLocation (similar…
  • Script not working on workstation

    I have a script that I wrote and installed on the server remotely. Worked fine. It was attached to the CustomerNo field in Sales Order Entry. When the user attempted to create a sales order, as soon as they selected a Customer it locked up Sage 100 and…
  • Creating Button Scripts

    I have general question about writing button scripts in AR_Customer where I can write data to the fields. My goal is to update and address Customer Maintenance Main 1: menu with a button that fetches data. What I have working is the pulling data from…
  • <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…
  • Custom Panels Disappeared, need help!

    Hello, We have added many panel customizations including additional tabs, buttons with scripts, etc that are important for many of our users. I was just resizing a field in customizer, and when I went to exit the customizer an error popped up saying…
  • Programs

    Here is my problem. I have a trigger set when an order number is entered when doing Sales Order Invoicing which works fine. I don't want it trigger when using Shipping Data entry. Any suggestions?
  • 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 ********************************************************…
  • Price Level Description on Price Level List Lookup

    We have some standard price level codes we use that are set up for each item, if you are a wholesaler you get X price, MSRP has its own price code, etc. The descriptions for these codes are universal, W always would be described as wholesaler for example…
  • Change field or panel color

    Can any screen colors be changed using BOI? For example on AR_Customer change header panel color if certain criteria is met Thanks.
  • UDS to open Contact Code List

    I have been using UDS and BOI for a while and understand how to launch UIs. I'm just having trouble finding how to open the screens for searching. Specifically the Contact Code List that can be opened from Customer Maintenance by clicking on the magnifying…
  • Printing From Shipping Data Entry

    Sage 100 ERP 5.00.8.0 We are adding a button to our Shipping Data Entry that calls for a print of an invoice based on a Sales Order Number. I am consistently getting the following two errors: 1) "The S/O0000000022SO_INVOICEPRINTING_UI STANDARD 00001…
  • I want to Auto populate either the SO Entry Header Email or a UDF with the email address of the user entering the order.

    I figured out how to get the name, using a session object, but I don't think there is an osession for email. Below is my attempt at using osession, and the second is my direct attempt. I am new to this, so any help would be appreciated. UserCreatedKey…
  • UDT Posting

    I have a UDT that is used to capture data during SO Invoice Data Entry. I want to copy data from this UDT into different UDT where data will be stored for historical purposes. Ideally I would like to have this automated during Sales Journal update but…