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.
Receive an error message - unable to draw folder control on any customized panel where an extra tab has been added. It works in 2022.0 but errors out after installing PU 1. Deleting and recreating the tab in version 2022.1 works. I'm working with Sage…
User selected all fields and made the lookup default. Lookup no longer works. Gets a message "No table entry for file CI_UDT"
Does anyone know how to make this "NOT the default" and then we will have access and can delete:
Or is there another…
We have different types of picking sheets that we use and print multiple types per sales order. Everyone always forgets to change the form code so we waste a ton of paper. Is there a way to add another button to the Sales Order Entry page to open up a…
I'd like to modify the order in which lines are displayed in the secondary grid in the Sales Order Module (Sales Order Entry).
We have several UDF's in that grid, but I am having trouble seeing the list of fields within that secondary grid. Using customizer…
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…
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…
This UDS is a Column Pre-Validate on QuantityShipped against the SO Sales Order Tier Distribution table at version 2016 Std through 2020 Advanced. The SetError doesn't always trigger the error message, but it does fail (i.e. clear) the distribution number…
I discovered that if a date field (e.g. PromiseDate or ExpirationDate) is changed on a new SO or PO line with a Pre-Write event that also sets any other value in that line, the screen format of the changed date for that line also automatically changes…
Hi All,
I need to display a message box on Shipping Data Entry interface. I can get data from "SO Sales Order Header" and "SO Shipping Data Entry" and "Customer....".
On Custom Office using trigger of " "SO Shipping Data Entry" " and Pre-Write.
…
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?
Hello,
We are trying to set up our customer maintenance screen to look identical to customer inquiry, except for one tab so that a certain department can access just that one tab. To do this, I am creating a custom panel which locks all fields except…
Hello,
I'm curious if it is possible to have a visual process flow button simply open a file instead of download it? I have a button set up linked to an excel document and another linked to a crystal report, but clicking these buttons causes an internet…
Hello,
I have been struggling to get this to work for quite some time and am starting to go crazy! I have created a button on the Invoice History Inquiry which opens up the Sales Order UI, but I want to pass through a parameter so that the Sales Order…
I need an executable to run when the client Posts AP Batch to the Invoice Register. I cant add a user defined script to the AP Invoice Registry screen because i cant get to it with Customizer. Is there a way to get around this?
Hello,
I am trying to write a script for lookup button in order to pull the salesperson data. I only want to pull the salesperson data whose division number is “00”. How can I pass ARDivisionNo as parameter? Here is the script which I am working on…
We have some standard price level codes we use that are set up for each item, if you are a wholesaler you get X price, MSRP has its own price code, etc. The descriptions for these codes are universal, W always would be described as wholesaler for example…
My client is using version 2013 of SAGE. Is their any way to create a lookup on the UDF field to pull from a standard ALE lookup in SAGE/MAS and return the value. Does anyone have an example of the custom office script.