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