• 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…
  • Aged Invoice Report

    When I uncheck "Age Credit Memos" on the AR Aged Invoice Report, credit memos are still showing up on the aging report. Any help is appreciated.
  • Missing Labels/Controls from Panels After Panel Modification

    We are having an issue where control labels are missing after panels have been modified. This is occurring for labels/controls that were not part of the modification. As a result, we have to keep continuous backups of our panels and roll these back in…
  • How to have a script on the Sales order Header trigger another script on each detail line?

    I added a new script for all new orders on the sales order detail to fire on the column post validate of "Item Code" My concern is for any old quote that will be changed to an order and will not have the script run, how can i add a script on the Header…
  • Payment Terms Set-up Pays 10th of month for Previous month

    I have a customer that would like to pay the 10th of each month for the previous month, in addition to a 2% discount off invoice at time of payment. Is there a way to do this in Sage without making custom field calculations? I am using Sage 100 2022…
  • 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…
  • Custom Columns

    In payroll records it gives you the option to select columns to show but can you you not save them that way? Will it not let you customize the columns the way you want them?