• Creating AR Aging in Sage Intelligence Sage 100 Advanced

    We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…
  • 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…
  • 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…
  • 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?
  • Questions on InvokeLookup

    Hello, I have create a UDF called Item code in Cash Receipt detail table and add it on the Grid. I want to create a Button script using the invokelookup which will fire off the item code list and can select the item code from the list, then set the…
  • 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…
  • AR Invoice History Inquiry

    When I have AR Invoice History Inquiry open is there a button to click to find out payment information, date inv paid, check number, amount, etc? Besides going to AR Customer Maint or Inquiry, finding the invoice and clicking on it that way.
  • Can a custom panel be created for the customer memo inquiry & maintenance screens?

    I am trying to add a custom panel onto the customer memo inquiry and maintenance screens so I can see both the create date and the auto display field (to quickly distinguish old notes from current notes). Currently in maintenance I only see the memo code…