• Customize Employee Maintenance Screen with "Tabs"

    Hello, I am hoping to find a way to add a tab (or a few) to the "Employee Maintenance" screen in Sage to allow for more fields to be added under different department specific details. Running Sage 100 Premium 2021 (Sage Version 7.00.2.0) (Payroll…
  • How to Flow a UDF from Sales Order Header to SO History Header Reliably

    With identical UDF names in both tables, the original value set into the SO Header UDF via a ColumnPostValidate script from a standard field works to flow the value to SO History Header, but subsequent successful updates directly to that SO Header UDF…
  • User Defined Script for Sales Order

    I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.
  • Sage BOI SO_PackageTrackingByItem_bus

    I am attempting to write a Sage BOI VBS program to read and write to the SO Shipping Data Entry Package Tracking By Item object and am receiving the error <NewObject Error: 200>. I am using a Sage user that has full access to Sage and have the company…
  • Barcode Usage with BOM in Shipping

    We use Sage 100 Advanced 2023. We have an item, Honey Straws that we make up into 50 packs to sell. We buy these in boxes of 2000. There are about 2 dozen flavors we offer, but for the examples, I will use Apple as the flavor. All items have similar setup…
  • Sales Order lines Promis date - getting line key is read only message.

    Hi Forum, I've been trying to update Standard Sales Order line promise date from Master Order Lines with no luck. I am getting The Promised date from the last line in the Master Order updated only, all lines on Standard order with same date. Here…
  • DocumentTotal Bug?

    I should start off by saying we are still on v2020 for compatibility reasons. It appears that the `oBusObj.DocumentTotal` property (Sales Order Bus) doesn't calculate on quotes (it's value is 0). Is this intended behavior? The moment I change the order…
  • Can I write a script to show what is the error on the BI button MS Script I created

    Dear all, Is there a way to have a short script alone with the BI script to show error message on why my script doesn't work. In other word, how to trigger error message on a BI script, something related to this code - oBusObj.LastErrorMsg. Correct…
  • Update UDT from CI_Item

    After reading a few post about updating UDT's from scripts I am wondering if my events are wrong or do I need to SetKey before SetValue? In the debug I couldn't get any return values, so I am guessing my events are wrong, I've tried a PRE-WRITE and a…
  • File Attachment in PO

    We currently use Instadocs to attach specific files to SO's and PO'S, etc.. Is it possible to attach a pdf to a specific PO and then print the PO to pdf with that specific attached file in the same pdf file? I would not think it's possible but....
  • Error 88: Invalid/Unknown property' on reference to a business object from within the same object

    'Error 88: Invalid/Unknown property' on reference to a business object from within the same object I am trying to browse the records in the 'SO_SalesOrderDetail' from within a Column Pre-Validate script on ItemCode in the same table'. This works from…
  • Type mismatch when using zeroingll in Sage Intelligence

    Getting an error when trying to add in the zeroingll to a spreadsheet tab. There are no non-numeric fields in the column used for checking. What else to look for?
  • nFind returns 0 for AP Invoice lookup in AP_OpenInvoice

    I hope this is something easy that I'm overlooking. I'm looking up an invoice in the AP_OpenInvoice table that I know exists. I have confirmed that I'm passing the correct vendor division, number, and invoice number. But I'm getting a 0 return value.…
  • Accounts Payable Check and update

    I'm hoping someone can help me out with an issue we have been having with Sage 100. We have multiple companies but we are only have this issue with one of our companies. When we go to make an Accounts Payable check under Manual check and Payment entry…
  • Sage 100 2023 SQL queries not running in custom web app

    Hello folks, We are starting the process of upgrading from an older version of MAS 90 which ran on Providex to 2023 Premium. There are a number of custom apps that we've developed over the years to run with our MAS data and they all used the MAS ODBC…
  • get control property list box focus not available

    Hi, The list box control property is not available, why is that?. My line of code: getCtl = oUIObj.GetControlProperty( "MyListBox", "Focus", ctlPropMyListBox ) If ctlPropMyListBox <> 0 Then Call SomeFunction End if Thank you, -SKG
  • Designer Report

    I am new to designing reports in Sage 100. Is there a good YouTube video or documents on this? I just need something simple for an audit (employee name, job title, gross wages, and overtime wages).
  • Open Sales Order Report - Filter fields

    The Sage 100 Open Sales Order Report has a list of stock criteria fields, and some fields we added using custom office..see attached. Are we able to add additional standard Sage fields to this list eg; CustomerPO?
  • Default Bill Value to Single Level Report

    Hi... I'm trying to find a way to add a value from the bill of materials bill number field in bill of materials maintenance to autopopulate the bill number when you run the Single Level Report from the screen. As it works now, the report will appear…
  • Read validation configuration of UDF

    Hi, When creating UDF we can specify that its validated against: - none - range - list - user-defined table Im trying to find a way to get the name of the UDT. In order to get range/list values in c# its enough to do something like that…
  • get control property list box focus

    Hi, No return value for list box focus event property. How is this property trigger, by clicking on the list box control? Any information would be helpful. Regards -SKG
  • 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…
  • Display Inactive Item check box doesn't appear to do a darned thing

    I (on 2023 Std) and at least 2 clients on 2 different versions have tried to uncheck the Display Inactive Items check box and have it actually stop Inactive items from displaying in a lookup, but to no avail. The Inactive continue to show up. What, exactly…
  • Editing RMA Originator list

    We have had a number of staffing changes and need to update our RMA Originator listing, however I cannot figure out how to do so.
  • Script for Auto-Updating UDF on Kit Lines

    We have a UDF "Total Quantities" that we use for Kit items to show the total quantities of all the components. Currently, we manually sum the quantities of the component lines and enter this into the UDF "Total Quantity" on the Kit line. I need help…