Sage 100

I'm using the line of code below, but I'm getting an error stating: "The Description is greater than 30 character(s)." No doubt this is because the step description is stored in the JT_WorkTicketText table (much like the CI_ExtendedDescription table)…

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…

Hello - I could use some assistance if anyone has done this before We have 3 web portals and each of these portals have a single user/pass and when you connect it only has 4 options: 1) Customer Orders - PO for last 90 days 2) Customer Orders…

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…

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

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

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.

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 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?

Hi, I have a request from a client to sort the Sales Order Lines detail section by Item Code. I feel like I should be able to do this with a script, but not clear on what Object to reference. Can someone give me a hand, perhaps point me in the right…

HI, I have a request from a client to sort the Sales Order Lines detail section by Item Code. I feel like I should be able to do this with a script, but not clear on what Object to reference. Can someone give me a hand, perhaps point me in the right…

I have two UDTs that are being used to manage credit releases. One contains the credit release data and the other is just used as a validation table that contains status codes and their descriptions. In SO Order Entry there is a UDF that uses the main…

Trying to figure out how to get a message box to pop up in SO entry when a user enters a line for warehouse '000' for example, however there is 0 available for that item in warehouse '000'. On that same item we have 2 available in warehouse '001', I would…

Have a situation where the frame/theme colors change for users everyday. They are connecting to Sage 100 using Workspace and it's not a dedicated VDI solution. The company and users do not have any theme settings setup. Could the changing colors be coming…

Is there a way to disable the information or other clickable links in Sage100? I have a client that does not have web browsers installed on their terminal server and users are clicking on the links and getting errors. They would like to prevent clicks…

Hi. How do I add column headings to a listbox and set the columns so that user can resize. I'm using, ListBoxLoad(listBoxName$, value$, delimiter$) mehtod, no problems loading the data from a UDT My SetControlProperty( lbx, "FMT", "L20 L20 L20"…

Hello, I was hoping to get some advice on scripting the BOI via a Button script that was placed on S/O Invoice Data Entry that would act as a "Quick Tax Credit" button. We use a third party cloud vendor to calculate our taxes but that shouldn't affect…

One of my users is getting this error message when trying to do SALES ORDER ENTRY. It says the Bill To Zip Code is greater than 10 characters. But it is not. Does anyone know how to fix? Its weird, cause when i log in to the account from my computer…

How do people manage per diem when employees are using the simple time card app? We're not seeing where it's an option.

In purchase order entry, lines tab, there is a sales order number field. Although that field has a lookup button, it does not appear to be validated. Users seem to be able to type in anything they want that's not a valid sales order number. Is this a…

It's me again. Looking into using VBA or potentially a vb.net windows form app to potentially create and update Cash Receipt Batches & Deposits. External scripting documentation seems to be pretty limited and I am not sure where to even start when it…

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…