• 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…
  • color SO Header Customer# defined by AR_Customer Type

    Trying to color the SO header customer# field if the customer type fall = specific value. I appreciate if you can help. Ctype = "" retVal = oBusObj.GetValue("CustomerType$", Ctype) If Ctype = "SDIS" then Set myUIObj = oSession.AsObject(oScript…
  • Adding Columns to Transfers in Transaction Entry

    Is there a way to make hidden columns by Transaction Entry type show in transaction types they don't typically? And be editable? For example, the Unit Cost / Price definition in the Sage Help has this note: " The transaction type selected in the Transaction…
  • Customer Maint display bill to on sold to main screen

    Does anyone know if you can display the billto customer # in the main screen in customer maintenance on the sold to?
  • 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…
  • customized panel

    if an employee has a customized panel (which overrides the all user panel ) how can we return the customized panel back to the all user version? we had an employee accidently create a customized panel and it is not correct how can I get her back to…
  • 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…
  • All "lookup" windows Sage 2022

    We recently upgraded to Sage 2022.1 and one of my employees was frustrated because every time she resized columns in the Sales Order lookup window, they would revert back - even after creating a custom view. I tested it on a few other lookup windows…
  • SO entry screen

    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…
  • 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…
  • How do you manager your Sales Orders when you have a remote admin team?

    We just hired a remote team member to process orders that drop ship either entirely or partially or are fulfilled electronically. Our current work flow revolves around paper and that doesn't work any more. Have you built or found an Order Manager…
  • Custom Panels Disappeared, need help!

    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…
  • How to Differentiate Between Inquiry and Maintenance Panel in Script

    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?
  • Blocking items

    Is there a way to block items from being invoiced to countries that do not accept those items? We are a large manufacturing company with several distributors, some times its not so easy to catch items on their purchase orders, that they're not allowed…
  • UDS on IM_ItemWarehouse Table_Post-Write doesn't get triggered?

    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…
  • 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…
  • Limit CI_Item.ShipWeight to only be numbers or a decimal?

    I would like to limit users to only be able to enter the numbers 0 to 9 or a decimal in the CI_Item.ShipWeight field. What would be the easiest way to do this? Thanks,
  • Custom Script to Run with AP Posts

    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?
  • Custom Office - User Defined Scripts Help

    I need help. I created 2 numeric UDF's for CI_Item; PACK and EACH_COST. I wanted to automatically calculate EACH_COST by taking the Item's Standard Cost and dividing it by the PACK. I searched SageCity and found a simple script and modified it. I…
  • shipping data entry - summary package tracking customization

    I would like to customize the Summary Package Tracking panel but the right-click customization option is not available. I am trying to ensure the user enters tracking information into this panel before Accepting the shipment. Any suggestions are appreciated…
  • User Setting Window not Displaying

    We have upgraded to 2016 and was trying to show the end user how to change the desktop theme, and the user settings window would not display from file or from the launcher. I understand that theme maintenance is not available to Sage 100 users that do…
  • IM_ITEM.M4L - OVENDORS - Access to Item Alias

    Have created two UDFs Manufacturer and Manufacturer Item Code that are on the Item Alias. They are there because they are accessible via the Alias Item Lookup. We have added these fields to the Alias Maintenance screen. User pointed out that the use…