Sage 100

 View Only
  • 1.  Global Custom Look-Ups (ALE)

    Posted 03-14-2019 09:27
    Is it possible to create a global look ups that are a.) available to everyone and \ or b.) available to only certain users. 

    Sage 100 2017 advanced. Thanks in advance

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------


  • 2.  RE: Global Custom Look-Ups (ALE)

    Posted 03-14-2019 09:32
    Library Master, Main, User Lookup Wizard allows you to create global look-ups for selected users.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 3.  RE: Global Custom Look-Ups (ALE)

    Posted 03-14-2019 09:39
    Thanks Doug, knew it was somewhere.

    ------------------------------
    John Wilder
    Technology Integrators
    ------------------------------



  • 4.  RE: Global Custom Look-Ups (ALE)

    Posted 03-14-2019 09:42
    Edited by Michelle Taylor 03-14-2019 09:41
    Be sure to name the Lookup something different than what any users currently have, as it will overwrite it.

    ------------------------------
    Michelle Taylor
    ERP Team Manager, CS3 Technology
    918-388-9772
    ------------------------------



  • 5.  RE: Global Custom Look-Ups (ALE)

    Posted 03-14-2019 10:07
    Edited by Doug Higgs 03-14-2019 10:07
    In User Maintenance there is a Customization Group field.  If you assign users the same customization group name, the customization group appears as a selection in the user code list in the User Lookup Wizard.  Using Customization Groups allows you to assign a group of users the same look-ups.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 6.  RE: Global Custom Look-Ups (ALE)

    Posted 03-14-2019 10:13
    To add to the others...  They have added the lookup wizard button to the bottom of all the ALE screens.  I find this very helpful vs finding the one I am looking for in the long (similarly named) list.

    Am I reading in @Michelle Taylor's post there is a way to create the "all" user "all" company lookup without loosing the currently configured "custom" lookups of the individual user?  My experience is when you setup a common, all of the individual customized setup by the user are lost.​

    ------------------------------
    Larry Bradford
    Accounting Technology LLC Consultant and Owner
    Accounting Technology, LLC
    Fairfax VA
    703-913-3500
    ------------------------------



  • 7.  RE: Global Custom Look-Ups (ALE)

    Posted 03-14-2019 10:16
    Well, I'm not certain if all existing individual ALE's are lost when a global one is created.  My experience has only been when one of the same name is created. I'm going to test this!

    ------------------------------
    Michelle Taylor
    ERP Team Manager, CS3 Technology
    918-388-9772
    ------------------------------



  • 8.  RE: Global Custom Look-Ups (ALE)

    Posted 03-14-2019 10:34
    What I've just found is that when a Global Lookup is created [in GL Account Maintenance] from the Lookup Wizard button at the bottom left of the lookup screen, the Standard Lookup was replaced.  The Wizard does not allow the new ALE  (Alternate Lookup Engine) to be named, therefore it is replacing the Standard.  There can be multiple ALE's for different User/Company combinations.  None of the existing ALE's were affected - good news.

    ------------------------------
    Michelle Taylor
    ERP Team Manager, CS3 Technology
    918-388-9772
    ------------------------------