x Want to participate? Join the group to interact

  • Display Inactive Item check box doesn't appear to do a darned thing

    I (on 2023 Std) and at least 2 clients on 2 different versions have tried to uncheck the Display Inactive Items check box and have it actually stop Inactive items from displaying in a lookup, but to no avail. The Inactive continue to show up. What, exactly…

  • Making an Explore view a shortcut

    I am wondering if there is a way to make a custom view from the business insights explorer a shortcut within the Explore Tab? am I able to put a custom view in here somehow as a shortcut?

  • How to find a work ticket number by using the sales order number

    Hi! I have been using SAGE for the past couple of years now; I still cannot figure out how to find a work ticket number if I only have the Sales order number. Can anyone help?

  • Is there a simple way to look up part number prices for a specific customer?

    Example: A customer calls and wants to know prices on several different parts. Is there a simple way to look up prices for their specific price level on multiple parts? Currently, I go to IM and look up the part number and then click on Price Lookup and…

  • BILL OF MATERIALS

    I'm new in the community and trying to catch up on so many things particularly the inventory management and purchasing. Is there any module that will customize the accumulation of the total component lines every sales order is entered into the system…

  • GL_DetailPosting - Linking GL account to Job Number

    Hi, I am trying to find a path from the GL detail back to the AP/PO data where Job number is recorded. Wanting a query to do this instead of having to manually track down the PO lines. Is the same Sequence Number field that appears in the GL_DetailPosting…

  • Duplicate Company Countries in Country Code Maintenance

    I am seeing duplicate countries in my country list under country code maintenance. For example it will show the country "France" twice with the codes "FR" and "FRA". What is best practice in removing these two digit country codes from the country list…

  • display separate quantities for each warehouse in item look up

    Hi there! I'm a fairly new Sage 100 user and work in a call center that handles sales for multiple warehouses. I get a lot of questions about the availability of products and in different sizes (which we use different item codes for). I would like…

  • Where do I find the KeyValues required to use find for IM_ItemVendor_svc

    Trying to get Standard Lead Time using : oItemVendSvc = oSession.GetObject("IM_ItemVendor_svc") if oItemVendSvc then retVal = oSession.AsObject(oSession.UI).Messagebox("","Able to set handle" & vendNo & itemCode) Set oItemVendSvc = oScript.AsObject…

  • Multiple Changes to Customers

    Hi, I need to change salesperson for multiple customers. Is there a way to do it as a bulk change or something? I've been going into Customer Maintenance and changing it one by one. it's taking forever! I went into Customer View in Explore under Accounts…

  • Script to update SO Header, as an invoice is being posted

    I'm trying to write a script to track (in a UDF) how much freight has been charged already for an SO. When I try to trigger the update on the SO Header table (filtered for oSession.Updating = 1), using the LastInvoiceOrderNo, it doesn't work because…

*Community Hub is the new name for Sage City