• 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…
  • 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…
  • Script to transfer data to secondary company

    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…
  • Log who printed Picking Sheet

    I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below: retVal…
  • Update SO field from PO button script

    I'm trying to write a button script that will copy a single line from a SO and "pull" it into the open PO. I've done this successfully for SO (copying from Invoice or SO/Quote History), but with PO, I'd like to be able to "tie" the SO and PO together…
  • Script "if" placement

    I have a script that works unless the field "UDF_EXCH_RATE" is zero. (default value is .000000) Where do I place the "if" statement to get it to work? tmpAmt = 0 : tmpExchange = 0 retVal = oBusObj.GetValue("ExtensionAmt",tmpAmt) retVal = oBusObj…