• AP Invoice Data Entry Import 2 Invoice Columns in Source File

    Hi, I'm currently working in an AP Invoice Data Entry import. Currently running v7.00.2.10. In my source file column 3 is the invoice number. In Column 8 if there is data in the cell then we need to use this number as the invoice number. If the field…
  • Custom note pop-up on the SO Entry: Line Item entry window.

    Hi Sage Community, Our company has an old note pop-up that only occurs when an old Product Line that has recently been activated again is added to the Line Items of a Sales Order: I thought it might be a memo, but can't find an associated memo and…
  • Tax ID number in lookup is masked even though user can see entire account on screen

    In Sage 100 v2023, client has rights to see PII info and can see Tax ID number in Vendor Maintenance. However, it shows as masked in an ALE Lookup AND they can no longer search by that field. Their procedure when adding a new vendor is to search first…
  • Barcode Usage with BOM in Shipping

    We use Sage 100 Advanced 2023. We have an item, Honey Straws that we make up into 50 packs to sell. We buy these in boxes of 2000. There are about 2 dozen flavors we offer, but for the examples, I will use Apple as the flavor. All items have similar setup…
  • Missing Labels/Controls from Panels After Panel Modification

    We are having an issue where control labels are missing after panels have been modified. This is occurring for labels/controls that were not part of the modification. As a result, we have to keep continuous backups of our panels and roll these back in…
  • Sorting Sales Order line by Item Code

    Hi, I have a request from a client to sort the Sales Order Lines detail section by Item Code. I feel like I should be able to do this with a script, but not clear on what Object to reference. Can someone give me a hand, perhaps point me in the right…
  • Tiny Font in Sales Order Entry Lines

    I am working on an issue after a new a install of Sage 100. The font on the Sales Order Entry Module is tiny. ( See attached Pic ) . I have adjusted the resolution and scaling in Windows. But this has not made any difference. All other Sage modules and…
  • MAS_SCR_USR is user name, what is password in client script

    When use client side script, MAS_SCR_USR is the current user log on, what is the current user password constant, in my client script, it will also run an external BOI app, needs current username and password to pass to it. Thank you
  • SAGE 100 - Can I create a pop up alert in "Invoice Payment Selection" Process?

    SAGE 100 - Can I create a pop up alert in "Invoice Payment Selection" Process? I need to set a particular reminder about a vendor every time I do a check run.
  • 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…
  • Trying to create global custom lookup

    I'd like to create a global user lookup via the User Lookup Wizard for a very particular lookup - the Sales Order Entry Item Code lookup, but the Miscellaneous item version of it (the one that launches when entering '/', then pressing F2. I THOUGHT…
  • 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…
  • Where to find demo scripts to shadow UDT

    I'm looking to create a UDF lookup to the AR_Customer on the Lines tab of GL General Journal Entry. I haven't been able to use oUIObj.InvokeLookup with a button because it throws an error stating Object required: oUIObj. Because it's on the detail and…
  • Where to find demo scripts to shadow UDT

    I'm looking to create a UDF lookup to the AR_Customer on the Lines tab of GL General Journal Entry. I haven't been able to use oUIObj.InvokeLookup with a button because it throws an error stating Object required: oUIObj. Because it's on the detail and…
  • 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…
  • Script to Hide a DataGrid Column

    Is there a way via scrip to hide a column in a DataGrid? I've seen similar questions posed but no answer directly to this. Example: User enters a Sales Order line item. Based on the Product Line of the Item, have certain columns show and hide others.…
  • Fields and Labels duplicated each time update custom office panels is run

    We have had several situations recently where recently where we are seeing that customized panels have the elements on the screen duplicated many times layered on top of each other. The number of duplications *MAY* correspond with the number of time that…
  • Item Maintenance - Categories

    Is there a way to make the Categories in Item Maintenance a drop down instead of text entry? Thanks!
  • Copying Customized Panel

    Can you copy a customized panel from one user to multiple users (not all users in a company).. I have several users in company that have their own customized panels but I need to create a panel that all users need. So I dont want to include the already…
  • 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…
  • 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?
  • Prevent Shipping Data Entry Shipment

    I'm trying hard to make this happen, but falling short. I need to prevent a sales order from being shipped if a certain condition is met. Ideally this would occur as soon as the sales order number is specified in shipping data entry (SalesOrderNo PostValidate…
  • Sales Order Printing - How to set boxes to be checked by Default

    Good afternoon, I am on Sage 100cloud Premium 2020 V 6.20.4.0. When printing a Sales Order at the Sales Order Printing Screen, I am trying to have the Print Lot/Serial Distributions box checked automatically by default. I have Lot/Serial turned on…
  • 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?