Sage 100

 View Only
  • 1.  Item Inquiry "You do not have security rights to modify the record"

    Posted 10-03-2022 16:00
    Just went live today on an upgrade from 2019 standard to 2022.1 standard.  All users in all companies are getting the message "You do not have security rights to modify the record" in item inquiry immediately after selecting an item from the ALE lookup.  Ive tried resetting the panels, turning on the esc flag, renaming the ###-### folder in IM\custom, renaimng the locks folder, running the 2 custom office utilities, logged on as Sage 100 user with all rights selected in the administrator role. . They have ScanForce and also the foreign currency extended solution that is maintained by Blytheco.  I spoke with ScanForce and their programs don't touch this.  I haven't yet contacted Blytheco.  Any ideas?​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Item Inquiry "You do not have security rights to modify the record"

    Posted 10-03-2022 16:07

    Does the message pop up if they are in item inquiry? The message sounds like something is being updated on the item, or maybe vendor or alias item table; but since it is user is on an inquiry screen it cannot be updated.

     

    Any scripting that might be trying to update a field on the item?

     

     

     

    Don't miss out on our 2022 Fall Sage 100 User Group: View the details

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     






  • 3.  RE: Item Inquiry "You do not have security rights to modify the record"

    Posted 10-03-2022 16:31
    Indeed, if it doesn't happen with Item Maintenance I'd suspect a script (UDS for the panel, or attached to CI_Item).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 4.  RE: Item Inquiry "You do not have security rights to modify the record"

    Posted 10-04-2022 08:28
    Maybe script needs something like:
    if oSession.StartProgram = "IM_ITEMINQUIRY_UI" then exit

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------



  • 5.  RE: Item Inquiry "You do not have security rights to modify the record"

    Posted 10-04-2022 21:30
    This is resolved.  There are no scripts so it wasn't scripts or any of the other 10 suspected causes I tried. I still don't know what was causing it but I found a solution, completely by trial and error.  I discovered that if I made a change in item maintenance, any change, then the message in item inquiry disappeared.  They are not using ci_item.category3 so I imported a 1 into category3 for every item.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 6.  RE: Item Inquiry "You do not have security rights to modify the record"

    Posted 10-04-2022 21:35
    Thanks @Lee Graham @Kevin Moyes and @David Overholt for the great suggestions.  This was a tough one.
    ​​​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------