Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
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…
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 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…
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?
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.…
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…
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…
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
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).
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?
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…
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…
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
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…
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…
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…
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…
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…
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…
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…
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?