Sage 100

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…

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…

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

Hello, I am scripting a button that, when clicked, opens up the sales order history lookup from the Invoice History Inquiry panel. I am trying to get this lookup to already have the sales order number entered that is shown on the current panel. For…

Is there a way to add an additional header tab to a screen via custom office... say in SO Entry or PO Entry? Then populate it with whatever we want?

Hello, I am trying to create a button/link inside of AR Invoice History that pulls up the Sales Order and Quote History window. Basically, something that acts identical to the "Invoices" button at the top right of the screen on Sales order Quote history…

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?

Hi All, I have a client that wants to prevent users from deleting a COMPLETED line on a PO. It appears that we can't do this via scripting but wanted to confirm before I send it to programming. And just a note - there are all kinds of problems with…

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…

Hello all, I have a button script on repetitive invoice header which will pulls out a UDT. But what I want to do is not just pulls out the UDT, (cause it will show all the datas) but also filter the UDT values that shows only for this particular customer…

We're using MAS 200 4.4 (still). In any of the newer versions, does MAS display a running total of the items ordered in the SO Item Entry Panel? If there isn't one, any tips on how to create this using Custom Office? We get frequent orders where a customer…