Sage 100

Hi, I have a script for the "UnitPrice" field in Sales Order Detail that triggers an alert if the price seems incorrect. I also have another script for "QTYOrdered" that occasionally modifies the "UnitPrice" field. The issue is that this second script…

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…

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…

Hello everyone, I was wondering if anyone has been able to split a sales order into two separate orders based on line information using a script. Would something like that be feasible?

I have a button script that successfully changes the price level on SO Lines but the changes aren't visible in the grid until either moving to another tab and then back to Lines or closing and reopening the sales order. Is there a way to refresh the…

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…

From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card. First I actually…

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…

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…

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 Experts, I have a UI script that is attached to the Post Load event of the Sales Order Lines tab. It works fine if click on the tab. But when I am already on the Lines tab and move to the next Sales Order by clicking the NEXT button, then the tab…

I have a script to delete CSP pricing on the IM_PriceCode table. I was wondering would there be a way to run this script outside of SAGE say from Task Scheduler?

Hello I was just wondering If I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming this…

Hello everyone, apologies if this has been asked before but I wasn't able to find something quite like this. We're on SAGE 100c 2018 v6.00.6.0 I have a script I want to run on a table to update the batch comments based on a few conditions. I have…

Hello everyone, I'm trying to populate 3 UDFs based off a button click to approve a Receipt of Goods. Here is the UI script I have linked to the button 'Triggered to write the date/time/name to receiver UDFs approved=PO_ReceiptOfGoodsHeader_bus_UDF_RECEIVER_APPROVED…

Hey all, I'm having a fun time trying to do a seemingly easy task. We have a customer that would like to set all their PO batches to be private when they are entered, even when they are not selected to be when they are created. I figured I could set…

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…

Hello, One of our customers inventory is showing up incorrectly and we need to temporarily put their orders on hold until we can go through them individually to ensure they are correct. However, I have been unable to get these new orders to be put on…

Is it possible to create a button with a script that is a sequence of keystrokes? Sage 100c 2016 sp5 from item Maintenance or Item Inquiry I would like to create a button that would take the user through a series of keystrokes. ALT 5 ALT W ALT Y…

Hi everyone, could someone please tell me if a different object is processing IM_ItemWarehouse? I was testing out copying QuanaityOnHand of a certain warehouse to a UDF in CI_ITEM but it appears the script attached to Table_post-Write wasn't even firing…

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…

Is it possible to write data into different company within some Sage 100 company. For Example add a button on Sales Order Entry to copy order to secondary company. I know how to do it outside of Sage with a script but not sure if session to different…

Hi all, I have recently created a script for the field "invoiceDate" that restricts how far into the future a user can enter the date for. I am wanting to apply these restrictions as well for the posting date. This should be relatively easy, except…

Currently I can set the default ShipDate on SO_InvoiceHeader using Custom Office however the moment I link a Sales Order to it the ShipDate changes to whatever the ShipExpireDate is for that Sales Order. How can I prevent that and keep the default of…