• 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…
  • 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…
  • 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…
  • 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?
  • 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…
  • Looking for field location in SQL: Accounts Receivable Posting Date

    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…
  • Default ShipDate instead of using ShipExpireDate when an invoice is created from a sales order.

    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…
  • Script in AR_CashReceiptDetail - Set InvoiceNumber

    Hi Experts, I wrote a script that will allow a user to enter a secondary ID number (not the Sage InvoiceNumber) in the InvoiceNo field in CashReceipts Entry detail. The user enters the secondary ID, my script grabs the number, looks up the correct Sage…