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.
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…
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…
To reproduce, in either 32-Bit or 64-Bit Sage 100, create an "Execute Script on Server" button in either Customer Maintenance or Item Maintenance (maybe any panel) that runs a simple two line script:
retVal = oScript.InvokeButton("BT_LINK_2")
retVal…
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…
Hi guys,
To interactively approve or cancel an entered value by a user, is there a way to make it work just in PreValidation event? I'm working in SO_SalesOrderHeader
The basic logic flow is as follows
User enters a value in a ShipVia
Script…
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…
I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker.
Essentially, instead of the user typing the invoice # they would type the sales order…
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 created a button that runs a simple VBScript that checks if a customer is set up on paperless or not. The problem is that while I am modestly proficient at VBS, I don't know anything about the Sage Object model.
I first attempted to have the script…
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…
We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way 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 all,
Does anyone have any suggestions on how to incorporate user-defined functions and additional sub routines in UDS?
I have a working (pseudo-codes below), intended to be assigned to Table_Post-Write event for AR_Customer_bus.
Basically, there…
Experts, I have a complex script that fires on the Panel PostLoad event of PLINES in SO Entry. The script colors lines based on some conditions and works great. It is based on a script that I got from a ScriptingClass a few years ago. The issue with my…
I have general question about writing button scripts in AR_Customer where I can write data to the fields.
My goal is to update and address Customer Maintenance Main 1: menu with a button that fetches data.
What I have working is the pulling data from…
We just hired a remote team member to process orders that drop ship either entirely or partially or are fulfilled electronically. Our current work flow revolves around paper and that doesn't work any more.
Have you built or found an Order Manager…
Hello,
We have added many panel customizations including additional tabs, buttons with scripts, etc that are important for many of our users.
I was just resizing a field in customizer, and when I went to exit the customizer an error popped up saying…
I'm writing a script to expose or hide selected controls based on user. I would like the script to be operational ONLY in Maintenance mode, not Inquiry. In the script, how do I identify whether the panel is in Maintenance or Inquiry mode?
