• User Defined Script for Sales Order

    I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.
  • Invalid expression when in advanced logic filter

    I'm trying to create an advanced logic filter that will only capture a few specific customers. With the operand's available I've tried just about every way I can think of including all 20 of the companies. Does anyone have any examples for formatting…
  • How to Only Fire a Script on Manual Change of the Field

    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…
  • Get Handle for UI Object from a custom panel

    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…
  • How to Create a Script to Make UDF Required Property to True/False

    Upon Checking a Checkbox in Sales Order Line Item It will Make a line item filed required
  • How to script an AP division number restriction in Invoice Data Entry?

    I need to restrict certain divisions from use in AP Invoice Data Entry for certain roles. The division restriction is the challenge. One cannot use a Pre or Post Validate script on the VendorNo field as would be done in S/O with CustomerNo. Since VendorNo…
  • Column PreValidation & reverting user entry

    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…
  • Split Sales order with a 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?
  • Sales Order GD_Lines Refresh

    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…
  • Permanently Enable Button on UI

    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…
  • Button Script to Add Comment Line to GD_Lines Table in SO Invoice Data Entry

    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…
  • 'Table' Does not have correct permissions, when running script

    Hi, I made a script in Sales Order Entry that loops thru the lines and changes a few fields based on the previous lines (trying to group lines together for a report). I'm getting an error now and after a lot of troubleshooting I realized that I only…
  • SO Invoice Data Entry: Button Script to get Invoice No from an SO No

    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…
  • Script to Synchronize Customer Billing Address in Sales Order Data Entry

    I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…
  • Bill of Materials InvokeProgram Script

    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…
  • Can't figure out Event hook

    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…
  • 2016 - 2020 First oScript.SetError Method doesn't trigger an error message in Lot/Serial Number Distribution

    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…
  • Changing a date field on a new line with an unrelated Pre-Write script also changes that date's format - confuses customer

    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…
  • Invoice Batching – Can't Set the Cost Account Key

    When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…
  • UI Script Post Load Event on Sales Order Lines Tab

    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…
  • Run a Script outside of SAGE

    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?
  • Changing Naming convention on save Paperless Office form PDFs

    Is it possible to modify the naming convention used by paperless office when storing forms? I have a customer who wants to add a UDF to track Revision Number on Sales Orders and Purchase Orders, and would like the Revision Number to be part of the PDF…
  • Can I use table IM_ItemWarehouse to trigger script?

    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…
  • Silent and Unassisted Removal and Deployment Sage 100v 2019

    Does Sage support silent removal and deployment for client installs? We are using Sage 100 v2016 and moving to a new server with Sage 100c v2019. Is there a way to deploy a script to uninstall the client on all the machines and reinstall a new client…
  • Update GL_ActiveBatchComment Script Help

    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…