Sage 100

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

Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…

Greetings all, I was wondering if there is a way of updating a UDT whenever a Sales Order is printing via script. I have a customer that would like to keep track of the time between when the SO is printed and when the order is shipped. I figured I…

I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed. I am now receiving an error 88 type mismatch (error window below). Any thoughts? START OF CODE Dim retVal Dim cpwgt Dim cpwgtstr Dim…

I have a request to add an "options" button that will open a custom dialog box with various button scripts performing different functions. One in particular is hiding some elements on-screen for what I suppose is to sanitize some information for screen…

Trying to color the SO header customer# field if the customer type fall = specific value. I appreciate if you can help. Ctype = "" retVal = oBusObj.GetValue("CustomerType$", Ctype) If Ctype = "SDIS" then Set myUIObj = oSession.AsObject(oScript…

Is there a way to make hidden columns by Transaction Entry type show in transaction types they don't typically? And be editable? For example, the Unit Cost / Price definition in the Sage Help has this note: " The transaction type selected in the Transaction…

Does anyone know if you can display the billto customer # in the main screen in customer maintenance on the sold to?

We need to track all additions/changes/deletions in the AP_VendorElectronicPayment table. Has anyone used scripts to track the changes successfully? We are using Sage 100 Premium. I have not used scripting in Sage, but I believe this could be a solution…

Can the custom office module handle a request, where if a user choose an item from a list then the choices from the next list change based on the first selection? If I choose "A" then my choices are 1,2,3 if I choose "B" then my choices are 1,4,3? Sage…

I have a button script located on a Cash Receipts Entry screen. Sage disables it by default until a customer number has been entered. The purpose of the button is to assist the user with locating the customer number, so this doesn't work for our use-case…

if an employee has a customized panel (which overrides the all user panel ) how can we return the customized panel back to the all user version? we had an employee accidently create a customized panel and it is not correct how can I get her back to…

I'm new to these products and a bit intimidated by the extensive documentation. Before I waste a lot of time trying to make a change to a production system work correctly, I'd appreciate a simple answer: Is what I want to do possible with these products…

When I use Sage 100 Customizer to add customized panel, I noticed each panel has a W version, eg, In the task of Sales Order Entry, there's a DMAIN and a DMIANW. What's the difference between the two? Can I set the default display to be DMAIN instead…

We recently upgraded to Sage 2022.1 and one of my employees was frustrated because every time she resized columns in the Sales Order lookup window, they would revert back - even after creating a custom view. I tested it on a few other lookup windows…

I have a UDF checkbox on the GL_Account maintenance called UDF_DONATION. What I want to do in the Table Pre-Write is to check to see if there is another GL Account record where this UDF_DONATION is already set to "Y". If there is another record with the…

We just did the SAGE 2021 update and something all of our people are finding an issue with is In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…

Just discovering the power of Custom Office (I'm a newb). I am running into a wall with one particular item. I have worked my way through creating user defined fields and tables and can successfully customize panels in screens and modules, but I'm stuck…

I am trying to launch either BOM Inquiry or Maintenance using an InvokeProgram or Process User Defined Script, but any time I add the Bill I get the error "You do not have security rights to create the record" but I am not trying to create a record. Any…

Experts, I got a tricky one here. I have a UDF in IM_ItemTransactionHistory that contains a file path. Now I would like to be able to place a button in Item Maintenance on the Transactions tab that allows me to open the file. The code to open the…

I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

I have used this code for years me and a handful of others, but we have a few new users that are having issues and can't appear to use my app to open Sage Sales Order. The only indicator they get is SO_SalesOrder_UI in a message box. Here is the…

I have most of this script working but am hung up on the part reading from the line detail object. I have created a button on the AR Invoice History Inquiry panel so that the end user can find the invoice they want to copy, press the button, and the flat…

Hi Sage City and Happy Friday! I have been working on a button script to launch Sales Order Entry from AR Customer Maintenance. The goal is to click on the button and open SO Entry, automatically select the next Order Number and pass the Customer Number…

Good morning all, So I figured this would have been a relatively easy script but I can't seem to find a way of accomplishing what I need. I have a customer that would like to force a cancellation reason whenever you delete a Sales Order into history…