• Resources File Layouts and program information

    Where is the link to resources in Sage 100 2022?
  • Linking one UDF to another

    I don't think this is possible in Sage 100c but I thought I'd ask. We want to store attributes on each item. For example, various attributes could be product type, material, color, etc. For each attribute we'd want to pick its value. Example: Attribute…
  • If this then that logic-custom office

    Can the custom office module handle a request, where if a user choose an item from a list then the choices from the next list change based on the first selection? If I choose "A" then my choices are 1,2,3 if I choose "B" then my choices are 1,4,3? Sage…
  • Pre/Post-Delete User Defined Script

    Hello, I am trying to capture a value when it has been deleted and store it to be used in another script. I have tried tying it to a Pre-Delete and Post-Delete event on the table storing the data, but neither are giving me anything. Can someone tell…
  • Top Menu missing in Business Explorer

    Client is missing this menu in Business Insights Explorer. I can't find a way to get it back....
  • Sales Order GD_Lines Refresh

    I have a button script that successfully changes the price level on SO Lines but the changes aren't visible in the grid until either moving to another tab and then back to Lines or closing and reopening the sales order. Is there a way to refresh the…
  • Adding a Bill Options enabled item programmatically, bill options lines are not being exploded/added

    Hello, We are trying to programmatically add a line item via a button click script event in Sales Order Entry where the item code being entered has Bill Options enabled. The canned Sage logic for Bill Option enabled items prompts the user to choose…
  • Script creates error CI_Item.LCK does not have permssions

    We sometimes ship orders by LTL carrier. We have had issues with people signing the Bill of Lading and then finding trucking damage later. They do not get any consideration because they signed as received in good order. Our shipping manager wants each…
  • Script to Update Module Date?

    I am trying to determine if it's possible to update the A/R module's accounting date via script. It appears that module dates are stored in the SY_ModuleDate table, but the table does not have an associated business object with it - to which I assume…
  • How do I hide one or more Tabs on a panel?

    I am trying to hide tabs 3, 4, and 5 for Customer Maintenance for a specific user. I know I could set the fields on the tabs to hidden, but the user wants the entire tab to be unseen when looking at Customer Maintenance/Inquiry. I cannot delete the tabs…
  • Hidden Field Is Still Showing

    Hello, I made a field hidden on the Lines tab grid of the Purchase Order Entry panel, yet it only shows hidden for me not other users. I made sure that the panel I made changes to was the All Companies/All Users customized panel. The only other changes…
  • 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…
  • customizing the invoices tab in customer maintenance

    Is it possible to change the order of the columns or delete a column not used in customer maintenance under the invoice tab We never use the Disc Date or the Discount amount is it possible to move them to the last columns or remove them from the view…
  • 2022 - Restoration of "Classic" performance.

    We have operated with the classic interface since 1995. Our people were very productive with the quick access across the top. Is there a way to keep the "Favorites" sticky. every time I start up, I have to activate the favorites tab. But then I lose…
  • 2022 upgrade - Sage intrusion - overall appearance

    We recently upgraded from 2019. We replaced the "welcome" image with our company banner. We felt that gave a more professional appearance throughout the company. We could also update our company through an easily managed text box we embedded into the…
  • 'Duplicate' Customized Panel?

    I've encountered a situation where, when launching the 'Customizer Panel Selection' window for a particular window (in this case Sales Order Entry), there are two lines representing the same customized panel (User ='All', Company = [Company Code]), but…
  • 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…
  • Setup limited access to records?

    Is it possible via scripting to do the following? Upon post-read of record, check a particular value on the order, then depending on that value, potentially 'kick' the user out of the record (prevent them from viewing it)?
  • Item Quantities on BM Detail

    What is the best way, if even possible, to get item quantities for each line to display in the grid in BM Maintenance? Even TotalQuantityOnHand would be fine. I made a sourced UDF but it only populates when the item code is validated. Maybe a button…
  • 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…
  • Print Invoice checkbox

    Can anyone explain this to me? Every time we use BOI to create an invoice (ScanForce or StarShip), the 'Print Invoice' checkbox on the invoice gets defaulted to "Y". Is there any way to change this?
  • global user bulletin board

    Hello, I'm not sure if this question is in the correct sub forum, but we're running sage 100 2017, and I am wondering if there is a way that we can create a type of bulletin board for all global users. We have these notes that all users need to know…
  • 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…
  • Customized Panels

    Hello All, Is there a way to tell what has been customized on a panel within the Custom Office. I need to make a change to ALL users S/O Header Panel but noticed there are several users already have a customize panel for S/O. And I would assume…
  • 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…